Re: DROP OWNED BY

From: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
To: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Cc: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: DROP OWNED BY
Date: 2005-08-13 01:34:06
Message-ID: 20050812223337.Q1002@ganymede.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Definitely should be released without it ... it is an extension not
submitted for inclusion prior to the feature freeze ...

On Fri, 12 Aug 2005, Alvaro Herrera wrote:

> I'm working on the promised DROP OWNED patch, and just noticed that it
> needs modifications to the Grant/Revoke machinery that are too invasive
> to consider for 8.1; the problem is that ExecuteGrantStmt takes textual
> names for objects and grantees, and what I have from pg_shdepend are
> Oids. Dropping the objects themselves is easy -- the problem is
> dropping grants to other objects.
>
> So, instead of doing that, I think it's better to convert the Oids to
> names in the shared-dependency code. This should be rewritten after the
> next development period starts, for efficiency and cleanliness.
>
> Is anyone opposed to this idea? Further, is anyone opposed to the
> addition as a whole? I'm already a month and a half late with this
> part of the shdep patch, so if people think it's better to ship this
> release without it, so be it. (Of course I don't like that.)
>
> --
> Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
> "Cuando no hay humildad las personas se degradan" (A. Christie)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
>
>

----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy(at)hub(dot)org Yahoo!: yscrappy ICQ: 7615664

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2005-08-13 01:35:19 Re: --enable-thread-safety on Win32
Previous Message Bruce Momjian 2005-08-12 23:14:01 Re: Race conditions, race conditions!