X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id CE2E1475C15 for ; Tue, 25 Feb 2003 11:21:24 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 55884-05 for ; Tue, 25 Feb 2003 11:21:14 -0500 (EST) Received: from shield.pirmabanka.lv (unknown [195.114.57.4]) by postgresql.org (Postfix) with ESMTP id B84A0475E77 for ; Tue, 25 Feb 2003 11:08:22 -0500 (EST) Received: from wall2.pirmabanka.lv (wall2-pub.pirmabanka.lv [195.114.57.14]) by shield.pirmabanka.lv (8.9.3/8.9.3) with SMTP id SAA10580 for ; Tue, 25 Feb 2003 18:08:26 +0200 Received: from share.pirmabanka.lv ([10.0.0.10]) by wall2.pirmabanka.lv; Tue, 25 Feb 2003 18:08:25 +0200 (EET) Received: from pc311x1.pirmabanka.lv (IDENT:root@localhost.localdomain [127.0.0.1]) by pirmabanka.lv (8.11.5/8.11.5) with SMTP id h1PG8OJ12965 for ; Tue, 25 Feb 2003 18:08:24 +0200 Received: (qmail 4436 invoked by uid 100); 25 Feb 2003 16:08:37 -0000 Date: Tue, 25 Feb 2003 18:08:37 +0200 From: "Victor Yegorov" To: pgsql-sql@postgresql.org Subject: Re: Relation "pg_relcheck" Message-ID: <20030225160837.GB4347@pirmabanka.lv> Mail-Followup-To: pgsql-sql@postgresql.org References: <20030225155021.GA4347@pirmabanka.lv> Mime-Version: 1.0 Content-Type: text/plain; charset=koi8-r Content-Disposition: inline In-Reply-To: <20030225155021.GA4347@pirmabanka.lv> User-Agent: Mutt/1.4i X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/554 X-Sequence-Number: 11952 * Victor Yegorov [25.02.2003 18:06]: > 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) > ); > Sorry for troubles, got the problem myself. psql client was of version 7.2.2. After update everything works fine. -- Victor Yegorov