X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 7E1F4475DC0
	for <pgsql-sql@postgresql.org>; Tue, 25 Feb 2003 11:34:22 -0500 (EST)
Received: from postgresql.org ([64.49.215.8])
	by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with
	SMTP id 59134-02 for <pgsql-sql@postgresql.org>;
	Tue, 25 Feb 2003 11:34:11 -0500 (EST)
Received: from post.webmailer.de (natsmtp01.webmailer.de [192.67.198.81])
	by postgresql.org (Postfix) with ESMTP id AB117475B8E
	for <pgsql-sql@postgresql.org>; Tue, 25 Feb 2003 11:22:39 -0500 (EST)
Received: from ianb.local (pD9517237.dip.t-dialin.net [217.81.114.55])
	by post.webmailer.de (8.9.3/8.8.7) with ESMTP id RAA29294;
	Tue, 25 Feb 2003 17:22:40 +0100 (MET)
Content-Type: text/plain;
  charset="koi8-r"
From: Ian Barwick <barwick@gmx.net>
To: "Victor Yegorov" <viy@pirmabanka.lv>, pgsql-sql@postgresql.org
Subject: Re: Relation "pg_relcheck"
Date: Tue, 25 Feb 2003 17:22:09 +0100
X-Mailer: KMail [version 1.4]
References: <20030225155021.GA4347@pirmabanka.lv>
In-Reply-To: <20030225155021.GA4347@pirmabanka.lv>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200302251722.09561.barwick@gmx.net>
X-Virus-Scanned: by amavisd-new
X-Archive-Number: 200302/557
X-Sequence-Number: 11955

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=3D> \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