Postgres Pro
Downloads
Home   >   mailing lists

Re: Why isn't DECLARE CURSOR ... FOR UPDATE supported? - Mailing list pgsql-hackers

From Hiroshi Inoue
Subject Re: Why isn't DECLARE CURSOR ... FOR UPDATE supported?
Date
Msg-id 001301c3c63c$adca7590$3d283ddb@PbgX
Whole thread Raw
In response to Why isn't DECLARE CURSOR ... FOR UPDATE supported?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
> -----Original Message-----
> From: Tom Lane
> 
> Is there any good reason for this restriction?
> 
> regression=# begin;
> BEGIN
> regression=# declare c cursor for select * from tenk1 for update;
> ERROR:  DECLARE CURSOR ... FOR UPDATE is not supported
> DETAIL:  Cursors must be READ ONLY.

Because we haven't supported updatable cursors yet.

regards,
Hiroshi Inoue

pgsql-hackers by date:

Previous
From: Vladimir
Date:
Subject: "could not found trigger %u"
Next
From: Tom Lane
Date:
Subject: Re: How can I return a NULL value from a function?