Agreed, that will be a good solution for this scenario...
Thanks,
---------
Shoaib Mir
EnterpriseDB (www,enterprisedb.com)
On 12/15/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"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
