Re: Cannot add non-null columns

Поиск
Список
Период
Сортировка
От Andreas Pflug
Тема Re: Cannot add non-null columns
Дата
Msg-id 4162CF0A.60509@pse-consulting.de
обсуждение исходный текст
Ответ на Re: Cannot add non-null columns  (teknokrat <teknokrat@yahoo.com>)
Ответы Re: Cannot add non-null columns  (teknokrat <teknokrat@yahoo.com>)
Список 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 по дате отправления:

Предыдущее
От: Andreas Pflug
Дата:
Сообщение: Re: postgres help
Следующее
От: "Virgil Frum"
Дата:
Сообщение: Re: Cannot add non-null columns