Terry Khatri <terrykhatri531@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
