Re: Fixing invalid owners on pg_toast tables in 8.3.5

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Cott Lang <cott(at)internetstaff(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Fixing invalid owners on pg_toast tables in 8.3.5
Date: 2009-02-20 19:32:21
Message-ID: 13395.1235158341@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Cott Lang <cott(at)internetstaff(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Cott Lang 2009-02-20 19:48:45 Re: Fixing invalid owners on pg_toast tables in 8.3.5
Previous Message Joshua D. Drake 2009-02-20 19:25:30 Re: Fixing invalid owners on pg_toast tables in 8.3.5