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

Re: Shared dependency patch

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Shared dependency patch
Date: 2005-03-09 04:05:31
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-patches
On Mon, Feb 14, 2005 at 10:09:55PM -0500, Bruce Momjian wrote:

> With us moving to a normal 8.1 release do you want to submit submit to
> be applied to CVS?

Here it is in a single tarball.  I keep the previous description below.

Here is the latest installation of my shared dependency patch.
As some of you may remember, the purpose of this patch is to record
dependencies on shared objects, such as users, groups and tablespaces,
from regular database objects.  This is done on a new shared system
catalog called pg_shdepend, so that when a backend wants to drop any
shared object, it can easily verify whether it is referenced in other

I have upgraded the patch to include references present in ACLs, and to
lock the objects appropiately before checking.  To do this I had to
change the LOCKTAG struct somewhat, using a previous patch by Rod Taylor
(thanks Rod!); and add a LockSharedObject() function.

Alvaro Herrera (<alvherre[(at)]dcc(dot)uchile(dot)cl>)
"La tristeza es un muro entre dos jardines" (Khalil Gibran)

Attachment: shdep-patch-10.tar.gz
Description: application/x-tar-gz (24.2 KB)

In response to


pgsql-patches by date

Next:From: Qingqing ZhouDate: 2005-03-09 07:42:55
Subject: Re: trivial refactoring of WaitOnLock
Previous:From: Bruce MomjianDate: 2005-03-09 03:52:09
Subject: Re: Where to see the patch queue (was Re: [PATCHES] Patch

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