Re: invalid types and tables

Glad to hear that Sandy :)

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

On 12/18/06, Sandy Spence <axs(at)aber(dot)ac(dot)uk> wrote:
>
> Hi Tom and Shoaib,
>
> Thanks for all your help, the penny dropped and I now understand what you
> meant by SYSID. I have traced the usename and all is now well.
>
> Regards,
>
> Sandy
>
>
> Computer Officer, RA Certification Manager
> Department of Computer Science - UWA
> Llandinam Building
> Penglais Campus
> Aberystwyth
> Ceredigion
> Wales - UK
> SY23 3DB
> Tel: (01970)-622433
> Fax: (01970)-628536
>
>
> -----Original Message-----
> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> Sent: 15 December 2006 15:50
> To: Shoaib Mir
> Cc: Sandy Spence; pgsql-admin(at)postgresql(dot)org
> Subject: Re: [ADMIN] invalid types and tables
>
> "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
>
>