"Shoaib Mir" <[EMAIL PROTECTED]> writes:
> Well I will not recommend deleting rows like this from the meta data, but if
> I will rather try using ALTER TABLE and ALTER TYPE to assign an owner for
> the missing user referenced type or table

No, just create a new user with the same usesysid as is shown as the
owner in pg_class etc.  See the SYSID option to CREATE USER.

(FWIW, more recent PG versions prevent you from dropping users that still
own objects.)

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

Reply via email to