| From: | "Victor Yegorov" <viy(at)pirmabanka(dot)lv> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Relation "pg_relcheck" |
| Date: | 2003-02-25 16:08:37 |
| Message-ID: | 20030225160837.GB4347@pirmabanka.lv |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
* Victor Yegorov <viy(at)pirmabanka(dot)lv> [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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2003-02-25 16:11:27 | Re: Relation "pg_relcheck" |
| Previous Message | Victor Yegorov | 2003-02-25 15:50:21 | Relation "pg_relcheck" |