Updatable cursor doubt

From: "FAST PostgreSQL" <fastpgs(at)fast(dot)fujitsu(dot)com(dot)au>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Updatable cursor doubt
Date: 2007-09-04 01:44:15
Message-ID: 46DCB86F.9070102@fast.fujitsu.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Ben Tilly 2007-09-04 02:06:35 Re: Hash index todo list item
Previous Message Tom Lane 2007-09-04 01:02:07 Re: Per-function GUC settings: trickier than it looked