Re: [HACKERS] pg_locks view and user locks

2004-09-14 Thread Merlin Moncure
> "Merlin Moncure" <[EMAIL PROTECTED]> writes: > > ... is there any merit to promoting the user lock wrappers out of > contrib > > Dunno. Yours is the first message I can recall in quite a long time > indicating that anyone was using userlocks. I thought the code was kind > of dying on the vine.

Re: [HACKERS] pg_locks view and user locks

2004-09-13 Thread Alvaro Herrera
On Mon, Sep 13, 2004 at 08:06:08PM -0400, Paul Tillotson wrote: > This is the first I have ever heard "user locks," but I have more than > once wanted a lock that would persist beyond the end of a transaction. > Do these do that? Yes. -- Alvaro Herrera () "El destino baraja y nosotros jugamos

Re: [HACKERS] pg_locks view and user locks

2004-09-13 Thread Paul Tillotson
This is the first I have ever heard "user locks," but I have more than once wanted a lock that would persist beyond the end of a transaction. Do these do that? Paul "Merlin Moncure" <[EMAIL PROTECTED]> writes: ... is there any merit to promoting the user lock wrappers out of contrib Dun

Re: [HACKERS] pg_locks view and user locks

2004-09-13 Thread Tom Lane
"Merlin Moncure" <[EMAIL PROTECTED]> writes: > ... is there any merit to promoting the user lock wrappers out of contrib Dunno. Yours is the first message I can recall in quite a long time indicating that anyone was using userlocks. I thought the code was kind of dying on the vine. Of course it

Re: [HACKERS] pg_locks view and user locks

2004-09-13 Thread Merlin Moncure
> I said some time ago that I would pester contrib authors about fixing > license issues, but it still hasn't gotten to the top of my to-do list :-( > AFAIK nothing at all has been done on this score. > > If Merlin is hot about contrib/userlock right now, he's welcome to try > to contact the origi

Re: [HACKERS] pg_locks view and user locks

2004-09-13 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > That's the whole problem. I don't think anyone objects to the user lock > principle, but as long as it's GPL, we won't support it. It was > probably a mistake to accept this module in the first place. I believe > some people have been trying to g

Re: [HACKERS] pg_locks view and user locks

2004-09-13 Thread Merlin Moncure
> Merlin Moncure wrote: > > Second, > > Is there a reason why user level locks are completely undocumented? > > AFAICT, There is no mention of them in anywhere in the docs, > > particularly 12.4, which describes methods for application managed > > concurrency. The availability of cooperative long

Re: [HACKERS] pg_locks view and user locks

2004-09-13 Thread Alvaro Herrera
On Mon, Sep 13, 2004 at 01:34:05PM -0400, Merlin Moncure wrote: > First, the pg_locks view lists user level locks but doesn't really say > much about them. For example, for traditional locks we get the xid but > for user locks we don't really get anything useful. I looked in > lockfuncs.c and di

Re: [HACKERS] pg_locks view and user locks

2004-09-13 Thread Peter Eisentraut
Merlin Moncure wrote: > Second, > Is there a reason why user level locks are completely undocumented? > AFAICT, There is no mention of them in anywhere in the docs, > particularly 12.4, which describes methods for application managed > concurrency. The availability of cooperative long term locks i