On Tuesday 25 February 2003 16:50, 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
You are probably using a pre-7.3 version of psql with a 7.3.x
backend.
Ian Barwick
barwick@gmx.net