Re: ALTER TABLE...ALTER COLUMN vs inheritance

Поиск
Список
Период
Сортировка
Искать
От
Bernd Helmle
Тема
Re: ALTER TABLE...ALTER COLUMN vs inheritance
Дата
Msg-id
955F56897252563E8FAA8C89@[172.26.14.62]
Ответ на
Список
Дерево обсуждения
ALTER TABLE...ALTER COLUMN vs inheritance Bernd Helmle <mailings@oopsware.de>
Re: ALTER TABLE...ALTER COLUMN vs inheritance Tom Lane <tgl@sss.pgh.pa.us>
Re: ALTER TABLE...ALTER COLUMN vs inheritance Bernd Helmle <mailings@oopsware.de>
Re: ALTER TABLE...ALTER COLUMN vs inheritance Selena Deckelmann <selenamarie@gmail.com>
Re: ALTER TABLE...ALTER COLUMN vs inheritance Bernd Helmle <mailings@oopsware.de>
Re: ALTER TABLE...ALTER COLUMN vs inheritance Bernd Helmle <mailings@oopsware.de>
Re: ALTER TABLE...ALTER COLUMN vs inheritance Bernd Helmle <mailings@oopsware.de>
Re: ALTER TABLE...ALTER COLUMN vs inheritance Bernd Helmle <mailings@oopsware.de>
Re: ALTER TABLE...ALTER COLUMN vs inheritance Bernd Helmle <mailings@oopsware.de>
Re: ALTER TABLE...ALTER COLUMN vs inheritance Tom Lane <tgl@sss.pgh.pa.us>
Re: ALTER TABLE...ALTER COLUMN vs inheritance Alex Hunsaker <badalex@gmail.com>
Re: ALTER TABLE...ALTER COLUMN vs inheritance Tom Lane <tgl@sss.pgh.pa.us>
Re: ALTER TABLE...ALTER COLUMN vs inheritance Alex Hunsaker <badalex@gmail.com>
Re: ALTER TABLE...ALTER COLUMN vs inheritance Tom Lane <tgl@sss.pgh.pa.us>
Re: ALTER TABLE...ALTER COLUMN vs inheritance Alex Hunsaker <badalex@gmail.com>
Re: ALTER TABLE...ALTER COLUMN vs inheritance Bernd Helmle <mailings@oopsware.de>


--On 15. Juni 2010 20:51:21 -0700 Selena Deckelmann  
wrote:

> Confirmed that this tests fine against commit id
> 0dca7d2f70872a242d4430c4c3aa01ba8dbd4a8c
>
> I also wrote a little test script and verified that it throws an error
> when I try to remove a constraint from the parent table.
>

Thanks for looking at this.

Please note that the main purpose of this patch is to protect *child* 
tables against dropping NOT NULL constraints inherited from a parent table. 
This could lead to unrestorable dumps formerly.


> Should an explicit test be added for this?
>

I think so, yes.

> There are some spelling and grammar errors in comments that I can help
> fix if you want the help.

You're welcome. I have pushed my branch to my git repos as well, if you 
like to start from there:




-- 
Thanks
Bernd

В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
От: Joshua D. Drake
Дата:
Сообщение: Re: New PGXN Extension site
FAQ