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

Re: faq?

From: Ludek Finstrle <luf(at)pzkagis(dot)cz>
To: Antoine <melser(dot)anton(at)gmail(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: faq?
Date: 2006-01-27 22:03:41
Message-ID: 20060127220341.GA21219@soptik.pzkagis.cz (view raw or flat)
Thread:
Lists: pgsql-odbc
> I can't seem to find the faq. I ask this because after having seen our
> postgres/pgsql-odbc project nearly fail (the boss even suggested we convert
> to access!!!) because I failed to realise that for big tables not using the
> option "Use Declare/Fetch" meant pgsql-odbc would bring our server and
> network to a standstill. That should certainly be in the FAQ!

I agree with you. But we don't have even enough time for development.
Could you maintain the documentation? Or is here someone who could
maintain the documentation?
There is config.html in CVS (I hope Dave put it into releases too)
so you could study from it.

> BTW, could someone tell me why that is not a good option to have enabled by
> default? I assume that most dbs have at least a couple of tables where there
> are lots of rows, and seeing as a lot of odbc (vb6 anyway) users probably do

It was broken some time ago. And no every user need it. When you access
whole table it doesn't matter if you use "use declare/fetch" or not.
Then you have turned on "use declare/fetch" you don't know number
of returned rows until you reach end of result.
It isn't so clear to enable it by default.

> inserts the way we do (ie, not via execute, but by opening a table and then
> doing AddNew) it might be something to look at... anyway, the boss told us

Hey, does I miss something? There is no support for updateable cursors
in 08.01 psqlodbc driver. And it is marked as experimental feature in
07.03 version.

Regards,

Luf

In response to

  • faq? at 2006-01-27 18:19:57 from Antoine

Responses

  • Re: faq? at 2006-01-27 22:34:12 from Dave Page

pgsql-odbc by date

Next:From: Dave PageDate: 2006-01-27 22:34:12
Subject: Re: faq?
Previous:From: noreplyDate: 2006-01-27 19:34:34
Subject: [ psqlodbc-Bugs-1000417 ] odbc_lib_connect() returns "Specified driver could not be loaded due to system error 182 (PostgreSQL ANSI)"

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