Anyone using PostgreSQL with CFMX? Have you run into any problems? I have just spent several hours trying to get a client variables database working. This is the result of my efforts (might be useful to someone?)
CFMX can't create a client variables database automatically. I get a "Your data source requires you to manually create the necessary database tables to store your client variables. See the Online Help for details. " message. The SQL coldfusion is using is this: CREATE TABLE cdata (cfid char(64), app char(64), data text); CREATE UNIQUE INDEX cdata_cfid_app_uidx ON cdata (cfid,app); CREATE TABLE cglobal (cfid char(64), data text, lvisit datetime ); CREATE INDEX cglobal_cfid_idx ON cglobal (cfid); CREATE INDEX cglobal_lvisit_idx ON cglobal (lvisit); This is fine for PostgreSQL 7.1.3 But PostgreSQL 7.3.2 doesn't have the data type "datetime". So you need to replace it with "timestamp". It seems to work OK. Now a question: I'm using the JDBC driver pg73jdbc2.jar which I downloaded from http://jdbc.postgresql.org/download.html The choices are pg73jdbc1.jar pg73jdbc2.jar pg73jdbc3.jar and pg73jdbc2ee.jar Which is the best one to use? And more importantly, why.... Thanks, David http://mobile.yahoo.com.au - Yahoo! Mobile - Exchange IMs with Messenger friends on your Telstra or Vodafone mobile phone. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
