Skip site navigation (1) Skip section navigation (2)

Re: dropping role w/dependent objects

From: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
To: Bruce Momjian <bruce(at)momjian(dot)us>, pgsql-patches(at)postgresql(dot)org
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: dropping role w/dependent objects
Date: 2007-04-05 00:11:26
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-generalpgsql-patches
On Wednesday April 4 2007 5:37 pm, Bruce Momjian wrote:
> > Perhaps this could be added to the TODO list?  I won't get
> > to it anytime soon.
> Yes.  What should the TODO text be?

See if the attached patch is acceptable.  If not, perhaps the 
TODO text should be:

Enable end user to identify dependent objects when the following 
error is encountered:

ERROR:  role "mygroup" cannot be dropped because some objects 
depend on it
DETAIL:  227 objects in this database

Attachment: pg_shdepend.c.diff
Description: text/x-diff (1.4 KB)

In response to


pgsql-patches by date

Next:From: Tatsuo IshiiDate: 2007-04-05 00:35:33
Subject: Re: HOT WIP Patch - version 6.3
Previous:From: Joshua D. DrakeDate: 2007-04-04 23:44:04
Subject: Re: autovacuum multiworkers, patch 5

pgsql-general by date

Next:From: Omar EljumailyDate: 2007-04-05 00:14:04
Subject: Problem with oids for table names getting out of sync?
Previous:From: Bruce MomjianDate: 2007-04-04 23:37:07
Subject: Re: dropping role w/dependent objects

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group