7.3.3 ADD COLUMN wierdness

Поиск
Список
Период
Сортировка
От Brian O'Donoghue
Тема 7.3.3 ADD COLUMN wierdness
Дата
Msg-id COEDIADJBHCFBMAMDEBBAEGJCAAA.bodonoghue@stockbyte.com
обсуждение исходный текст
Ответы Re: 7.3.3 ADD COLUMN wierdness  (Rod Taylor <rbt@rbt.ca>)
Re: 7.3.3 ADD COLUMN wierdness  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
I'm running two different strains of PostgreSQL

7.1.3, which is what our website is running off of now and 7.3.3, which we
hope to move to (sometime).

In 7.1.3 I can say

ALTER TABLE blah ADD COLUMN whatever integer not null;

and as expected, that works fine

on 7.3.3

the same command returns
Adding NOT NULL columns is not implemented.
        Add the column, then use ALTER TABLE ... SET NOT NULL.

Hmm, the last time I checked, this should have worked.
Is this a bug or a feature?

If it's a feature, can I turn it off, because this is a hassel.


________________________________________________________________________
This email has been scanned for all viruses by the MessageLabs Email
Security System. For more information on a proactive email security
service working around the clock, around the globe, visit
http://www.messagelabs.com
________________________________________________________________________

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

Предыдущее
От: Serge Obeuf
Дата:
Сообщение: Re: pg_dumpall not working in batch
Следующее
От: Rod Taylor
Дата:
Сообщение: Re: 7.3.3 ADD COLUMN wierdness