X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id CBAAAD9580 for ; Fri, 14 Oct 2005 13:20:00 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 30924-06 for ; Fri, 14 Oct 2005 16:19:56 +0000 (GMT) Received: from ll.mit.edu (LLMAIL.LL.MIT.EDU [129.55.12.40]) by svr1.postgresql.org (Postfix) with ESMTP id 3F2A6D8EC4 for ; Fri, 14 Oct 2005 13:19:52 -0300 (ADT) Received: (from smtp@localhost) by ll.mit.edu (8.12.10/8.8.8) id j9EGJoGS022382; Fri, 14 Oct 2005 12:19:50 -0400 (EDT) Received: from UNKNOWN( ), claiming to be "sty.llan" via SMTP by llmail, id smtpdAAAzHaqKP; Fri Oct 14 12:19:21 2005 Date: Fri, 14 Oct 2005 12:19:21 -0400 From: george young To: Tom Lane Cc: pgsql-sql@postgresql.org Subject: Re: owner of data type "areas" appears to be invalid ? Message-Id: <20051014121921.097e1b71.gry@ll.mit.edu> In-Reply-To: <10480.1129305853@sss.pgh.pa.us> References: <20051014115313.7a05858a.gry@ll.mit.edu> <10480.1129305853@sss.pgh.pa.us> Reply-To: gry@ll.mit.edu Organization: MIT Lincoln Laboratory X-Mailer: Sylpheed version 2.0.1 (GTK+ 2.8.0; i686-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.007 required=5 tests=[AWL=0.007] X-Spam-Level: X-Archive-Number: 200510/169 X-Sequence-Number: 23022 Yes, that worked. Thank you very much! -- George On Fri, 14 Oct 2005 12:04:13 -0400 Tom Lane threw this fish to the penguins: > george young writes: > > How can I fix this? > > Re-create the owning user (which you evidently dropped), assigning it > sysid 101. > > PG 8.1 will make it impossible to drop users who still own objects or > have permissions ... although that will bring its own set of gotchas ... > > regards, tom lane > -- "Are the gods not just?" "Oh no, child. What would become of us if they were?" (CSL)