From: Dan Langille <dan@langille.org>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: pgsql-docs@postgresql.org
Subject: Re: PATH no longer a part of 7.4?
Date: Tue, 10 Feb 2004 11:38:25 -0500
Message-ID: <4028C2B1.17785.1A30B32C@localhost> (raw)
In-Reply-To: <15811.1076430761@sss.pgh.pa.us>
References: <4028B3E3.10865.19F6DF63@localhost>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: dan@langille.org, tgl@sss.pgh.pa.us, pgman@candle.pha.pa.us
Subject: Re: PATH no longer a part of 7.4?
In-Reply-To: <4028C2B1.17785.1A30B32C@localhost>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox