From: Byron Nikolaidis <byronn@insightdist.com>
To: Ken J. Wright <ken@ori-ind.com>
Cc: pgsql-interfaces@postgreSQL.org <pgsql-interfaces@postgreSQL.org>
Subject: Re: PSQLODBC error
Date: Fri, 09 Apr 1999 18:39:41 -0400
Message-ID: <370E81AD.5A533D54@insightdist.com> (raw)
References: <3.0.32.19990409100931.008e4230@ren.cncware.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: byronn@insightdist.com, ken@ori-ind.com
Subject: Re: PSQLODBC error
In-Reply-To: <370E81AD.5A533D54@insightdist.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox