[dev] [cvs] commit: kronolith/scripts/upgrades 2.1_to_2.2.pgsql.sql
Eric Jon Rostetter
eric.rostetter at physics.utexas.edu
Sat Dec 29 18:31:41 UTC 2007
Quoting Jan Schneider <jan at horde.org>:
> Can you please try if this version of the script would do it too:
> http://cvs.horde.org/diff.php/kronolith/scripts/upgrades/2.1_to_2.2.sql?r1=1.1&r2=1.2&ty=u
>
> Jan.
ERROR: Adding columns with defaults is not implemented.
Add the column, then use ALTER TABLE SET DEFAULT.
Above is with rh-postgresql-server-7.3.15-2 (RHEL 3). Maybe a newer
postgres version would do better with it...
--
Eric Rostetter
The Department of Physics
The University of Texas at Austin
Go Longhorns!
More information about the dev
mailing list