Postgres Pro
Downloads
Home   >   mailing lists

Re: [NOVICE] Unable to locate type name '? in catalog ERROR - Mailing list pgsql-general

From Joel Rodrigues
Subject Re: [NOVICE] Unable to locate type name '? in catalog ERROR
Date
Msg-id F955C90F-C41D-11D6-B121-0005024EF27F@Phreaker.net
Whole thread Raw
List pgsql-general
Tree view 
On Saturday, September 7, 2002, at 07:36 , Joel Rodrigues wrote:

> Hello,
>
> Anyone know why trying to create this column :
>
> "gender    CHAR(1)      CHECK (gender IN ('M','F'))"
>
> Results in this error:
>
> ERROR:  Unable to locate type name '? in catalog
>
>
> It appears on:
> <http://www.ca.postgresql.org/docs/aw_pgsql_book/node132.html>
>

Well, I drop the database and started from scratch, this time
creating a table with
"sex    CHAR(1)      CHECK (sex IN ('M','F'))" first. Worked
fine. But I'd still like to know what the heck "Unable to locate
type name '? in catalog" meant.

Cheers,
- Joel

pgsql-general by date:

Previous
From: "Patrick Fiche"
Date:
Subject: Re: concatenation of strings
Next
From: Daryl Beattie
Date:
Subject: Re: [JDBC] Selecting Varchar range (through JDBC).