Re: Reserved Key Words, Using "path" as a table name

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: tom(at)tom-martin(dot)de (Tom)
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: Reserved Key Words, Using "path" as a table name
Date: 2003-04-13 22:56:29
Message-ID: 378.1050274589@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

tom(at)tom-martin(dot)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

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Peter Eisentraut 2003-04-13 23:39:58 Re: IPv6 address parsing for inet/cidr types (take II)
Previous Message Nic Ferrier 2003-04-13 11:36:17 Re: patch for cursor based querys in JDBC