Re: invalid types and tables

Agreed, that will be a good solution for this scenario...

Thanks,
---------
Shoaib Mir
EnterpriseDB (www,enterprisedb.com)

On 12/15/06, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> "Shoaib Mir" <shoaibmir(at)gmail(dot)com> 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
>