[dev] [cvs] commit: kronolith/scripts/upgrades 2.1_to_2.2.pgsql.sql

[Jan Schneider]

Zitat von Eric Jon Rostetter <eric.rostetter at physics.utexas.edu>:

> 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...

How about:

ALTER TABLE kronolith_events ADD COLUMN event_private INT NOT NULL;
ALTER TABLE kronolith_events ALTER COLUMN event_private SET DEFAULT 0;
ALTER TABLE kronolith_events ADD COLUMN event_recurcount INT;

Jan.

-- 
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/