From: J. C. <ad...@di...> - 2001-12-08 12:35:56
|
Very nice! You could send that to me and I'll forward it to the data group. We are working on getting rid of the reserved names in the DB as we redesign and clean the DB. ----- Original Message ----- From: Enslaver . <ens...@ho...> To: <pos...@li...> Sent: Thursday, December 06, 2001 1:11 PM Subject: [Post-nuke-users] Postgresql Migration > 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 > > > _______________________________________________ > Post-nuke-users mailing list > Pos...@li... > https://lists.sourceforge.net/lists/listinfo/post-nuke-users > > |