pg_relcheck

Started by MTabout 23 years ago2 messagesgeneral
Jump to latest
#1MT
mt@open2web.com

I created a field and then decided to drop it. Postgres won't let me drop it, however. I get the following error message when trying to drop it using phppgadmin:

Error - /home/httpd/htdocs/pgadmin/lib.inc.php -- Line: 718

PostgreSQL said: ERROR: Relation "pg_relcheck" does not exist
Your query:

SELECT
rcname as index_name,
rcsrc
FROM
pg_relcheck,
pg_class bc
WHERE
rcrelid = bc.oid
and bc.relname = 'client'
and not exists
(select * from pg_relcheck as c, pg_inherits as i
where i.inhrelid = pg_relcheck.rcrelid
and c.rcname = pg_relcheck.rcname
and c.rcsrc = pg_relcheck.rcsrc
and c.rcrelid = i.inhparent)

Could someone please explain why I am getting this error message.

--
Thanks,

Mark

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: MT (#1)
Re: pg_relcheck

Mark Tessier <mt@open2web.com> writes:

Could someone please explain why I am getting this error message.

Probably you are using an obsolete version of phppgadmin.
The pg_relcheck catalog doesn't exist anymore in 7.3.

regards, tom lane