Terry Khatri <terrykhatri...@gmail.com> writes:
> Okay, I have found a reference to that oid in pg_type as under :
> select * from pg_type where typnamespace=74363 ;
Okay, so you have a composite type named "city" (either a table's
rowtype, or a standalone composite type --- hard to tell from just this
entry) that somehow escaped deletion when the containing schema was
deleted. Do you have an idea what triggered that? A reproducible test
case would be even better.
> What I should do next ?
Well, you can just manually delete those rows in pg_type, if you're sure
that there's nothing else linking to them. It might be safer to try to
do it as "drop type city" first.
regards, tom lane
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
