Re: Changing owner of pg_toast tables - Mailing list pgsql-general

From Tom Lane
Subject Re: Changing owner of pg_toast tables
Date
Msg-id 8087.1233256297@sss.pgh.pa.us
Whole thread Raw
In response to Re: Changing owner of pg_toast tables  (Mark Styles <postgres@lambic.co.uk>)
Responses Re: Changing owner of pg_toast tables  (Mark Styles <postgres@lambic.co.uk>)
List pgsql-general
Mark Styles <postgres@lambic.co.uk> writes:
> Thanks, I managed to clear out the offending dependencies. relowner was
> actually set correctly, but the pg_shdepend records were wrong.

Hmm ... what actually was in the pg_shdepend entries?

Given the way the code works, this could be explained by a corrupt index
for pg_shdepend (which could cause it to fail to find the entries it
should've deleted).  But I don't see how that would lead to an "OID not
found" type of message.  Also, if you did get an error, that should've
rolled back the whole thing.  So I'm still baffled.

            regards, tom lane

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Changing owner of pg_toast tables
Next
From: Greg Smith
Date:
Subject: Re: Pet Peeves?