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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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: Wed, 21 Dec 2005 19:23:02 +0100
  • Message-id: <200512211923.02637.meskes@postgresql.org> <text/plain>

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!



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group