Postgres Pro
Downloads
Home   >   mailing lists

Changing owner of pg_toast tables - Mailing list pgsql-general

From Mark Styles
Subject Changing owner of pg_toast tables
Date
Msg-id 20090129151822.GE13763@lambic.co.uk
Whole thread Raw
Responses Re: Changing owner of pg_toast tables
List pgsql-general
Tree view 
Hi,

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?

--
Mark
http://www.lambic.co.uk
Attachment

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Encoding problem using pg_dumpall
Next
From: Teodor Sigaev
Date:
Subject: Re: Text search segmentation fault