Re: [HACKERS] CREATE TABLE ... LIKE composite type

2004-06-18 Thread Tom Lane
Mark Gibson <[EMAIL PROTECTED]> 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-de

[HACKERS] CREATE TABLE ... LIKE composite type

2004-06-18 Thread Mark Gibson
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 Web De