From: | ANJANE <softwaredesigns(at)hotmail(dot)com> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: ODBC error |
Date: | 2007-01-16 14:02:25 |
Message-ID: | 8390489.post@talk.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | sandarsh.devappa | 2007-01-16 14:30:37 | Re: ODBC wrapper code for postgreSql 8.2 |
Previous Message | Bart Samwel | 2007-01-16 11:00:00 | Re: ODBC wrapper code for postgreSql 8.2 |