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?
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 |