| Summary | sql update script |
| Queue | Kronolith |
| Queue Version | HEAD |
| Type | Bug |
| State | Resolved |
| Priority | 1. Low |
| Owners | |
| Requester | klowther (at) cisnet (dot) com |
| Created | 12/29/2004 (7637 days ago) |
| Due | |
| Updated | 12/31/2004 (7635 days ago) |
| Assigned | |
| Resolved | 12/31/2004 (7635 days ago) |
| Github Issue Link | |
| Github Pull Request | |
| Milestone | |
| Patch | No |
State ⇒ Resolved
State ⇒ Unconfirmed
Priority ⇒ 1. Low
Type ⇒ Bug
Summary ⇒ sql update script
Queue ⇒ Kronolith
[postgres@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