Message-ID: <01BD8831.11D74EA0.tim@bosinius.de>
From: Tim Bosinius <tim@bosinius.de>
To: "'pgsql-interfaces@postgresql.org'" <pgsql-interfaces@postgresql.org>
Subject: ODBC & Postgres problem
Date: Mon, 25 May 1998 23:00:35 +0200
Encoding: 35 TEXT

I am new to this mailing-list and I have a problem with (Insight)ODBC & PostgreSQL.
I have searched the pgsql-interfaces archive to solve my problem but that did not
help me much.

I have installed - following the steps in the INSTALL readme - 
postgresql 6.3.2 on my linux (glibc) server

I am trying to access a database I created with InsightDist ODBC and Visual
Basic 5.0 RDO and I have two problems.

First of all postgres uses alot of memory and is really slow, while an ODBC
connection is active:

[postgres@downtown /root]$ ps aux | grep postgres
postgres 19740  0.0  0.5  1420   252  p0 S   20:56   0:00 su postgres 
postgres 19741  0.0  1.2  1172   580  p0 S   20:56   0:00 bash 
postgres 19746  0.0  0.6  5060   284  p0 S   20:57   0:00 postmaster -i -B 256
postgres 19749 13.2 82.5 56664 38704  p0 S   20:58   0:16 /usr/local/pgsql/bin/postgres -p -Q -P5 -B 256 -v 65536 foo
postgres 19753  0.0  1.0   832   504  p0 R   21:00   0:00 ps aux 
postgres 19754  0.0  1.2  1172   580  p0 R   21:00   0:00 bash 
[postgres@downtown /root]$ 


I have 48MB Ram and a big swap, but it uses far too much memory.

The second problem I run into is that when I use RDO or RDC/RDO I cannot activate the
"UseCursor" Option for the ODBC driver and I everytime I try to insert,update or
delete a record I am told that the resultset is writeprotected (Error number 40048)

Can anybody help me one these problems.


Regards,

Tim Bosinius