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

Re: [INTERFACES] new odbc fails

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: byronn(at)insightdist(dot)com (Byron Nikolaidis)
Cc: john(dot)boris(at)onlinesvc(dot)com, pgsql-interfaces(at)postgreSQL(dot)org, daveh(at)insightdist(dot)com
Subject: Re: [INTERFACES] new odbc fails
Date: 1998-08-26 16:38:46
Message-ID: 199808261638.MAA15502@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-interfaces
> 
> 
> John J. Boris, Sr. wrote:
> 
> > I downloaded and installed the new odbc driver. I am running WIndows NT 4.0
> > and my PostreSQL is on a LINUX box. I can connect to the database using MS
> > Access 97, link the tables, it allows me to select unique keys for each
> > table but when I try to view a table I get an ODBC failed message and the
> > table is filled with NAME#.
> >
> 
> This is most likely because of the backend canonifier problem.  Check your
> psqlodbc.log (enabled with the CommLog driver option) file to see if there is
> an error message from the backend concerning "palloc failure, memory
> exhausted".
> 
> The unique key you are specifying in Access can result in "keyset" queries of
> the form:
> 
> select from table where (k1 = 1 AND k2 = 1 AND k3 = 1) OR (k1 = 1 AND k2 = 1
> AND k3 = 2) ......... (k1 = 1 and k2 = 1 and k3 = 10)
> 
> Access usually uses a rowset size of 10, thus you will have 10 groups of ORs.
> Depending on how many parts your key is made up of, your AND groupings may look
> differently than I have shown it.
> 
> Bottom line is, a fix for the backend is being worked on in two different
> capacities.  One fix, which we use here, is a patch, written by Dave Hartwig,
> which rewrites the statements into UNIONS in the backend.  This is called the
> KSQO patch (KeySet Query Optimization, enabled with the set ksqo to 'ON'
> command, which you can put in the Connect Settings driver/datasource options).
> I'm not sure if we have this patch on our website or if it will be included in
> Postgres 6.4.  You may want to check the website and inquire about it.
> 
> Also, Bruce Momjian  is trying to fix the problem in the backend.  I'm not sure
> of its current status or if it will be complete in Postgres 6.4.

I am ready to address this.  I will send an e-mail today.

-- 
Bruce Momjian                          |  830 Blythe Avenue
maillist(at)candle(dot)pha(dot)pa(dot)us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

In response to

pgsql-interfaces by date

Next:From: Frank DelahoydeDate: 1998-08-26 16:41:14
Subject: odbc and cursor library
Previous:From: Wojciech OlejarzDate: 1998-08-26 15:51:55
Subject: some trouble

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