2009/8/21 Heikki Linnakangas <heikki.linnakan...@enterprisedb.com>: > Jeff Davis wrote: >> I'm leaning toward not allowing it at CREATE TABLE time. > > Seems reasonable to me too. >
+1 There are plenty of other things to do with tables that you can't mix directly into a CREATE TABLE statement (grant permissions, create triggers, change owner, to name a few) so this would not be a surprise -- or a hardship -- for users IMO. As an aside, Jeff, have you considered how this feature would interact with CREATE TABLE ... LIKE parent_table [ { INCLUDING | EXCLUDING } { DEFAULTS | CONSTRAINTS | INDEXES } ] ... }? What if someone asks to include indexes but not constraints? Vice-versa? Will these cases be handled gracefully? Cheers, BJ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers