Bug #758 (closed)
Opened 17 years ago
Closed 17 years ago
PostgreSQL 7.4 Install Failure
Reported by: | cxallan | Owned by: | jamoore |
---|---|---|---|
Priority: | major | Cc: | |
Sprint: | n.a. | ||
Total Remaining Time: | n.a. |
Description
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';
Change History (2)
comment:1 Changed 17 years ago by jmoore
comment:2 Changed 17 years ago by jmoore
- Resolution set to fixed
- Status changed from new to closed
Have heard no issues. Closing.
Note: See
TracTickets for help on using
tickets.
You may also have a look at Agilo extensions to the ticket.
r1720 should close. Needs testing.