Re: PSQLODBC error

Поиск
Список
Период
Сортировка
От Byron Nikolaidis
Тема Re: PSQLODBC error
Дата
Msg-id 370E81AD.5A533D54@insightdist.com
обсуждение исходный текст
Ответ на PSQLODBC error  ("Ken J. Wright" <ken@ori-ind.com>)
Список 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 по дате отправления:

Предыдущее
От: Byron Nikolaidis
Дата:
Сообщение: Re: [INTERFACES] ODBC Driver v06-40-0005
Следующее
От: "Mikhail Romanenko"
Дата:
Сообщение: [INTERFACES] ODBC Driver v06-40-0005