Josh, I don't know about "hooray!!!". We did something similar about 6 months ago and have run into a number of issues. One that pops to mind is the "Query string is too long" bug(?) in PostgreSQL. Make sure you have the latest drivers and that you use <cfqueryparam> everywhere.
good luck.. -----Original Message----- From: jt [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 11:34 AM To: CF-Linux Subject: RE: snagging the recently created PK of a record in MySQL - Help? Hello, I am moving a DB from MS SQL Server 2000 to PostgreSQL (hooray!!!). Any tips or tricks to share? I am especially interested in how to auto-increment ids in Postgresql, if there are any caveats, and how to transfer the data over after the tables and such are built. Thanks, Josh ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
