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

From: "Hiroshi Inoue" <inoue(at)tpf(dot)co(dot)jp>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: Why isn't DECLARE CURSOR ... FOR UPDATE supported?
Date: 2003-12-19 14:30:40
Message-ID: 001301c3c63c$adca7590$3d283ddb@PbgX
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-12-19 15:19:30 Re: How can I return a NULL value from a function?
Previous Message Vladimir 2003-12-19 12:41:30 "could not found trigger %u"