The following bug has been logged online:
Bug reference: 1166
Logged by: Michael Kleiser
Email address: [EMAIL PROTECTED]
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?
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
