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