On Thu, Jan 29, 2009 at 10:46:08AM -0500, Tom Lane wrote: > Mark Styles <postg...@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
signature.asc
Description: Digital signature
