Re: LOCK for non-tables - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: LOCK for non-tables
Date
Msg-id 1295035017.23290.90.camel@ebony
Whole thread Raw
In response to Re: LOCK for non-tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: LOCK for non-tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: LOCK for non-tables
Next
From: Andrew Dunstan
Date:
Subject: Re: SQL/MED - FDW API