BUG #1166: pg_relcheck don't exist

Поиск
Список
Период
Сортировка
От PostgreSQL Bugs List
Тема BUG #1166: pg_relcheck don't exist
Дата
Msg-id 20040615105606.630B7CF4B0E@www.postgresql.com
обсуждение исходный текст
Ответы Re: BUG #1166: pg_relcheck don't exist
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      1166
Logged by:          Michael Kleiser

Email address:      mkl@webde-ag.de

PostgreSQL version: 7.4

Operating system:   SuSE Linux 8.1

Description:        pg_relcheck don't exist

Details:

In psql ("psql (PostgreSQL) 7.2.2")
\d tabes
does not work sometimes.
Eroor-Mesage is "Relation »pg_relcheck« don't exists"

p.e. it dont work with this table

CREATE TABLE categories
(
    id               INT8 NOT NULL
,   user_id          INT8 NOT NULL
,   name             VARCHAR(30) NOT NULL
,   name_lc          VARCHAR(30) NOT NULL
--
,   CONSTRAINT pk_categories PRIMARY KEY (id)
,   CONSTRAINT ck_cate_name_lc CHECK ( name_lc = LOWER(name) )
,   CONSTRAINT uk_cate_uid_name_lc UNIQUE ( user_id, name_lc )
);
But it works after
alter table categories drop constraint  ck_cate_name_lc;

select * from pg_relcheck;
results in "Relation »pg_relcheck« don't exists"

With psql -E I can see "pg_relcheck" is no longer used after I hat drop the
check-constraint.
Maybe the name of pg_relcheck has changed?

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "PostgreSQL Bugs List"
Дата:
Сообщение: BUG #1165: ECPG can't parse dynamic SQL with indicator
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #1166: pg_relcheck don't exist