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

Re: libpq pgconn pointer

From: Ludek Finstrle <luf(at)pzkagis(dot)cz>
To: SAFAK CIRAG <safak(dot)cirag(at)netcad(dot)com(dot)tr>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: libpq pgconn pointer
Date: 2006-05-10 09:03:25
Message-ID: 20060510090325.GC1620@soptik.pzkagis.cz (view raw or flat)
Thread:
Lists: pgsql-odbc
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

In response to

pgsql-odbc by date

Next:From: noreplyDate: 2006-05-11 09:51:47
Subject: [ psqlodbc-Bugs-1000644 ] codepage issue
Previous:From: Ludek FinstrleDate: 2006-05-10 08:51:14
Subject: Re: Terminating Idle Connections

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