Re: ERROR CODE

Ray Alba writes:

> create table patienttype (
> id INT DEFAULT nextval ('category_seq'),
> parent id INT DEFAULT '0',
  ^^^^^^^^^
The system interprets this as field name `parent', datatype `id'. You need
to double quote the field name if you want spaces in it.

> type varchar(50));
>
> Here is the error? What is that all about?
> ERROR:  Unable to locate type name 'id' in catalog

It means there is no datatype 'id'.

--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden