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

From: Michael Meskes <meskes(at)postgresql(dot)org>
To: pgsql-interfaces(at)postgresql(dot)org, jmadm(at)montevideo(dot)com(dot)uy
Subject: Re: Cursors for update.., we have to port an informix 9.x appication using cursors for update
Date: 2005-12-21 18:23:02
Message-ID: 200512211923.02637.meskes@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Am Dienstag, 20. Dezember 2005 20:46 schrieb jmadm:
> 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?

IIRC there used to be some patches on gborg to implement WHERE CURRENT OF. I
have no idea though whether they work with 8.1.

Michael
--
Michael Meskes
Email: Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org)
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes(at)jabber(dot)org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Joshua D. Drake 2005-12-21 18:37:37 Re: Libpq++ interface for postgres 8.1
Previous Message Jeroen T. Vermeulen 2005-12-21 18:11:31 Re: Libpq++ interface for postgres 8.1