Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 92C089FA2FD for ; Fri, 15 Dec 2006 12:31:36 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 01805-06 for ; Fri, 15 Dec 2006 12:31:28 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from cefni.aber.ac.uk (cefni.aber.ac.uk [144.124.16.40]) by postgresql.org (Postfix) with ESMTP id E94A69FA2A7 for ; Fri, 15 Dec 2006 12:31:28 -0400 (AST) Received: from localhost ([127.0.0.1] helo=cefni.aber.ac.uk) by cefni.aber.ac.uk with esmtp (Exim 4.54) id 1GvFy3-0006ik-7m; Fri, 15 Dec 2006 16:31:27 +0000 Received: from pc2axs.dcs.aber.ac.uk ([193.60.11.82] helo=pc2axs) by cefni.aber.ac.uk with esmtp (Exim 4.54) id 1GvFxV-0006fW-87; Fri, 15 Dec 2006 16:30:53 +0000 From: "Sandy Spence" To: "'Tom Lane'" , "'Shoaib Mir'" Cc: Subject: Re: invalid types and tables Date: Fri, 15 Dec 2006 16:30:54 -0000 Message-ID: <004701c72066$64238170$520b3cc1@pc2axs> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 Thread-Index: AccgYQRVdVCX4foZS76iOuek9Kjt8wAAHTtg In-Reply-To: <9165.1166197788@sss.pgh.pa.us> X-Sophos-Scanned: from axs@aber.ac.uk virus scanned OK X-UWA-Mid: 1GvFxV-0006fW-87 X-UWA-Originating-IP: 193.60.11.82 X-UWA-Bounce-Filter: 8B4gAOMXYx X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/227 X-Sequence-Number: 24019 Hi Tom and Shoaib, Hi Tom and Shoaib, thanks for the help, one last question I hope, how do I cross reference the pg_class, pg_user and pg_type so that I can obtain the usesysid of the missing owner? 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: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Tom Lane 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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq