[DOCS] pg_locks view and user locks

2004-09-13 Thread Merlin Moncure
I've been knocking around a bit with user level locks and I have a few suggestions/questions: 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

Re: [DOCS] [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: [DOCS] [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: [DOCS] [HACKERS] pg_locks view and user locks

2004-09-13 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > ISTM it would be better to have pg_locks show only system locks, and > another view, say pg_userlocks, to show user locks. This would allow to > show different data; for example, the PID of the process involved. I think this is a bad idea, at least for

[DOCS] XOR example error in docs

2004-09-13 Thread Richard Freytag
I think the example of the XOR bitwise compare on page: http://www.postgresql.org/docs/7.4/interactive/functions-math.html should read '11100' instead of the current '0'. Hope this is the right list instead of 'bugs.' Great docs though. All the best, Richard Freytag --