Re: ERROR CODE

I think it is because you have a space between "parent" and "id" in your
field named "parent id".

David Boerwinkle
-----Original Message-----
From: Ray Alba <ralba(at)dotsperinch(dot)com>
To: pgsql-general(at)postgresql(dot)org <pgsql-general(at)postgresql(dot)org>
Date: Saturday, April 29, 2000 7:17 AM
Subject: [GENERAL] ERROR CODE

>I am creating a new table called patienttype with categories -
>infant,pediatric, adult in the doctors table
>
>for some reason it allows me to create a sequence but, when I create a
>table that requires that sequence, I get the following.
>
>create table patienttype (
>id INT DEFAULT nextval ('category_seq'),
>parent id INT DEFAULT '0',
>type varchar(50));
>
>Here is the error? What is that all about?
>ERROR: Unable to locate type name 'id' in catalog
>
>Thanks,
>
>Ray
>
> ---------------------------------
> * *** *
> * Ray Alba/ dotsperinch *
> * 74 Varick | 55 W 92nd St. *
> * 212.966.4979 | 212.864.6456 *
> * Fax.966.3866 | 212.864.4489 *
> * ralba(at)dotsperinch(dot)com *
> * http://www.dotsperinch.com *
> * http://www.dotsperinch.com *
> ---------------------------------
>
>