Re: Reserved Key Words, Using "path" as a table name - Mailing list pgsql-patches

From Tom Lane
Subject Re: Reserved Key Words, Using "path" as a table name
Date
Msg-id 378.1050274589@sss.pgh.pa.us
Whole thread Raw
In response to Reserved Key Words, Using "path" as a table name  (tom@tom-martin.de (Tom))
List pgsql-patches
tom@tom-martin.de (Tom) writes:
> CREATE TABLE "path" (collumn_name int NULL);
> complaints with
> ERROR:  TypeCreate: type path already defined

This is not a matter of a reserved word, it's simply that tables have
associated types, and there's already a type named "path".

You could remove or rename the built-in type "path", but a better
solution would be to update to 7.3 so that your table doesn't have
to live in the same namespace as system-defined types.

            regards, tom lane


pgsql-patches by date:

Previous
From: Peter Jones
Date:
Subject: Re: Modern C++ Interface
Next
From: Peter Eisentraut
Date:
Subject: Re: IPv6 address parsing for inet/cidr types (take II)