Re: PSQLODBC error - Mailing list pgsql-interfaces

From Byron Nikolaidis
Subject Re: PSQLODBC error
Date
Msg-id 370E81AD.5A533D54@insightdist.com
Whole thread Raw
In response to PSQLODBC error  ("Ken J. Wright" <ken@ori-ind.com>)
List pgsql-interfaces

Ken J. Wright wrote:

> Byron,
>
> Some more info. In the driver setup, if Parse Statements is checked, the
> error occurs. If not checked, then all is ok. I noticed in parse.c that
> memory for field info is allocated in 32 field blocks. Perhaps the error is
> here? At least I am now out of the deep water.
>
>

Yeah, I had a feeling about the parse statements thing.  I think you found a
bug.

FYI, the "parse statements" option was added before we had the 6.4 protocol.
The newer protocol passes the size of the fields back in a query, which is
something the old 6.3 protocol did not do.  So I wrote this grand parse routine
which would take a query and go ask the database about all the fields.   The
"parse statements" still has an advantage over the 6.4 protocol, in that it can
find out about whether a field in a query can be "null" or not.  Plus,  it can
find out about column alias names.     Unfortunately, I don't think the parse
statements can handle some of the newer syntaxes that will be introduced in
6.5.

To be honest, I don't think the driver should be parsing sql statements too
much anyway.


Byron





pgsql-interfaces by date:

Previous
From: Byron Nikolaidis
Date:
Subject: Re: [INTERFACES] ODBC Driver v06-40-0005
Next
From: "Mikhail Romanenko"
Date:
Subject: [INTERFACES] ODBC Driver v06-40-0005