Re: Cursors for update.., we have to port an informix 9.x appication using cursors for update

From: Jaime Casanova <systemguards(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: jmadm(at)montevideo(dot)com(dot)uy, pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Cursors for update.., we have to port an informix 9.x appication using cursors for update
Date: 2005-12-20 22:11:42
Message-ID: c2d9e70e0512201411r1a298cd4y8e3b5f522a66f65e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

On 12/20/05, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> jmadm <jmadm(at)montevideo(dot)com(dot)uy> writes:
> > We have to port an application from Informix 9 CSQL to Postgres 8.1
> > using Ecpg.
>
> > Informix application uses cursors for update to lock all the rows
> > involved in those cursor. Then an update my occur ussing Current of.
>
> > How we can do this with postgres?
>
> You can use SELECT FOR UPDATE in the cursor,

in the cursor or instead of the cursor? IIRC, cursors are read only in postgres

--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Francis Reed 2005-12-21 15:16:21 Libpq++ interface for postgres 8.1
Previous Message Tom Lane 2005-12-20 21:46:59 Re: Cursors for update.., we have to port an informix 9.x appication using cursors for update