Re: Cannot add non-null columns

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: teknokrat <teknokrat(at)yahoo(dot)com>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Cannot add non-null columns
Date: 2004-10-05 16:42:50
Message-ID: 4162CF0A.60509@pse-consulting.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Virgil Frum 2004-10-05 17:47:04 Re: Cannot add non-null columns
Previous Message Andreas Pflug 2004-10-05 16:12:01 Re: postgres help