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 по дате отправления: