Re: dropping role w/dependent objects

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
Cc: pgsql-patches(at)postgresql(dot)org, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: dropping role w/dependent objects
Date: 2007-04-27 00:39:46
Message-ID: 200704270039.l3R0dkR13790@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general 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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2007-04-27 00:43:22 Re: Processing a work queue
Previous Message Merlin Moncure 2007-04-27 00:34:43 Re: Processing a work queue

Browse pgsql-patches by date

  From Date Subject
Next Message Koichi Suzuki 2007-04-27 00:50:13 Re: [HACKERS] Full page writes improvement, code update
Previous Message Bruce Momjian 2007-04-27 00:22:01 Re: Re: [HACKERS] [COMMITTERS] pgsql: Add GUC temp_tablespaces to provide a default location for