Skip site navigation (1) Skip section navigation (2)

Re: [NOVICE] Unable to locate type name '? in catalog ERROR

From: Joel Rodrigues <jdrodrigues(at)Phreaker(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [NOVICE] Unable to locate type name '? in catalog ERROR
Date: 2002-09-09 18:00:06
Message-ID: F955C90F-C41D-11D6-B121-0005024EF27F@Phreaker.net (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-novice
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



In response to

pgsql-novice by date

Next:From: Tom LaneDate: 2002-09-09 19:01:51
Subject: Re: Unable to locate type name '? in catalog ERROR
Previous:From: David LloydDate: 2002-09-09 17:50:22
Subject: Re: Unix domain sockets

pgsql-general by date

Next:From: Larry RosenmanDate: 2002-09-09 18:26:21
Subject: Re: pg_restore not able to restore files larger that 2.4GB
Previous:From: Ericson SmithDate: 2002-09-09 17:59:55
Subject: pg_restore not able to restore files larger that 2.4GB

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group