[Prelude Hybrid IDS] #271: Error in PostgreSQL schema upgrade (14.7)
"Prelude Hybrid IDS" <[email protected]>
| Newsgroups | gmane.comp.security.ids.prelude.devel |
|---|---|
| Message-ID | <[email protected]> |
#271: Error in PostgreSQL schema upgrade (14.7)
--------------------------+-------------------------------------------------
Reporter: pollux | Owner: yoann
Type: defect | Status: new
Priority: normal | Milestone:
Component: libpreludedb | Version: 0.9
Severity: major | Keywords:
--------------------------+-------------------------------------------------
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;
}}}
--
Ticket URL: <https://trac.prelude-ids.org/ticket/271>
Prelude Hybrid IDS <http://www.prelude-ids.org>
The Prelude Hybrid Intrusion Detection System suite
_______________________________________________
Prelude-devel site list
[email protected]
http://www.prelude-ids.org/mailman/listinfo/prelude-devel