Re: [otrs] postresql update

Not an URL, i will have to look that up; but from postgresql self: Welcome to psql 7.3.4, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit =# create table tmp ( (# col1 varchar(10) (# ) -# ; 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. =# On Wed, 2004-01-28 at 20:42, Robert Kehl wrote:

On Wednesday, January 28, 2004 1:16 PM Hans Scheffers wrote:

...

I think in the update scripts for postgres there is an error. Twice there is a column added with attribute 'NOT NULL'. This isn't allowed in postgres, first you have to add the column and after that you should alter it with ' alter table alter column set not null'

Could you quote a URL as source of this info?

Thank you,

Robert Kehl -- Hans Scheffers JifLin Automatisering email:hans@jiflin.nl web: http://www.jiflin.nl