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

Collapse
1: .ctl datafile problem in ref-timezones package
Posted by Peter Marklund on 08/29/03 09:45 AM
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?

Collapse
2: Re: .ctl datafile problem in ref-timezones package (response to 1)
Posted by Lars Pind on 09/02/03 04:06 PM
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!

/Lars