Skip site navigation (1) Skip section navigation (2)

Re: Table inheritance surprise

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Bruce Momjian <bruce(at)momjian(dot)us>, David Fetter <david(at)fetter(dot)org>, PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Table inheritance surprise
Date: 2008-06-27 22:08:06
Message-ID: 12289.1214604486@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Simon Riggs <simon(at)2ndquadrant(dot)com> writes:
> On Thu, 2008-06-26 at 18:53 -0400, Bruce Momjian wrote:
>> TODO has:
>> 
>> o Allow inherited tables to inherit indexes, UNIQUE constraints,
>> and primary/foreign keys

But that TODO item is about inheritance, which has approximately
zip to do with CREATE TABLE LIKE.

> INCLUDING CONSTRAINTS is non-standard so maybe we can just make
> INCLUDING CONSTRAINTS also include foreign keys.

In a green field that would probably make sense, but it'd create
a significant backward compatibility problem to do it now.
Undoubtedly there are apps depending on the current behavior of
LIKE INCLUDING CONSTRAINTS.  (If there are not, then the feature is
useless and we should take it out instead of extending it.)

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2008-06-27 22:31:55
Subject: Re: Vacuuming leaked temp tables (once again)
Previous:From: Tom LaneDate: 2008-06-27 22:00:56
Subject: Re: VirtualXactLockTableInsert

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group