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