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 19272D8EC4 for ; Fri, 14 Oct 2005 13:04:16 -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 31142-03 for ; Fri, 14 Oct 2005 16:04:14 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 14E03D9580 for ; Fri, 14 Oct 2005 13:04:13 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j9EG4D7p010481; Fri, 14 Oct 2005 12:04:13 -0400 (EDT) To: gry@ll.mit.edu Cc: pgsql-sql@postgresql.org Subject: Re: owner of data type "areas" appears to be invalid ? In-reply-to: <20051014115313.7a05858a.gry@ll.mit.edu> References: <20051014115313.7a05858a.gry@ll.mit.edu> Comments: In-reply-to george young message dated "Fri, 14 Oct 2005 11:53:13 -0400" Date: Fri, 14 Oct 2005 12:04:13 -0400 Message-ID: <10480.1129305853@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006] X-Spam-Level: X-Archive-Number: 200510/168 X-Sequence-Number: 23021 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