Re: Relation "pg_relcheck"

On Tue, 25 Feb 2003, Victor Yegorov wrote:

> Hello.
>
> I'm running PostgreSQL 7.3.2 on i686-pc-linux-gnu, compiled by GCC 2.95.3.
>
> I've created a table (a forest of nested sets):
> create table forest (
>     tree_id int4 not null,
>     leaf_id int4 not null,
>     lid int2 not null check(lid > 0),
>     rid int2 not null check (rid > 1),
>     relation_id int2 not null default 0,
>     constraint forest_order check(lid < rid),
>     constraint forest_primary primary key(tree_id, leaf_id)
> );
>
> Now, in psql:
> mema2=> \d forest
> ERROR:  Relation "pg_relcheck" does not exist
>
> Whats the problem, I wonder. I've already created a new DB location with
> initdb and pointed server to it - same stuff.

Are you sure you're using the same version of psql as the server is
running?  The info in pg_relcheck moved to pg_constraint IIRC.