Re: owner of data type "areas" appears to be invalid ?

From: george young <gry(at)ll(dot)mit(dot)edu>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: owner of data type "areas" appears to be invalid ?
Date: 2005-10-14 16:19:21
Message-ID: 20051014121921.097e1b71.gry@ll.mit.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Yes, that worked. Thank you very much!

-- George

On Fri, 14 Oct 2005 12:04:13 -0400
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> threw this fish to the penguins:

> george young <gry(at)ll(dot)mit(dot)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)

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tyler Kellen 2005-10-14 18:02:39 FULL OUTER JOIN Question
Previous Message Tom Lane 2005-10-14 16:04:13 Re: owner of data type "areas" appears to be invalid ?