Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 907E29F9FE1 for ; Mon, 18 Dec 2006 05:35:27 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 31558-05 for ; Mon, 18 Dec 2006 05:35:20 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.179]) by postgresql.org (Postfix) with ESMTP id 7F17C9F9357 for ; Mon, 18 Dec 2006 05:35:20 -0400 (AST) Received: by py-out-1112.google.com with SMTP id d32so185165pye for ; Mon, 18 Dec 2006 01:35:19 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=JKVDCbZSp0f22gAbLetmu/nYc3U6p+G6Fj3RwIv+7n7AX4MxU0Sg2sKqt+Y61emFH1BVjfbEofjPoXsaKWuXFZwoO0IAP5FV2TaAF9NPpKl9uTyFCv9aMiS6vkc1O1zESgWh1ny9use7qtJsM4xQ33eke29XKtImRkiRVEjPutw= Received: by 10.65.15.17 with SMTP id s17mr4641997qbi.1166434519291; Mon, 18 Dec 2006 01:35:19 -0800 (PST) Received: by 10.65.206.17 with HTTP; Mon, 18 Dec 2006 01:35:19 -0800 (PST) Message-ID: Date: Mon, 18 Dec 2006 14:35:19 +0500 From: "Shoaib Mir" To: "Sandy Spence" Subject: Re: invalid types and tables Cc: "Tom Lane" , pgsql-admin@postgresql.org In-Reply-To: <001b01c72285$340f4840$520b3cc1@pc2axs> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_6842_6907633.1166434519208" References: <9165.1166197788@sss.pgh.pa.us> <001b01c72285$340f4840$520b3cc1@pc2axs> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/246 X-Sequence-Number: 24038 ------=_Part_6842_6907633.1166434519208 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Glad to hear that Sandy :) --------------- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 12/18/06, Sandy Spence 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" 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 > > ------=_Part_6842_6907633.1166434519208 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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


------=_Part_6842_6907633.1166434519208--