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

Поиск
Список
Период
Сортировка
От Joel Rodrigues
Тема Re: [NOVICE] Unable to locate type name '? in catalog ERROR
Дата
Msg-id F955C90F-C41D-11D6-B121-0005024EF27F@Phreaker.net
обсуждение исходный текст
Список pgsql-general
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: "Patrick Fiche"
Дата:
Сообщение: Re: concatenation of strings
Следующее
От: Daryl Beattie
Дата:
Сообщение: Re: [JDBC] Selecting Varchar range (through JDBC).