From: | "Virgil Frum" <virgil(at)netappi(dot)com> |
---|---|
To: | <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Cannot add non-null columns |
Date: | 2004-10-05 17:47:04 |
Message-ID: | 008601c4ab03$53e11cd0$310210ac@virgil |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Your crystal ball is brilliant. I've tested using PostgreSQL 7.4.2 (SUSE
9.1), and that's the message:
ERROR: adding NOT NULL columns is not implemented
HINT: Add the column, then use ALTER TABLE SET NOT NULL.
Would be great if error messages could be selected and copy/pasted in
message (like Address line of url properties from web brosers).
Regards,
Virgil
----- Original Message -----
From: "Andreas Pflug" <pgadmin(at)pse-consulting(dot)de>
To: "teknokrat" <teknokrat(at)yahoo(dot)com>
Cc: <pgadmin-support(at)postgresql(dot)org>
Sent: Tuesday, October 05, 2004 7:42 PM
Subject: Re: [pgadmin-support] Cannot add non-null columns
>
> <hint level="discreet">
> My crystal ball tells me you're not using PostgreSQL 8.0....
> </hint>
>
> I just checked adding the non-null column from the table properties,
> this works (for an 8.0 server).
>
> Seems we need special 7.x handling.
From | Date | Subject | |
---|---|---|---|
Next Message | teknokrat | 2004-10-05 18:10:52 | Re: Cannot add non-null columns |
Previous Message | Andreas Pflug | 2004-10-05 16:42:50 | Re: Cannot add non-null columns |