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

> "Dan Langille" <[EMAIL PROTECTED]> 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/


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to