Re: [GENERAL] dropping role w/dependent objects - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: [GENERAL] dropping role w/dependent objects
Date
Msg-id 200704270039.l3R0dkR13790@momjian.us
Whole thread Raw
In response to Re: [GENERAL] dropping role w/dependent objects  ("Ed L." <pgsql@bluepolka.net>)
List pgsql-patches
Your patch has been added to the PostgreSQL unapplied patches list at:

    http://momjian.postgresql.org/cgi-bin/pgpatches

It will be applied as soon as one of the PostgreSQL committers reviews
and approves it.

---------------------------------------------------------------------------


Ed L. wrote:
> 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, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq

--
  Bruce Momjian  <bruce@momjian.us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Re: [HACKERS] [COMMITTERS] pgsql: Add GUC temp_tablespaces to provide a default location for
Next
From: Bruce Momjian
Date:
Subject: Re: Reviewers Guide to Deferred Transactions/Transaction Guarantee