Bug #271
Error in PostgreSQL schema upgrade (14.7)
Start date:
Due date:
% Done:
0%
Resolution:
fixed
Description
File pgsql-update-14-7.sql (for classic) contains following SQL instruction:
ALTER TABLE Prelude_Impact ALTER COLUMN description TYPE VARCHAR(255) NULL;
The 'NULL' keyword at end is illegal and causes an upgrade error. If the idea is not set a default NULL value, you should use:
ALTER TABLE Prelude_Impact ALTER COLUMN description SET DEFAULT NULL;
If this means allowing null (as a constraint), use:
ALTER TABLE Prelude_Impact ALTER COLUMN description DROP NOT NULL;
History
#1 Updated by Yoann VANDOORSELAERE over 16 years ago
- Status changed from New to Assigned
#2 Updated by Yoann VANDOORSELAERE over 16 years ago
- Status changed from Assigned to Closed
- Resolution set to fixed
(In r10115) Drop 'NOT NULL' constraint with a separate query (Fix #271).
Thanks to Pierre Chifflier <p.chifflier@inl.fr> for pointing this out.
#3 Updated by Yoann VANDOORSELAERE almost 15 years ago
- Project changed from PRELUDE SIEM to LibpreludeDB
- Category deleted (
2) - Target version deleted (
0.9.14.1)