ANJANE wrote:
> I am executing a procedure that returns data from a temp table created.
> Sometimes the query works at the first attempt, but fails on subsequent
> attempts. It is intermittent. Leaving some time between queries, it works
> fine.
>
> Basically, in my query, I do some joins of tables, load the data to a temp
> table and return all the data from the temp table via a cursor to the user.
> I drop the temp table if it exists at the beginning.
>
It doesn't seem a problem of the odbc driver.
Please try it via psql and see the result.
regards,
Hiroshi Inoue