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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joel Rodrigues <borgempath(at)Phreaker(dot)net>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Unable to locate type name '? in catalog ERROR
Date: 2002-09-09 19:01:51
Message-ID: 12742.1031598111@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

Joel Rodrigues <borgempath(at)Phreaker(dot)net> writes:
> 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

Works for me. You might try turning on query logging and looking
in the postmaster log to see what query is really getting received
by the backend. I suspect something is helpfully trying to translate
your query text :-(. It might or might not be relevant that all the
spaces in your example showed up as \240 here...

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-09-09 19:12:37 7.3 function permissions (was Re: Making small bits of code available)
Previous Message Tom Lane 2002-09-09 18:45:28 Re: Screwy Statistics...

Browse pgsql-novice by date

  From Date Subject
Next Message Curtis Mortensen 2002-09-09 21:54:44 Re: pg_restore error
Previous Message Joel Rodrigues 2002-09-09 18:00:06 Re: [NOVICE] Unable to locate type name '? in catalog ERROR