Re: Cannot add non-null columns - Mailing list pgadmin-support

From Andreas Pflug
Subject Re: Cannot add non-null columns
Date
Msg-id 4162CF0A.60509@pse-consulting.de
Whole thread Raw
In response to Re: Cannot add non-null columns  (teknokrat <teknokrat@yahoo.com>)
Responses Re: Cannot add non-null columns
List pgadmin-support
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.

Regards,
Andreas


pgadmin-support by date:

Previous
From: Andreas Pflug
Date:
Subject: Re: postgres help
Next
From: "Virgil Frum"
Date:
Subject: Re: Cannot add non-null columns