Opened 6 years ago
Closed 5 years ago
#1484668 closed Bugs (fixed)
Postgresql upgrade script syntax isn't valid for ALTER TABLE
| Reported by: | matt | Owned by: | |
|---|---|---|---|
| Priority: | 4 | Milestone: | 0.1-stable |
| Component: | Database | Version: | 0.1-rc2 |
| Severity: | normal | Keywords: | |
| Cc: |
Description
The update script in 1.0rc2 has:
ALTER TABLE "identities" ADD html_signature integer DEFAULT 0 NOT NULL;
except that syntax isn't valid (at least for 7.4 that I'm using). Something better might be:
ALTER TABLE "identities" ADD html_signature;
ALTER TABLE "identities" ALTER html_signature SET DEFAULT 0;
UPDATE identities SET html_signature = 0;
ALTER TABLE "identities" ALTER html_signature SET NOT NULL;
(the required UPDATE is a bit ugly, not sure a better way).
Change History (3)
comment:1 Changed 6 years ago by matt
comment:2 Changed 6 years ago by thomasb
- Milestone set to 0.1-stable
comment:3 Changed 5 years ago by thomasb
- Resolution set to fixed
- Status changed from new to closed
Fixed in [6223e957]
Note: See
TracTickets for help on using
tickets.

Again for formatting: