Postgres Pro
Downloads
Home   >   mailing lists

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 29515.1233243968@sss.pgh.pa.us
Whole thread Raw
In response to 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
Tree view 
Mark Styles <postgres@lambic.co.uk> writes:
> I'm trying to drop a role that is no longer being used. However the role
> has 4 dependencies which are all pg_toast tables. How can I change the
> owner of those pg_toast tables so I can drop the role?

I guess the interesting question to me is what happened to the tables
those toast tables are/were attached to?  They should have the same
owners as their parent tables.  What PG version is this exactly?

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Text search segmentation fault
Next
From: Richard Broersma
Date:
Subject: Re: Pet Peeves?