Обсуждение: ODBC error
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. I get the following error message. Microsoft OLE DB Provider for ODBC Drivers error '80004005' Error while executing the query; ERROR: pg_class_aclcheck: relation 6014747 not found The relation number keeps changing. I am calling this query using a DSN-less setuo, from an ASP page. I use the psqlodbc-07_03_0200 ODBC driver All the help to resolve this is appreciated. Thanks -- View this message in context: http://www.nabble.com/ODBC-error-tf2971825.html#a8315925 Sent from the PostgreSQL - odbc mailing list archive at Nabble.com.
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
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.
ANJANE <softwaredesigns@hotmail.com> writes: > Error while executing the query; ERROR: pg_class_aclcheck: relation 6017860 > not found > the relation oid keeps changing. Not sure what this means. It looks like it means corrupt system catalogs :-(. If you're lucky, the problem is just in the indexes --- try reindexing pg_class and see if that helps. regards, tom lane
ANJANE wrote: > 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. You can't create tables and use them safely in stored procedures unless you treat them via EXECUTE commands.. regards, Hiroshi Inoue