Re: somebody working on: Prevent default re-use of sysids

Kris Jurka wrote:
> 
> 
> On Fri, 3 Dec 2004, Bruce Momjian wrote:
> 
> > > What about Alvaro's shared dependencies work:
> > > 
> > > http://archives.postgresql.org/pgsql-hackers/2004-10/msg00963.php
> > 
> > That is for allowing comments on global tables like pg_shadow and
> > pg_database.  I don't think it relates to finding if someone owns
> > objects in another database.
> > 
> 
> I quote from the first paragraph of the given link:
> 
> I'm currently playing with implementing a "shared dependency" catalog,
> to keep track of objects pointing to global objects, currently users and
> tablespaces.  So it is forbidden to drop a user that owns tables (or
> whatever objects) on other databases.

Interesting.  I didn't realize he was doing dependency between global
and db-local objects.

--  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,
Pennsylvania19073