From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
---|---|
To: | Victor Yegorov <viy(at)pirmabanka(dot)lv> |
Cc: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Relation "pg_relcheck" |
Date: | 2003-02-25 16:11:27 |
Message-ID: | 20030225081003.B57635-100000@megazone23.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-02-25 16:20:11 | Re: Polymorphic? |
Previous Message | Victor Yegorov | 2003-02-25 16:08:37 | Re: Relation "pg_relcheck" |