Re: SQLTables don't stop - Mailing list pgsql-odbc

From Ludek Finstrle
Subject Re: SQLTables don't stop
Date
Msg-id 20051209114058.GA12145@soptik.pzkagis.cz
Whole thread Raw
Responses Re: SQLTables don't stop  (Ludek Finstrle <luf@pzkagis.cz>)
List 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 by date:

Previous
From: Marc Herbert
Date:
Subject: Re: BLOB handling compatibility with PostgreSQL > 7.4
Next
From: "Dave Page"
Date:
Subject: Re: SQLTables don't stop