X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id B6BEE475A7F for ; Tue, 25 Feb 2003 11:24:54 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 57060-01 for ; Tue, 25 Feb 2003 11:24:44 -0500 (EST) Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by postgresql.org (Postfix) with ESMTP id 4F309475EA9 for ; Tue, 25 Feb 2003 11:11:23 -0500 (EST) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 05F46D5F7; Tue, 25 Feb 2003 08:11:27 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id EFD345C02; Tue, 25 Feb 2003 08:11:27 -0800 (PST) Date: Tue, 25 Feb 2003 08:11:27 -0800 (PST) From: Stephan Szabo To: Victor Yegorov Cc: Subject: Re: Relation "pg_relcheck" In-Reply-To: <20030225155021.GA4347@pirmabanka.lv> Message-ID: <20030225081003.B57635-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/555 X-Sequence-Number: 11953 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.