Problem with pg-relcheck

hello friends..
m a newbie on the block i did create a table with 'check' constraint in it... and when i am using the \d table_name to describe the table i am getting the following error which says that -
the relation pg-relcheck doesnt exists......
any help for this one???
following is the the skeleton i hv used.....


CREATE TABLE ft_200841 (
f_id SERIAL CHECK (f_id >=0 ) PRIMARY KEY,
p_id INTEGER (10) CHECK (p_id >=0),
f_time INTEGER (10) CHECK (f_time >=0),
rate FLOAT DEFAULT 1,
dir SMALLINT (4),
cnt FLOAT,
.
.
.
nodes INTEGER (10) CHECK (nodes >=0),
pps FLOAT,
loca INTEGER (10) CHECK (loca >=0),
mla INTEGER (10) CHECK (mla >=0),
tia INTEGER (10) CHECK (tia >=0),
mlu FLOAT DEFAULT -1

);



n i am using postgres 8.3.1 on linux..

Any help is welcome!!

Sounds like a bug. Maybe you should put this problem on postgres maillist.

You are probably running a very old version (7.1) of psql.
pg_relcheck is an old system catalog table which was removed with version 7.3.

Make sure you are running an up-to-date version of psql (run psql --version to check the psql version)

i am using the postgres 8.3.1 version.. thats why i am wondering why i am getting this error...???

That might be the back-end version, but that is not necessarily the version of the psql client tool.

What does
psql --version
return?

psql (PostgreSQL) 7.2.4
contains support for: readline, history, multibyte
Portions Copyright (c) 1996-2001, PostgreSQL Global Development Group
Portions Copyright (c) 1996, Regents of the University of California
Read the file COPYRIGHT or use the command \copyright to see the
usage and distribution terms.


so wats difference between this and i got postgres 8.3.1 i am confused...

hey i had got this postgresql-8.3.1.tar.gz n then after untaring it i got postgresql-8.3.1 n when i am saying psql -V it is giving me this....


psql (PostgreSQL) 7.2.4
contains support for: readline, history, multibyte
Portions Copyright (c) 1996-2001, PostgreSQL Global Development Group
Portions Copyright (c) 1996, Regents of the University of California
Read the file COPYRIGHT or use the command \copyright to see the
usage and distribution terms.


n i am not getting the \d table_name getting the error for pg_relcheck..... so is it that the client tool also has diff version??
how do i upgrade that version..???
pls help....

Untaring it will not install Postgres. Did you run the installer?

So you do have an old copy of the client tools lying around.

That depends on your operating system and what you have installed already.
If you did install 8.3.1 it might simply be a matter of adjusting your PATH variable (again this depends on your operating system)
It's probably also a good idea to remove the old version from your system (again: operating system specific)

Untaring it will not install Postgres. Did you run the installer?

yes i did run the installer after untaring the stuff... refered README and followed the steps.. m able to use psql.. but probs with the \d table_name cant desc the tables that have CHECK constraint in it.. other tables not having this check constraint are not giving me the problem.....

So you do have an old copy of the client tools lying around.

so how to change it?

That depends on your operating system and what you have installed already.
If you did install 8.3.1 it might simply be a matter of adjusting your PATH variable (again this depends on your operating system)
It's probably also a good idea to remove the old version from your system (again: operating system specific)
m using linux... and how to check the PATH variable and set it to what??

Sorry I have no experience with Linux. But isn't there some package manager or something to de-install the old version?

Maybe this will help:
http://www.postgresql.org/docs/8.3/static/install-post.html