thanks for the reply. There are a few tables I did this to, here's one of
them:
cms3=# select oid,* from pg_class where relname='view_log';
oid | relname | reltype | relowner | relam | relfilenode | relpages |
reltuples | reltoastrelid | reltoastidxid | relhasindex | relisshared |
relkind | relnatts | relchecks | reltriggers | relukeys | relfkeys | relrefs
| relhasoids | relhaspkey | relhasrules | relhassubclass | relacl
-------+----------+---------+----------+-------+-------------+----------+---
--------+---------------+---------------+-------------+-------------+-------
--+----------+-----------+-------------+----------+----------+---------+----
--------+------------+-------------+----------------+----------------------
19433 | view_log | 19434 | 1 | 0 | 19433 | 10 |
1000 | 836121 | 0 | t | f | r |
5 | 0 | 0 | 0 | 0 | 0 | t | t
| f | t | {=,postgres=arwdRxt}
(1 row)
cms3=# drop table view_log;
NOTICE: RelationBuildDesc: can't open view_log: No such file or directory
ERROR: cannot open view_log: No such file or directory
cms3=#
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
>
> Can't tell without more details. What's the *exact* error message you
> get from a DROP TABLE? Also it'd be useful to see the pg_class rows
> for the problem tables ("select oid,* from pg_class where relname =
'xxx'")
