Postgres Pro
Downloads
Home   >   mailing lists

Re: Create Table xtest (like xtype) - Mailing list pgsql-sql

From Tom Lane
Subject Re: Create Table xtest (like xtype)
Date
Msg-id 19826.1202340074@sss.pgh.pa.us
Whole thread Raw
In response to Create Table xtest (like xtype)  (TJ O'Donnell <tjo@acm.org>)
Responses Re: Create Table xtest (like xtype)  ("TJ O'Donnell" <tjo@acm.org>)
List pgsql-sql
Tree view 
"TJ O'Donnell" <tjo@acm.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

pgsql-sql by date:

Previous
From: Tom Hart
Date:
Subject: Re: outer join issues
Next
From: Tom Lane
Date:
Subject: Re: Information schema permissions