Forum OpenACS Development: .ctl datafile problem in ref-timezones package

I am about to set up the test servers for .LRN 2.0 and the PG install failed. One of the reasons for the failure was a problem with the datafile loading in the ref-timezones package.

Strangely enough, I can install the ref-timezones package on one of our servers with PG 7.2.4 but not on the test server  one with PG 7.2.2. The statement

db_load_sql_data /web/server_name/packages/ref-timezones/sql/postgresql/00-timezones.ctl

works fine on the PG 7.2.4 server but fails with the following message on the other:

ERROR:  parser: parse error at or near "delimiter"

    invoked from within
"db_load_sql_data /web/dotlrn20-pg-test/packages/ref-timezones/sql/postgresql/00-timezones.ctl"
    ("uplevel" body line 2)
    invoked from within

Any clues? Don? I could try with PG 7.3 but I guess we want to support PG 7.2.2 still, no?

Posted by Lars Pind on
Looks like the PG team changed the syntax of COPY between 7.2 and 7.3 (thanks, guys), so I've written a new statement that has [ad_decode [db_version] ...] in it to accomodate both.

Example: 7.2 used keyword 'delimiters', 7.3 uses 'delimiter' without the s!