CREATE TABLE ... LIKE composite type - Mailing list pgsql-hackers

From Mark Gibson
Subject CREATE TABLE ... LIKE composite type
Date
Msg-id 40D2BEC4.9000700@cromwell.co.uk
Whole thread Raw
Responses Re: CREATE TABLE ... LIKE composite type
List pgsql-hackers
Hi,   Is there any reason that the following shouldn't work:

CREATE TABLE my_new_table (LIKE my_composite_type);

I get the following error (in 7.4.2):

ERROR:  "my_composite_type" is a composite type

With the improved handling of composite types,
will this work in 7.5?

Cheers
-- 
Mark Gibson <gibsonm |AT| cromwell |DOT| co |DOT| uk>
Web Developer & Database Admin
Cromwell Tools Ltd.
Leicester, England.


pgsql-hackers by date:

Previous
From: "Zeugswetter Andreas SB SD"
Date:
Subject: Re: signal 11 on AIX: 7.4.2
Next
From: Andrew Sullivan
Date:
Subject: Re: signal 11 on AIX: 7.4.2