BUG #1166: pg_relcheck don't exist

From: "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1166: pg_relcheck don't exist
Date: 2004-06-15 10:56:06
Message-ID: 20040615105606.630B7CF4B0E@www.postgresql.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1166
Logged by: Michael Kleiser

Email address: mkl(at)webde-ag(dot)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?

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2004-06-15 13:29:00 Re: BUG #1166: pg_relcheck don't exist
Previous Message PostgreSQL Bugs List 2004-06-15 00:52:20 BUG #1165: ECPG can't parse dynamic SQL with indicator