PostgreSQL 7.4 Install Failure

[cxallan]

During the execution of data.sql we get a SQL syntax error:

callan@runemaster psql $ psql omero-test < OMERO3__4__data.sql 
BEGIN
SET CONSTRAINTS
NOTICE:  ALTER TABLE / ADD UNIQUE will create implicit index "unique_dbpatch" for table "dbpatch"
ALTER TABLE
ERROR:  syntax error at or near "," at character 64

This can be digested to the following line of SQL:

--
-- Since this is a table that we will be using in DB-specific ways, we're also going
-- to make working with it a bit simpler.
--
alter table dbpatch alter id set default nextval('seq_dbpatch'),
                    alter permissions set default -35,
                    alter message set default 'Updating';

Basically, PostgreSQL didn't support multiple column modifications in a single statement until 8.0. So, this probably needs to be changed to:

alter table dbpatch alter id set default nextval('seq_dbpatch');
alter table dbpatch alter permissions set default -35;
alter table dbpatch alter message set default 'Updating';

[jmoore]

r1720 should close. Needs testing.

[jmoore]

Have heard no issues. Closing.