Re: table is not a table

On Wed, Jan 25, 2006 at 11:26:39AM -0500, Tom Lane wrote:
> "Ilja Golshtein" <ilejn@yandex.ru> writes:
> > postgres=# create table ddd(f1 int4);
> > CREATE TABLE
> > postgres=# drop table ddd;
> > ERROR:  "ddd" is not a table
>
> That's just plain bizarre.  Would you try it with \set VERBOSITY verbose
> so we can see exactly where the error is coming from?
>
> Has this installation been working for you before?  I'm wondering about
> a corrupt backend executable file, or some such ...

Could a corrupt catalog be responsible?  Might a query like the
following reveal anything?

SELECT c.ctid, c.xmin, c.xmax, c.oid, c.relname, c.relkind,
       n.ctid, n.xmin, n.xmax, n.oid, n.nspname
FROM pg_class AS c
LEFT JOIN pg_namespace AS n ON n.oid = c.relnamespace
WHERE c.relname ~* '^ddd';

--
Michael Fuhr