Re: Cannot add non-null columns

Поиск
Список
Период
Сортировка
От teknokrat
Тема Re: Cannot add non-null columns
Дата
Msg-id cjuo3a$22l$1@news.hub.org
обсуждение исходный текст
Ответ на Re: Cannot add non-null columns  (Andreas Pflug <pgadmin@pse-consulting.de>)
Список 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


В списке pgadmin-support по дате отправления:

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