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

Re: Cursors and transactions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Chris Smith" <cdsmith(at)twu(dot)net>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Cursors and transactions
Date: 2004-02-13 00:36:01
Message-ID: 25254.1076632561@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-jdbc
"Chris Smith" <cdsmith(at)twu(dot)net> writes:
> 1. I'd like to get *something* working fairly quickly.  Is it possible to
> force the 7.4 server to communicate using the V2 protocol, so I can quickly
> port my old patch and use it while I work on something more ambitious?

Yes, 7.4 still supports V2 protocol (and even V1 protocol, I believe,
though there may be bit rot setting in there since it's probably gone
untested for years...)

> 2. Starting on the more ambitious approach, I notice a comment to the effect
> of "we only support one cursor per connection".  Is that a fundamental
> limitation of PostgreSQL, or something specific to the drivers?

There's no such restriction on the backend side, so I assume this is
something JDBC-specific.  The comment could be obsolete, too.

			regards, tom lane

In response to

pgsql-jdbc by date

Next:From: Chris SmithDate: 2004-02-13 01:09:56
Subject: Re: Cursors and transactions
Previous:From: Chris SmithDate: 2004-02-12 23:44:05
Subject: Re: Cursors and transactions

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