X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.225.181]) by svr1.postgresql.org (Postfix) with ESMTP id 825A4CC462 for ; Wed, 16 Jul 2003 03:17:17 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr5.postgresql.org [64.117.225.181]) (amavisd-new, port 10024) with ESMTP id 19758-05 for ; Wed, 16 Jul 2003 03:17:11 +0000 (GMT) Received: from cerebro.int-bytecraft.com (unknown [219.93.229.26]) by svr1.postgresql.org (Postfix) with ESMTP id EBC4DCADB6 for ; Wed, 16 Jul 2003 00:16:43 -0300 (ADT) Received: from bytecraft.com.my (home.int-bytecraft.com [127.0.0.1]) by cerebro.int-bytecraft.com (8.11.6/8.11.6) with ESMTP id h6G3EBq26146; Wed, 16 Jul 2003 11:14:14 +0800 Message-ID: <3F14C3DB.6030501@bytecraft.com.my> Date: Wed, 16 Jul 2003 11:17:47 +0800 From: Ang Chin Han User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4) Gecko/20030624 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Christoph Haller Cc: pgsql-sql@postgresql.org, jb@baltic-online.de Subject: Re: Non-Blocking Locks (i.e. Oracle NOWAIT) References: <3F1415B7.9001551F@rodos.fzk.de> In-Reply-To: <3F1415B7.9001551F@rodos.fzk.de> X-Enigmail-Version: 0.76.1.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig276B4084DD2637DF92F705FB" X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/194 X-Sequence-Number: 14308 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig276B4084DD2637DF92F705FB Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Christoph Haller wrote: > PostgreSQL 7.3.2 > T1: begin; select * from foo for update; > T2: set STATEMENT_TIMEOUT = 1000; -- milliseconds Seems like setting it to 1 (ms) emulates the NOWAIT condition better. Can't set it to 0, though. > T2: select * from foo for update; > T2: ERROR: Query was cancelled. How picky are we in borrowing syntax and idiocyncracies (?) from other DBs? Since we can closely emulate Oracle's behaviour on SELECT ... FOR UPDATE NOWAIT, should we just add NOWAIT to the next (non-feature frozen version) of postgres? -- Linux homer 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386 GNU/Linux 10:30am up 202 days, 1:35, 6 users, load average: 5.40, 5.14, 5.05 --------------enig276B4084DD2637DF92F705FB Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE/FMPeNYbTUIgzwfARArDEAKCmILHZmu7ZZZ63DXKrsu4ZgFKgPgCeOyZ9 t0riVZNijIOFvgW/ZNCvTKk= =AJLK -----END PGP SIGNATURE----- --------------enig276B4084DD2637DF92F705FB--