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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
