Postgres Pro
Downloads
Home   >   mailing lists

Re: Cursors for update.., we have to port an informix 9.x appication using cursors for update - Mailing list pgsql-interfaces

From Michael Meskes
Subject Re: Cursors for update.., we have to port an informix 9.x appication using cursors for update
Date
Msg-id 200512211923.02637.meskes@postgresql.org
Whole thread Raw
In response to Cursors for update.., we have to port an informix 9.x appication using cursors for update  (jmadm <jmadm@montevideo.com.uy>)
List pgsql-interfaces
Tree view 
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@jabber.org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!

pgsql-interfaces by date:

Previous
From: "Jeroen T. Vermeulen"
Date:
Subject: Re: Libpq++ interface for postgres 8.1
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Libpq++ interface for postgres 8.1