From: Tom Lane <tgl@sss.pgh.pa.us>
To: gry@ll.mit.edu
Cc: pgsql-sql@postgresql.org
Subject: Re: owner of data type "areas" appears to be invalid ?
Date: Fri, 14 Oct 2005 12:04:13 -0400
Message-ID: <10480.1129305853@sss.pgh.pa.us> (raw)
In-Reply-To: <20051014115313.7a05858a.gry@ll.mit.edu>
References: <20051014115313.7a05858a.gry@ll.mit.edu>
george young <gry@ll.mit.edu> 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
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 using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, gry@ll.mit.edu
Subject: Re: owner of data type "areas" appears to be invalid ?
In-Reply-To: <10480.1129305853@sss.pgh.pa.us>
* 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