[Tickets #1028] NEW: sql update script

[bugs at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/?id=1028
-----------------------------------------------------------------------
 Ticket     | 1028
 Created By | klowther at cisnet.com
 Summary    | sql update script
 Queue      | Kronolith
 Version    | HEAD
 State      | Unconfirmed
 Priority   | 1. Low
 Type       | Bug
 Owners     | 
-----------------------------------------------------------------------


klowther at cisnet.com (2004-12-29 04:30) wrote:

The sql update script for uid_event does not seem to work for Postgresql. 

[postgres at visit upgrades]$ psql -d horde -f 2004-12-21_add_event_uid.sql
DEBUG:  InitPostgres
psql:2004-12-21_add_event_uid.sql:3: DEBUG:  StartTransactionCommand
psql:2004-12-21_add_event_uid.sql:3: DEBUG:  ProcessUtility
psql:2004-12-21_add_event_uid.sql:3: DEBUG:  AbortCurrentTransaction
psql:2004-12-21_add_event_uid.sql:3: ERROR:  adding NOT NULL columns is not
implemented
HINT:  Add the column, then use ALTER TABLE SET NOT NULL.
psql:2004-12-21_add_event_uid.sql:4: DEBUG:  StartTransactionCommand
psql:2004-12-21_add_event_uid.sql:4: DEBUG:  ProcessUtility
psql:2004-12-21_add_event_uid.sql:4: DEBUG:  AbortCurrentTransaction
psql:2004-12-21_add_event_uid.sql:4: ERROR:  column "event_uid" does not
exist

Database is my weak point, but I used the GUI in Webmin to add the colum
using the paramaters in the script.  I then reran the script and it seems to
have worked.

ken