From: | teknokrat <teknokrat(at)yahoo(dot)com> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: Cannot add non-null columns |
Date: | 2004-10-05 18:10:52 |
Message-ID: | cjuo3a$22l$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Andreas Pflug wrote:
> teknokrat wrote:
>
>>
>> Sorry, I wasn't clear. This is an empty table. After creating it, I
>> wanted to add some more columns. I used the properties of the table to
>> try adding them but this failed. I then went to the column view and
>> added them one at a time and that worked. This behaviour is
>> inconsistent and should be fixed. There was no data in the table when
>> I did this.
>
>
> <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.
You're absolutely right, I'm on 7.4.1
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Pflug | 2004-10-06 09:24:33 | Re: Cannot add non-null columns |
Previous Message | Virgil Frum | 2004-10-05 17:47:04 | Re: Cannot add non-null columns |