Re: [HACKERS] ODBC and palloc ...

From: dlibenzi(at)maticad(dot)it (Davide Libenzi)
To: "Byron Nikolaidis" <byronn(at)insightdist(dot)com>, "Davide Libenzi" <dlibenzi(at)maticad(dot)it>
Cc: <pgsql-hackers(at)postgreSQL(dot)org>, <pgsql-interfaces(at)postgreSQL(dot)org>, "David Hartwig" <daveh(at)insightdist(dot)com>
Subject: Re: [HACKERS] ODBC and palloc ...
Date: 1998-07-23 19:09:21
Message-ID: 001001bdb66d$67aa33a0$1f0104c0@pcdavide
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-interfaces

I think this is not my case.
See attachment log for details.

Hi

----
Davide Libenzi at :
Maticad s.r.l.
Via Della Giustizia n.9 Fano (PS) 61032 Italy
Tel.: +39-721-808308 (ra) Fax: +39-721-808309
Email: <davidel(at)maticad(dot)it>
WWW: <http://www.maticad.it>

-----Original Message-----
From: Byron Nikolaidis <byronn(at)insightdist(dot)com>
To: Davide Libenzi <dlibenzi(at)maticad(dot)it>
Cc: pgsql-hackers(at)postgreSQL(dot)org <pgsql-hackers(at)postgreSQL(dot)org>;
pgsql-interfaces(at)postgreSQL(dot)org <pgsql-interfaces(at)postgreSQL(dot)org>; David
Hartwig <daveh(at)insightdist(dot)com>
Date: Thursday, July 23, 1998 6:59 PM
Subject: Re: [HACKERS] ODBC and palloc ...

>Davide Libenzi wrote:
>>
>> After a lot of changes I've compiled,linked and tested (regression) my
>> PostgreSQL installation no HPUX 9.*.
>>
>> I've also built and installed the ODBC driver and I get Ms Access error
>> which the PostgresSQL server log in "palloc failure : memory exausted".
>>
>> Is this a server bug or ODBC driver bug ?
>>
>
>I am assuming you have a fairly new odbc driver (6.30.0248 is the
>latest) and not the old postodbc. BTW, on our website
>(www.insightdist.com/psqlodbc) we have the DLL and a full install EXE
>for win32 so you wouldn't have to build it yourself from the source code
>if you didn't want to.
>
>The palloc failure usually occurs because Access uses the multiple OR
>query (select ... where a=1 OR a=2 OR a=3...) to access the recordset.
>The backend does not handle this very well and it is already well known
>on the TODO list.
>
>There are several possibilities to get past this:
>1. Use a non-updateable table (by setting the driver readonly option, or
>by not specifying any unique identifiers).
>2. For a query, use a snapshot recordset in the query properties.
>3. Show the OID column in the drivers advanced datasource options and
>use that alone to index on. You should create an index on it too. This
>is still slow, but at least shouldn't crash.
>
>Other possibilities:
>
>In house, Dave made a patch to postgres which rewrites the multiple OR
>query into a UNION query, which works great and its fast! We may make
>this patch available evntually on our website.
>
>Byron
>

Attachment Content-Type Size
psqlodbc.log text/plain 9.1 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1998-07-23 19:45:04 Re: [HACKERS] ODBC and palloc ...
Previous Message Vince Vielhaber 1998-07-23 19:02:04 Between broken?

Browse pgsql-interfaces by date

  From Date Subject
Next Message Bruce Momjian 1998-07-23 19:45:04 Re: [HACKERS] ODBC and palloc ...
Previous Message The Hermit Hacker 1998-07-23 19:08:37 Re: [INTERFACES] Win32 version of the psql library