Re: CREATE TABLE ... INHERITS (parent INCLUDING xxx)

Поиск
Список
Период
Сортировка
От Itagaki Takahiro
Тема Re: CREATE TABLE ... INHERITS (parent INCLUDING xxx)
Дата
Msg-id 20091102165559.C6C7.52131E4D@oss.ntt.co.jp
обсуждение исходный текст
Ответ на Re: CREATE TABLE ... INHERITS (parent INCLUDING xxx)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp> writes:
> > Should we have "INHERITS ( parent INCLUDING xxx )" syntax ?
> 
> No.  That would imply that the user has some control over what is
> inherited and what isn't, which would be a complete mess.

Hmmm, but users can already control using LIKE INCLUDING clause what is
inherited and what isn't. Also, we don't inherit anything from INHERITS
clause in default. We have nothing to lose even if we support INHERITS
+ INCLUDING, no?  And there are certain merits; we can avoid unexpected
log messages and don't have to repeat the parent name in DDL.

Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center




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

Предыдущее
От: Itagaki Takahiro
Дата:
Сообщение: Re: Patch for automated partitioning
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: operator exclusion constraints