Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Hackers > Table inheritan...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 4 Topic 9322 of 9685
Post > Topic >>

Table inheritance surprise

by david@[EMAIL PROTECTED] (David Fetter) May 7, 2008 at 02:52 PM

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@[EMAIL PROTECTED]
> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@[EMAIL PROTECTED]
 to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
 




 4 Posts in Topic:
Table inheritance surprise
david@[EMAIL PROTECTED]   2008-05-07 14:52:08 
Re: Table inheritance surprise
bruce@[EMAIL PROTECTED]   2008-06-26 18:53:05 
Re: Table inheritance surprise
simon@[EMAIL PROTECTED]   2008-06-27 13:11:56 
Re: Table inheritance surprise
tgl@[EMAIL PROTECTED] (T  2008-06-27 18:08:06 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Tue Jul 8 23:56:58 CDT 2008.