Re: SQLTables don't stop

Поиск
Список
Период
Сортировка
От Ludek Finstrle
Тема Re: SQLTables don't stop
Дата
Msg-id 20051209114058.GA12145@soptik.pzkagis.cz
обсуждение исходный текст
Ответы Re: SQLTables don't stop  (Ludek Finstrle <luf@pzkagis.cz>)
Список pgsql-odbc
> > > *However*, whilst testing I did find an issue with SQLTables that
> > > seems surprisingly similar to the one you fixed before. It's pretty
> > > easy to recreate in the Microsoft test suite.
> >
> > I didn't fix something similar. I don't remember it at least. Could
> > you be more specific? I only point at Prepare, Execute, Execute or
> > ExecDirect, ExecDirect problem.
>
> There was a fix for SQLTables where Declare/Fetch messed things up for
> Borland SQL Explorer/BDE by duplicating rows.

Yes. I didn't think it's problem. But maybe it is.

> > > - Connect to a data source with Declare/Fetch enabled.
> > > - SQLExecDirect "SELECT * FROM pg_class"
> > > - Get Data All (from the results menu)
> > > - SQLTables
> > > - Get Data All
> > >
> > > It never stops retrieving data! Seems that you need to do the
> > > SQLExecDirect first - SQLExecute doesn't trigger the problem.
> > > SQLColumns is similarly affected - perhaps there are more as well.
> >
> > I'm unable reproduce it here. I have CVS source with
> > autocommit_off patch.
> > It stops when I expect.
>
> Odd.

You forgot say that you setup cache size to 10 :-) That's the difference.
I read it from log. So I'm able to reproduce the problem now.

Regards,

Luf

В списке pgsql-odbc по дате отправления:

Предыдущее
От: Marc Herbert
Дата:
Сообщение: Re: BLOB handling compatibility with PostgreSQL > 7.4
Следующее
От: "Dave Page"
Дата:
Сообщение: Re: SQLTables don't stop