X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id C1F88D1B1F0 for ; Fri, 14 May 2004 02:26:31 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 12833-06 for ; Fri, 14 May 2004 02:26:12 -0300 (ADT) Received: from smtp.istop.com (dci.doncaster.on.ca [66.11.168.194]) by svr1.postgresql.org (Postfix) with ESMTP id 08C83D1B179 for ; Fri, 14 May 2004 02:26:11 -0300 (ADT) Received: from stark.xeocode.com (gsstark.mtl.istop.com [66.11.160.162]) by smtp.istop.com (Postfix) with SMTP id D7A0117C316; Fri, 14 May 2004 01:26:10 -0400 (EDT) To: Bruno Wolff III Cc: Jaime Casanova , pgsql-sql@postgresql.org Subject: Re: isolation level References: <20040513182450.GA23159@wolff.to> In-Reply-To: <20040513182450.GA23159@wolff.to> From: Greg Stark Organization: The Emacs Conspiracy; member since 1992 Date: 14 May 2004 01:26:09 -0400 Message-ID: <87r7tnpojy.fsf@stark.xeocode.com> Lines: 19 User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.3 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/130 X-Sequence-Number: 17844 Bruno Wolff III writes: > On Thu, May 13, 2004 at 18:13:23 +0000, > Jaime Casanova wrote: > > Hi all, is there a way to set the isolation level to something like the > > sql standard dirty read. > > No. There will be a way to use the standard name in a SET command, but > you will actaully get READ COMMITTED isolation (which is the next step up). I wonder how hard this would be to implement. It doesn't seem like it should be very hard. It would be very convenient for debugging and for checking on the progress of large batch updates or loads. -- greg