CREATE TABLE ... INHERITS (parent INCLUDING xxx)
От
Itagaki Takahiro
Тема
CREATE TABLE ... INHERITS (parent INCLUDING xxx)
Дата
Msg-id
20091030172549.3CA6.52131E4D@oss.ntt.co.jp
Список
Дерево обсуждения
CREATE TABLE ... INHERITS (parent INCLUDING xxx) Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Re: CREATE TABLE ... INHERITS (parent INCLUDING xxx) Tom Lane <tgl@sss.pgh.pa.us>
Re: CREATE TABLE ... INHERITS (parent INCLUDING xxx) Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>
We have two ways to copy table definitions: - CREATE TABLE child ( LIKE parent ) - CREATE TABLE child ( ) INHERITS ( parent ) But "INCLUDING xxx" is supported only in "LIKE" version. Should we have "INHERITS ( parent INCLUDING xxx )" syntax ? We can use LIKE and INHERITS at once: CREATE TABLE chld ( LIKE parent INCLUDING ALL ) INHERITS (parent) but will have annoying log messages: NOTICE: merging column "..." with inherited definition Since partitioning syntax are rewritten into INHERITS and INCLUDING ALL internally, eliminating such logs will be better. CREATE TABLE LIKE + ALTER TABLE INHERIT can solve the issue, but direct solutions are welcome. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center
В списке pgsql-hackers по дате отправления