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