On Thu, Jan 29, 2009 at 10:46:08AM -0500, Tom Lane wrote:
> 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.
They did have the same owner, I changed the owner to postgres so I could
drop the role, but the corresponding pg_toast tables did not change.
> What PG version is this exactly?
8.1.11
--
Mark
http://www.lambic.co.uk
