On Thu, Jan 29, 2009 at 02:11:37PM -0500, Tom Lane wrote: > Mark Styles <postgres@xxxxxxxxxxxx> 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? I guess I should've noted that down eh? From memory, the classid was the oid of the pg_toast object, the refobjid was the oid of the role, the deptype was 'o', I don't recall what the other values were. I'll keep my eye out for more problems as I work through tidying this database. -- Mark http://www.lambic.co.uk
Attachment:
signature.asc
Description: Digital signature
