libpq pgconn pointer

am 10.05.2006 08:31:14 von SAFAK CIRAG

This is a multi-part message in MIME format.

------=_NextPart_000_001E_01C67414.7B76F7C0
Content-Type: text/plain;
charset="iso-8859-9"
Content-Transfer-Encoding: quoted-printable

Hi,

I've have been using PostgreSQL for its spatial extension. However =
fetching binary data into a dataset through ODBC and then reading the =
binary data decreases performance. For the sake of performance,i've =
fetched geometries by binary cursors using libpq API. My problem is to =
make two connections;one for geometries and other for psql-odbc. So i'm =
wondering if somehow pgconn pointer address of a connection made by =
psql-odbc can be reached from outside.=20

Another question : Server side cursor is working with OpenForwardOnly =
mode,what about KeySet?

------=_NextPart_000_001E_01C67414.7B76F7C0
Content-Type: text/html;
charset="iso-8859-9"
Content-Transfer-Encoding: quoted-printable

charset=3Diso-8859-9">

Hi,

I've have been using =
PostgreSQL=20
for its spatial extension. However fetching binary data into a=20
dataset through ODBC and then reading the binary data =
decreases=20
performance. For the sake of performance,i've fetched geometries =
by binary=20
cursors using libpq API. My problem is to make two connections;one =
for=20
geometries and other for psql-odbc. So i'm wondering if somehow pgconn =
pointer=20
address of a connection made by psql-odbc can be reached from=20
outside.

Another question : Server =
side cursor=20
is working with OpenForwardOnly mode,what about=20
KeySet?

------=_NextPart_000_001E_01C67414.7B76F7C0--

Re: libpq pgconn pointer

am 10.05.2006 11:03:25 von Ludek Finstrle

Wed, May 10, 2006 at 09:31:14AM +0300, SAFAK CIRAG wrote:
> I've have been using PostgreSQL for its spatial extension.
> However fetching binary data into a dataset through ODBC and then
> reading the binary data decreases performance. For the sake of
> performance,i've fetched geometries by binary cursors using libpq
> API. My problem is to make two connections;one for geometries and

Why is it the problem?

> other for psql-odbc. So i'm wondering if somehow pgconn pointer
> address of a connection made by psql-odbc can be reached from outside.

You don't specify driver version at first. E.g. 08.02.0002 use libpq
only sometimes ...
I see no way to get th pgconn pointer right now. Maybe you hack some
ODBC function to return it (maybe SQLGetInfo or SQLGetConnectAttr).

> Another question : Server side cursor is working with
> OpenForwardOnly mode,what about KeySet?

Does PostgreSQL backend (server) support Keyset cursor? I don't think so.

Regards,

Luf

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org