Re: Why isn't DECLARE CURSOR ... FOR UPDATE supported?

> -----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