Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 5E5AC2E3383
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed,  6 Feb 2008 19:21:20 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 69431-06 for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed,  6 Feb 2008 19:21:12 -0400 (AST)
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by postgresql.org (Postfix) with ESMTP id 845CE2E3380
	for <pgsql-sql@postgresql.org>; Wed,  6 Feb 2008 19:21:17 -0400 (AST)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m16NLEBs019827;
	Wed, 6 Feb 2008 18:21:14 -0500 (EST)
To: "TJ O'Donnell" <tjo@acm.org>
cc: PostgreSQL - SQL <pgsql-sql@postgresql.org>
Subject: Re: Create Table xtest (like xtype) 
In-reply-to: <47AA0D2E.5040303@acm.org> 
References: <47AA0D2E.5040303@acm.org>
Comments: In-reply-to "TJ O'Donnell" <tjo@acm.org>
	message dated "Wed, 06 Feb 2008 11:40:30 -0800"
Date: Wed, 06 Feb 2008 18:21:14 -0500
Message-ID: <19826.1202340074@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200802/43
X-Sequence-Number: 30134

"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