[Post-nuke-users] Postgresql Migration

[Enslaver . <ens...@ho...>]

I sucessfully got postnuke working with postgresql. It was pretty easy, You 
just have to re-write the rogue.sql. Some of the field types must be 
changed. For instance int cannot be a specified length and must be int4 
(usally). double must be change into float8, and datetime is now timestamp, 
It will still import datetime but will give you an error if your using the 
old time format (YYYY-MM-DD), You must use the new format (MM-DD-YYYY). Also 
in nuke_blocks the field "position" is a reserved postgres field. I changed 
that to position1 and updated pntables.

Also the PHP code must be changed, In postgres you cannot use $column in 
SET's, I've changed around the main files but havent gotten around to the 
modules yet. You might want to concider this in your future coding.

-Enslaver
ens...@ho...

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp