"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