Issue Bug Closed

#15472alter table with default value does not work in postgres7

Christian Welzel 01/20/06, 22:56 updated 08/12/06, 14:20

Description

Hi!
Tested some things with 4.0beta dbal and found out, that installation of realurl does not work properly. the query

ALTER TABLE pages ADD tx_realurl_pathsegment varchar(30) NOT NULL default ‘’;

results in an error

FEHLER: Spalten mit Vorgabewerten hinzuzufügen ist nicht implementiert
HINT: Fügen Sie die Spalte hinzu und verwenden Sie dann ALTER TABLE SET DEFAULT.

(adding columns with default values is not implemented. use alter table set default).

system is debian stable with postgresql 7.4.7, apache 2.0.54 and php 4.3.10.

(issue imported from #M2340)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.