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
pgsql-patches by date
|Next:||From: Peter Eisentraut||Date: 2003-04-13 23:39:58|
|Subject: Re: IPv6 address parsing for inet/cidr types (take II)|
|Previous:||From: Nic Ferrier||Date: 2003-04-13 11:36:17|
|Subject: Re: patch for cursor based querys in JDBC|