Table inheritance surprise - Mailing list pgsql-hackers

From David Fetter
Subject Table inheritance surprise
Date
Msg-id 20080507215208.GF15867@fetter.org
Whole thread Raw
Responses Re: Table inheritance surprise
Re: Table inheritance surprise
List pgsql-hackers
Folks,

When I do CREATE TABLE foo(LIKE bar INCLUDING CONSTRAINTS), it doesn't
include foreign key constraints (8.3.1).  I believe this is surprising
behavior, but maybe not a bug, so I'd like to propose another bit of
syntactic sugar, namely
   LIKE [INCLUDING FOREIGN KEYS]

which would do what it looks like it does.

What say?

Cheers,
David.
-- 
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [pgsql-www] [ADMIN] 8.2.4 patches? (fwd)
Next
From: David Fetter
Date:
Subject: Auto-updated fields