Re: SELECT FOR UPDATE NOWAIT and PostgreSQL 8.0 - Mailing list pgsql-hackers

From Devrim GUNDUZ
Subject Re: SELECT FOR UPDATE NOWAIT and PostgreSQL 8.0
Date
Msg-id Pine.LNX.4.61.0409142026390.8416@emo.org.tr
Whole thread Raw
In response to Re: SELECT FOR UPDATE NOWAIT and PostgreSQL 8.0  ("Simon Riggs" <simon@2ndquadrant.com>)
Responses Re: SELECT FOR UPDATE NOWAIT and PostgreSQL 8.0  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Hi,

On Mon, 13 Sep 2004, Simon Riggs wrote:

> Now we have LOCK TABLE ... NOWAIT; but I wonder whether we'll have the
> SELECT ... NOWAIT one.  Today I got a request for this; and it was
> reported that this feature will be used in a huge project.
>
> Well, it shouldn't be too much of a patch - just cloning the code?
>
> Perhaps they can start in development without it and we'll patch it in
> later.

I learned that the code is ready. They'll change the code now.

>> Hmm... this seems the exact opposite of how I would tend to think
>> the feature
>> would be used... ie. you don't really care how long the query takes, just
>> that you can't get the lock.
>
> Agreed - and this is important! I thought we'd done NOWAIT on the SELECT...
>
> Oh well, 8.1 will be better still.

Bruce: Any TODO here? ;)

Regards,

- --
Devrim GUNDUZ 
devrim~gunduz.org                devrim.gunduz~linux.org.tr            http://www.tdmsoft.com
http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQFBRythtl86P3SPfQ4RAg5+AJ9jdgkolYwBgeLhTBRMt0W0TGd8AwCeJQuM
95igCBca4aisP82g4374nxs=
=Yr9x
-----END PGP SIGNATURE-----


pgsql-hackers by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: pg_locks view and user locks
Next
From: Dennis Bjorklund
Date:
Subject: Is select a transaction starting statement?