Description
[avisbits@bitmag-devel01 postgres]$ psql -d alarmservicedb -f alarmServiceDB3to4migration.sql
UPDATE 1
UPDATE 1
ALTER TABLE
DROP INDEX
UPDATE 2692
ALTER TABLE
psql:alarmServiceDB3to4migration.sql:37: ERROR: syntax error at or near "RENAME"
LINE 1: RENAME COLUMN alarm.alarm_date2 TO alarm_date;
^
psql:alarmServiceDB3to4migration.sql:39: ERROR: column "alarm_date" of relation "alarm" does not exist
psql:alarmServiceDB3to4migration.sql:41: ERROR: column "alarm_date" does not exist
The migration script fails after a rename column fails due to usage of derby-sql syntax.
To fix the migration run:
ALTER TABLE alarm RENAME COLUMN alarm_date2 TO alarm_date; ALTER TABLE alarm ALTER COLUMN alarm_date SET NOT NULL; CREATE INDEX alarmdateindex ON alarm (alarm_date);