Re: CREATE TABLE LIKE INCLUDING INDEXES support

"Tom Lane" <tgl@sss.pgh.pa.us> writes:

> NikhilS <nikkhils@gmail.com> writes:
>> I just now realized that even though we allow the above. We do not allow:
>
>> pg=# create table t1 (a int, b int, unique(a+b));
>
>> Any specific reason for this behaviour?
>
> It'd be contrary to SQL spec.  The UNIQUE constraint takes a list of
> column names, full stop.

Does the SQL spec actually specify what happens if you provide an
non-compliant table definition like this?

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com