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.
NTT Open Source Software Center
pgsql-hackers by date
|Next:||From: Hitoshi Harada||Date: 2009-10-30 11:44:52|
|Subject: Re: half OOT, plv8js group created ^^|
|Previous:||From: Peter Eisentraut||Date: 2009-10-30 08:03:00|
|Subject: Re: Syntax for partitioning|