| From: | Mark Tessier <mt(at)open2web(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | pg_relcheck |
| Date: | 2003-03-02 18:48:32 |
| Message-ID: | 20030302134832.12ba0818.mt@open2web.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | sector119 | 2003-03-02 19:23:07 | does tsearch work with utf-8? |
| Previous Message | Ben-Nes Michael | 2003-03-02 18:30:09 | function problem plpgsql |