Details
-
Bug
-
Resolution: Fixed
-
Blocker
-
5.0.0rc1
-
Operating System: RHEL 6.3
PHP Version: 5.3.3
Database and version: Posgres 8.4.13
Browser (and version): Firefox 16.0
Description
When I try to import update/database/postgresql/5.0/unstable/dbupdate-4.7.0-to-5.0.0alpha1.sql to my Postgres database I get the following errors
"
ERROR: syntax error at or near "ALTER"
LINE 7: ALTER TABLE ezgeneral_digest_user_settings ADD user_id integ...
^
DELETE 0
ERROR: column "user_id" of relation "ezgeneral_digest_user_settings" does not exist
LINE 1: UPDATE ezgeneral_digest_user_settings SET user_id = (SELECT ...
^
ERROR: column "user_id" does not exist
ALTER TABLE
CREATE INDEX
"
I used today's build (6 Nov 2012) #89
The command I used to import the update was
psql -U ezp -d ezp -W < update/database/postgresql/5.0/unstable/dbupdate-4.7.0-to-5.0.0alpha1.sql