Re: Generate user/group sysids from a sequence? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Generate user/group sysids from a sequence?
Date
Msg-id 16910.1042834658@sss.pgh.pa.us
Whole thread Raw
In response to Re: Generate user/group sysids from a sequence?  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-hackers
Robert Treat <xzilla@users.sourceforge.net> writes:
> On Fri, 2003-01-17 at 14:32, Tom Lane wrote:
>> Getting at objects in other databases is considerably less practical
>> than anything we've discussed here.

> Perhaps you don't allow the removal unless all databases came up clean.
> You can have the db admin go in a clean up each database manually if
> need be. Granted this doesn't solve getting at those other databases in
> the first place, but it eliminates any transactional issues.

Oh?  What if someone creates an object belonging to the user after we've
finished examining that database?  (Actually, this issue exists even
within a single database; so I suppose we'd need to invent some kind of
lock on userids ...)
        regards, tom lane


pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: Suggestion for aggregate function
Next
From: Justin Clift
Date:
Subject: Re: v7.3.1 psql against a v7.2.x database ...