RE: ADD/DROP CONSTRAINT and inheritance

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема RE: ADD/DROP CONSTRAINT and inheritance
Дата
Msg-id Pine.BSF.4.21.0105232156040.71051-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на RE: ADD/DROP CONSTRAINT and inheritance  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Список pgsql-hackers
> > Seems like a bad idea to
> > me.  But as long as the default is to propagate these changes, I'm not
> > really eager to prohibit DBAs from doing the other.  Who's to say what's
> > a misuse of inheritance and what's not...
> 
> At the moment we have:
> 
> * ADD CONSTRAINT does not propagate
> * If you create a table with a CHECK constraint, then create a table that
> inherits from that, the CHECK constraint _does_ propagate.
> 
> Seems to me that these behaviours are inconsistent...

Yep, but I've got the minimal patch to fix ADD CONSTRAINT.  I'm just
waiting for the upcoming weekend so I can add the regression tests and
pack it up.



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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: DROP CONSTRAINT patch
Следующее
От: Oleg Bartunov
Дата:
Сообщение: Re: Rtree; cannot create index on polygons with lots of points