agora inbox for [email protected]  

help / color / mirror / Atom feed

From: Sebastien FLAESCH <[email protected]>
To: Heikki Linnakangas <[email protected]>
Cc: [email protected]
Cc: Guillaume ERGAND <[email protected]>
Subject: Re: PostgreSQL 8.3, libpq and WHERE CURRENT OF
Date: Fri, 26 Oct 2007 14:34:23 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>

Thanks Heikki for this quick answer.

Actually we do the following lipq calls:

- PQPrepare(... "SELECT ... FROM ... FOR UPDATE" ... )
- PQexecPrepared(...)
- PQntuples(...) / PQgetvalue(...)

i.e. we don't use the DECLARE CURSOR instruction, we just prepare/execute
the plain SELECT statement (with potential parameters)...

I can't remember why but there was some limitation or problems to use the
DECLARE CURSOR in our context... must dig in my mail archive to give you
more details...

FYI we do actually a PostgreSQL driver for our runtime VM...

Does a simple PQPrepare() with a SELECT statement not create a cursor on
the server side? If yes, would it not be possible to pass a cursor name
as in ODBC?

Best regards,
Seb

Heikki Linnakangas wrote:
> Sebastien FLAESCH wrote:
>> 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.
> 
> I don't understand. When you open a cursor with DECLARE CURSOR, you give
> it a name. Doesn't that do what you want?
> 

view thread (11+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: PostgreSQL 8.3, libpq and WHERE CURRENT OF
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox