Message-ID: <4721BAFE.3080601@4js.com>
Date: Fri, 26 Oct 2007 12:01:34 +0200
From: Sebastien FLAESCH <sf@4js.com>
Organization: Four J's Development Tools
User-Agent: Thunderbird 1.5.0.9 (X11/20061220)
MIME-Version: 1.0
To: pgsql-hackers@postgresql.org
CC: Guillaume ERGAND <ger@4js.com>
Subject: PostgreSQL 8.3, libpq and WHERE CURRENT OF
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi hackers,

Just looked at the new features of 8.3 and realized that positioned
updates/deletes is now possible with this new release...

We would use that if we could define the cursor name with a libpq function.

Something similar to ODBC's SQLSetCursorName() function...

For now we must use OIDs to emulate WHERE CURRENT OF, but since 8.1,
OIDs are no more created by default and require additional configuration
when setting up a PostgreSQL server.

If I missed something, please point me to the docs where I can find this.

Understand this is not an isolated project: We are a Development Tool
vendor and have a bunch of customers migrating legacy applications from
Informix to PostgreSQL...

Thanks a lot!
Sebastien FLAESCH
Database Interfaces
Four J's Development Tools