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

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

Alvaro Herrera wrote:
> Hackers,
> 
> Here is a newer version of the shared dependency patch.  I keep the
> previous description below.  Changes from the previous version are:
> 
> - Removed several bogus elog(NOTICE)
> - Groups are checked at deletion for dependencies
> - I noticed a couple of tests (cluster and privileges) were leaving
>   orphaned objects, so with this patch they would leave users behind.
>   (consequently, future runs of the tests would fail).
> - Added simple regression testing.
> 
> New files are
> 
> src/backend/catalog/pg_shdepend.c
> src/include/catalog/pg_shdepend.h
> src/test/regress/sql/dependency.sql
> src/test/regress/expected/dependency.sql
> 
> Comments are welcome.
> 
> 
> On Wed, Jan 26, 2005 at 09:04:53PM -0300, I wrote:
> 
> > Patchers,
> > 
> > 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
> > database.
> > 
> > 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 (<[EMAIL PROTECTED]>)
> Major Fambrough: You wish to see the frontier?
> John Dunbar: Yes sir, before it's gone.

[ Attachment, skipping... ]

[ Attachment, skipping... ]

[ Attachment, skipping... ]

[ Attachment, skipping... ]

[ Attachment, skipping... ]

> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
>                http://archives.postgresql.org

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org

Reply via email to