Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-interfaces by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group