Re: [otrs] postresql update

On Thursday, January 29, 2004 2:29 PM Hans Scheffers wrote:

CREATE TABLE =# alter table tmp add column col2 varchar(10) not null; ERROR: Adding NOT NULL columns is not implemented. Add the column, then use ALTER TABLE ... SET NOT NULL. =#

Am I getting you right, the PostGreSQL-Update doesn't run through unless you manually change the source code to no longer include any 'add column xyz type(n) NOT NULL'? This were a nasty bug indeed... Could I get you to open a bug report on http://bugs.otrs.org/ ? Thank you very much, Robert Kehl -- ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Tel. +49 (0)6172 4832388