From: "Dan Langille" <dan@langille.org>
To: Tom Lane <tgl@sss.pgh.pa.us>
Date: Tue, 10 Feb 2004 11:38:25 -0500
MIME-Version: 1.0
Subject: Re: PATH no longer a part of 7.4? 
Cc: Bruce Momjian <pgman@candle.pha.pa.us>, pgsql-docs@postgresql.org
Message-ID: <4028C2B1.17785.1A30B32C@localhost>
References: <4028B3E3.10865.19F6DF63@localhost> 
In-reply-to: <15811.1076430761@sss.pgh.pa.us>
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: 7BIT
Content-description: Mail message body

On 10 Feb 2004 at 11:32, Tom Lane wrote:

> "Dan Langille" <dan@langille.org> writes:
> > Here is how this issue arose.  A user of [ 7.2.something ]
> > is getting this error when creating a table named path.
> 
> Right, in 7.2 the rowtype for such a table would conflict with the
> predefined type.
> 
> > I've been able to create this table under 7.4.1, 7.4, and 7.3.4 (but 
> > have no other versions under which I can test).
> 
> In 7.3 and later there is no conflict, because the predefined type name
> lives in the pg_catalog schema, which is not where user tables are
> customarily created.

Hmmm, for a 7.2 user, is there any solution?  Apart from "drop type 
path"?  We'd rather not rename the table.
-- 
Dan Langille : http://www.langille.org/
BSDCan - http://www.bsdcan.org/