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.

Fri, 18 Jun 2004 11:07:00 +0100
Mark Gibson <gibsonm@cromwell.co.uk>
CREATE TABLE ... LIKE composite type
Mark Gibson <gibsonm@cromwell.co.uk> writes:
> Is there any reason that the following shouldn't work:

> CREATE TABLE my_new_table (LIKE my_composite_type);

Probably not.  I can think of reasons why we might not want to let you
INHERIT from a composite type, but LIKE is just a one-time copy-the-
row-descriptor thing, so it doesn't seem like there should be a problem.

Most likely this is happening because LIKE and INHERITS share a lot of
code.  Anyone feel like looking into it?  (I'm not gonna, have too much
else to do...)

			regards, tom lane

Fri, 18 Jun 2004 10:36:04 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: CREATE TABLE ... LIKE composite type 