CREATE TABLE ... LIKE composite type

From: Mark Gibson <gibsonm(at)cromwell(dot)co(dot)uk>
To: "Hackers (PostgreSQL)" <pgsql-hackers(at)postgresql(dot)org>
Subject: CREATE TABLE ... LIKE composite type
Date: 2004-06-18 10:07:00
Message-ID: 40D2BEC4.9000700@cromwell.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Sullivan 2004-06-18 11:27:52 Re: signal 11 on AIX: 7.4.2
Previous Message Zeugswetter Andreas SB SD 2004-06-18 08:20:47 Re: signal 11 on AIX: 7.4.2