On Fri, 2011-01-14 at 14:48 -0500, Tom Lane wrote:
> In any case I'd rather break apps using "LOCK foo NOWAIT" than break
> every application using any form of LOCK at all, which is what I think
> your proposal will amount to in practice.
Can I suggest that we don't break anything at all?
pg_lock_object(objectname, objecttype, mode);
or
pg_lock_sequence(name, mode);
is all we need...
--
Simon Riggs http://www.2ndQuadrant.com/books/
PostgreSQL Development, 24x7 Support, Training and Services