Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 02D109F97FE for ; Mon, 3 Sep 2007 22:51:16 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 71825-05 for ; Mon, 3 Sep 2007 22:51:12 -0300 (ADT) X-Greylist: delayed 00:05:29.600687 by SQLgrey-1.7.5 Received: from mail1.fujitsu.com.au (mail1.fujitsu.com.au [216.14.192.229]) by postgresql.org (Postfix) with ESMTP id E5EB09F948C for ; Mon, 3 Sep 2007 22:51:12 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by mail1.fujitsu.com.au (Postfix) with ESMTP id D8298603AE for ; Tue, 4 Sep 2007 11:45:27 +1000 (EST) Received: from mail1.fujitsu.com.au ([127.0.0.1]) by localhost (mail1.fujitsu.com.au [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 15973-01-7 for ; Tue, 4 Sep 2007 11:45:27 +1000 (EST) Received: from mailfilter1.au.fjanz.com (mailfilter1.au.fjanz.com [137.172.19.78]) by mail1.fujitsu.com.au (Postfix) with ESMTP id B9FD86038F for ; Tue, 4 Sep 2007 11:45:27 +1000 (EST) X-SEF-Processed: 5_0_0_816__2007_09_04_11_45_27 Received: from Unknown [137.172.75.51] by mailfilter1.au.fjanz.com - SurfControl E-mail Filter (5.0.1); Tue, 04 Sep 2007 11:45:27 +1000 Received: from fast.fujitsu.com.au (localhost.localdomain [127.0.0.1]) by fast.fujitsu.com.au (8.13.1/8.13.1) with ESMTP id l841jQU3026315 for ; Tue, 4 Sep 2007 11:45:26 +1000 Received: from fast.fujitsu.com.au (root@localhost) by fast.fujitsu.com.au (8.13.1/8.13.1/Submit) with ESMTP id l841jQG6026314 for ; Tue, 4 Sep 2007 11:45:26 +1000 Received: from [137.172.75.244] (clife.fujitsu.com.au 137.172.75.244) by fast.fujitsu.com.au (Scalix SMTP Relay 10.0.1.3) via ESMTP; Tue, 04 Sep 2007 11:45:25 +1000 (EST) Date: Tue, 4 Sep 2007 11:44:15 +1000 From: "FAST PostgreSQL" To: PostgreSQL-development Message-ID: <46DCB86F.9070102@fast.fujitsu.com.au> Subject: Updatable cursor doubt x-scalix-Hops: 1 Organization: FAST User-Agent: Thunderbird 2.0.0.0 (X11/20070326) MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1"; format="flowed" Content-Disposition: inline X-Virus-Scanned: by amavisd-new at mail1.fujitsu.com.au X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.41 tagged_above=0 required=5 tests=AWL=0.409, BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200709/118 X-Sequence-Number: 107270 In CVS HEAD workspace=# begin; BEGIN workspace=# declare cu cursor for select * from t1 for read only; DECLARE CURSOR workspace=# fetch cu; a --- 1 (1 row) workspace=# delete from t1 where current of cu; DELETE 1 workspace=# commit; COMMIT Is this the intended behaviour? If so should we remove the 'READ ONLY' clause from the allowable syntax? The documentation does not have 'READ ONLY' as part of the cursor syntax anymore. Rgds, Arul Shaji