Re: Create Table xtest (like xtype)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "TJ O'Donnell" <tjo(at)acm(dot)org>
Cc: PostgreSQL - SQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Create Table xtest (like xtype)
Date: 2008-02-06 23:21:14
Message-ID: 19826.1202340074@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"TJ O'Donnell" <tjo(at)acm(dot)org> writes:
> Create Type xtype As (a Integer, b Text);
> Create Table xtest (Like xtype);
> ERROR: "xtype" is a composite type

Hmmm ... as you see, that's disallowed, but offhand it seems like it
wouldn't be very hard to allow it. It might be as simple as relaxing
the relkind check.

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2008-02-06 23:37:22 Re: Information schema permissions
Previous Message Tom Hart 2008-02-06 22:37:15 Re: outer join issues