From: george young <gry@ll.mit.edu>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
Subject: Re: owner of data type "areas" appears to be invalid ?
Date: Fri, 14 Oct 2005 12:19:21 -0400
Message-ID: <20051014121921.097e1b71.gry@ll.mit.edu> (raw)
In-Reply-To: <10480.1129305853@sss.pgh.pa.us>
References: <20051014115313.7a05858a.gry@ll.mit.edu>
<10480.1129305853@sss.pgh.pa.us>
Yes, that worked. Thank you very much!
-- George
On Fri, 14 Oct 2005 12:04:13 -0400
Tom Lane <tgl@sss.pgh.pa.us> threw this fish to the penguins:
> 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
>
--
"Are the gods not just?" "Oh no, child.
What would become of us if they were?" (CSL)
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: gry@ll.mit.edu, tgl@sss.pgh.pa.us
Subject: Re: owner of data type "areas" appears to be invalid ?
In-Reply-To: <20051014121921.097e1b71.gry@ll.mit.edu>
* 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