As I said the query works intermittently. Whenever it fails, I get the
following error message
..select tp_get_clientusers('1','S%', 'rcursor');fetch all in rcursor;
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Error while executing the query; ERROR: pg_class_aclcheck: relation 6017860
not found
/portal/testdb.asp, line 82
the relation oid keeps changing. Not sure what this means.
Sreyams
Hiroshi Inoue wrote:
>
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
>
--
View this message in context: http://www.nabble.com/ODBC-error-tf2971825.html#a8390489
Sent from the PostgreSQL - odbc mailing list archive at Nabble.com.