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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | noreply | 2006-05-11 09:51:47 | [ psqlodbc-Bugs-1000644 ] codepage issue |
Previous Message | Ludek Finstrle | 2006-05-10 08:51:14 | Re: Terminating Idle Connections |