| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-06-27 22:31:55 | Re: Vacuuming leaked temp tables (once again) |
| Previous Message | Tom Lane | 2008-06-27 22:00:56 | Re: VirtualXactLockTableInsert |