Skip site navigation (1) Skip section navigation (2)

Re: invalid types and tables

From: "Shoaib Mir" <shoaibmir(at)gmail(dot)com>
To: "Sandy Spence" <axs(at)aber(dot)ac(dot)uk>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-admin(at)postgresql(dot)org
Subject: Re: invalid types and tables
Date: 2006-12-18 09:35:19
Message-ID: bf54be870612180135r4fe06b7bqf79991ccd326a604@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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
>
>

In response to

pgsql-admin by date

Next:From: amritDate: 2006-12-18 09:55:35
Subject: DBmirror
Previous:From: Sandy SpenceDate: 2006-12-18 09:16:24
Subject: Re: invalid types and tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group