| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Larry Rosenman | 2002-09-09 18:26:21 | Re: pg_restore not able to restore files larger that 2.4GB |
| Previous Message | Ericson Smith | 2002-09-09 17:59:55 | pg_restore not able to restore files larger that 2.4GB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-09-09 19:01:51 | Re: Unable to locate type name '? in catalog ERROR |
| Previous Message | David Lloyd | 2002-09-09 17:50:22 | Re: Unix domain sockets |