From: Shoaib Mir <shoaibmir@gmail.com>
To: Sandy Spence <axs@aber.ac.uk>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org
Subject: Re: invalid types and tables
Date: Mon, 18 Dec 2006 14:35:19 +0500
Message-ID: <bf54be870612180135r4fe06b7bqf79991ccd326a604@mail.gmail.com> (raw)
In-Reply-To: <001b01c72285$340f4840$520b3cc1@pc2axs>
References: <9165.1166197788@sss.pgh.pa.us>
<001b01c72285$340f4840$520b3cc1@pc2axs>
Glad to hear that Sandy :)
---------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/18/06, Sandy Spence <axs@aber.ac.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@sss.pgh.pa.us]
> Sent: 15 December 2006 15:50
> To: Shoaib Mir
> Cc: Sandy Spence; pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] invalid types and tables
>
> "Shoaib Mir" <shoaibmir@gmail.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
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: shoaibmir@gmail.com, axs@aber.ac.uk, tgl@sss.pgh.pa.us
Subject: Re: invalid types and tables
In-Reply-To: <bf54be870612180135r4fe06b7bqf79991ccd326a604@mail.gmail.com>
References: <9165.1166197788@sss.pgh.pa.us> <001b01c72285$340f4840$520b3cc1@pc2axs> <bf54be870612180135r4fe06b7bqf79991ccd326a604@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox