CREATE TABLE ... INHERITS (parent INCLUDING xxx)
- From: Itagaki Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
- To: pgsql-hackers(at)postgresql(dot)org
- Subject: CREATE TABLE ... INHERITS (parent INCLUDING xxx)
- Date: Fri, 30 Oct 2009 17:25:49 +0900
- Message-id: <20091030172549.3CA6.52131E4D@oss.ntt.co.jp> <text/plain>
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
Home |
Main Index |
Thread Index