Re: Fixing invalid owners on pg_toast tables in 8.3.5 - Mailing list pgsql-general

From Tom Lane
Subject Re: Fixing invalid owners on pg_toast tables in 8.3.5
Date
Msg-id 13395.1235158341@sss.pgh.pa.us
Whole thread Raw
In response to Fixing invalid owners on pg_toast tables in 8.3.5  (Cott Lang <cott@internetstaff.com>)
Responses Re: Fixing invalid owners on pg_toast tables in 8.3.5
List pgsql-general
Cott Lang <cott@internetstaff.com> writes:
> The owner of the actual table and index is correct, only the type has an
> invalid owner. I have thus far avoided the temptation to try a manual
> update...

That's probably your best bet.

> Since Postgres now prevents you from dropping users owning objects, is
> this a bug, or does it fall into a gray area?

Can you show us how to reproduce it?  We've seen occasional reports of
similar things but no one ever managed to produce a test case.

            regards, tom lane

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Fixing invalid owners on pg_toast tables in 8.3.5
Next
From: Cott Lang
Date:
Subject: Re: Fixing invalid owners on pg_toast tables in 8.3.5