Glen Jarvis writes:
> I found this thread online because I have the same problem.
> =# drop role ;
> ERROR: role "" cannot be dropped because some objects depend on it
> DETAIL: owner of type pg_toast.pg_toast_51797
> 1 objects in database
I think this is a known issue:
http://archives.postgr
Mark Styles-2 wrote:
>
> On Thu, Jan 29, 2009 at 02:11:37PM -0500, Tom Lane wrote:
>> Mark Styles 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_
On Thu, Jan 29, 2009 at 02:11:37PM -0500, Tom Lane wrote:
> Mark Styles 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 shou
Mark Styles 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?
Given the way the code works, this could be explained by a corrupt index
for pg_sh
Mark Styles wrote:
> On Thu, Jan 29, 2009 at 12:29:07PM -0500, Tom Lane wrote:
> > Mark Styles writes:
> > > On Thu, Jan 29, 2009 at 10:46:08AM -0500, Tom Lane wrote:
> > >> I guess the interesting question to me is what happened to the tables
> > >> those toast tables are/were attached to? They s
On Thu, Jan 29, 2009 at 12:29:07PM -0500, Tom Lane wrote:
> Mark Styles writes:
> > On Thu, Jan 29, 2009 at 10:46:08AM -0500, Tom Lane wrote:
> >> 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
> >> owne
Mark Styles writes:
> On Thu, Jan 29, 2009 at 10:46:08AM -0500, Tom Lane wrote:
>> 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 chan
On Thu, Jan 29, 2009 at 10:46:08AM -0500, Tom Lane wrote:
> Mark Styles 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
Mark Styles 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
th
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
signature.asc
Description: Digital signature
10 matches
Mail list logo
