Fixing invalid owners on pg_toast tables in 8.3.5

From: Cott Lang <cott(at)internetstaff(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Fixing invalid owners on pg_toast tables in 8.3.5
Date: 2009-02-20 19:01:11
Message-ID: 1235156471.3087.14.camel@duo.internetstaff.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We're running 8.3.5 on RHEL4 x86_64.

We removed a user yesterday and were greeted with warnings from pg_dump
this morning. :)

pg_dump: WARNING: owner of data type "pg_toast_80075" appears to be
invalid

The usual archives and google searches produced mainly 8.0 and earlier
incidents and suggested resolving this by re-creating a user with that
sysid. Since you can no longer specify a SYSID when creating a user
(despite what \h in psql says), we gave ALTER type/table a shot with no
luck.

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...

Is there a recommended procedure for resolving this safely?

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

Thanks!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2009-02-20 19:25:30 Re: Fixing invalid owners on pg_toast tables in 8.3.5
Previous Message Scott Marlowe 2009-02-20 18:39:54 Re: Getting time-dependent load statistics