| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Ray Alba <ralba(at)dotsperinch(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: ERROR CODE |
| Date: | 2000-05-01 19:50:23 |
| Message-ID: | Pine.LNX.4.21.0005011511410.389-100000@localhost.localdomain |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2000-05-01 19:50:47 | Re: Performance/Reliability statistics? |
| Previous Message | Peter Eisentraut | 2000-05-01 19:49:01 | Re: pgsql DATE |