Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.3/8.11.1) with SMTP id f2LK52t36106 for ; Wed, 21 Mar 2001 15:05:02 -0500 (EST) (envelope-from pgsql-sql-owner@postgresql.org) Received: from news.tht.net (news.hub.org [216.126.91.242]) by mail.postgresql.org (8.11.3/8.11.1) with ESMTP id f2LHdnt15019 for ; Wed, 21 Mar 2001 12:39:49 -0500 (EST) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.1/8.11.1) id f2LHPV371640 for pgsql-sql@postgresql.org; Wed, 21 Mar 2001 12:25:31 -0500 (EST) (envelope-from news) From: "Ligia Pimentel" X-Newsgroups: comp.databases.postgresql.sql Subject: Error when selecting rows from a temporary table in ODBC Date: Wed, 21 Mar 2001 11:25:09 -0600 Organization: . Lines: 116 Message-ID: <99ao69$25ul$1@news.tht.net> Reply-To: "Ligia Pimentel" X-Complaints-To: scrappy@hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 To: pgsql-sql@postgresql.org X-Archive-Number: 200103/423 X-Sequence-Number: 2091 When we execute this query in psql over linux, we don't get any errors select sum(valor) as totalCR, count(correlativo) as docsCR, caja into tmp_cr from transaccion as t, codigocaja as c where c.codigo = t. codigo and c.tipomov = 'CR' group by caja; select sum(valor) as totalDB, count(correlativo) as docsDB, caja into tmp_db from transaccion t, codigocaja c where c.codigo = t. codigo and c.tipomov = 'DB' group by caja; select db.caja, totalcr, totaldb, docsdb, docscr from tmp_db db, tmp_cr cr where cr.caja = db.caja; But when we execute it on PGAdmin (Windows via ODBC) we get the following error message: ERROR from backend during clear: 'ERROR: relation_info: Relation 2300301 not found Following is the message in psqlodbc.log, conn=57295424, query='drop table tmp_cr; drop table tmp_db; select sum(valor) as totalCR, count(correlativo) as docsCR, caja into tmp_cr from transaccion as t, codigocaja as c where c.codigo = t. codigo and c.tipomov = 'CR' group by caja; select sum(valor) as totalDB, count(correlativo) as docsDB, caja into tmp_db from transaccion t, codigocaja c where c.codigo = t. codigo and c.tipomov = 'DB' group by caja; select db.caja, totalcr, totaldb, docsdb, docscr from tmp_db db, tmp_cr cr where cr.caja = db.caja; ' NOTICE from backend during send_query: 'NOTICE: mdopen: couldn't open tmp_db: No such file or directory ' NOTICE from backend during send_query: 'NOTICE: mdopen: couldn't open tmp_cr: No such file or directory ' NOTICE from backend during send_query: 'NOTICE: mdopen: couldn't open tmp_db: No such file or directory ' NOTICE from backend during send_query: 'NOTICE: mdopen: couldn't open tmp_cr: No such file or directory ' NOTICE from backend during send_query: 'NOTICE: mdopen: couldn't open tmp_cr: No such file or directory ' NOTICE from backend during send_query: 'NOTICE: mdopen: couldn't open tmp_cr: No such file or directory ' NOTICE from backend during clear: 'NOTICE: mdopen: couldn't open tmp_db: No such file or directory ' NOTICE from backend during clear: 'NOTICE: mdopen: couldn't open tmp_db: No such file or directory ' Command response: 'DROP' Command response: 'SELECT' Command response: 'SELECT' ERROR from backend during clear: 'ERROR: relation_info: Relation 2300301 not found ' STATEMENT ERROR: func=SC_execute, desc='', errnum=-1, errmsg='Error while executing the query (non-fatal)' ----------------------------------------------------------- - hdbc=57295424, stmt=57310092, result=63909376 manual_result=0, prepare=0, internal=0 bindings=0, bindings_allocated=0 parameters=0, parameters_allocated=0 statement_type=6, statement='drop table tmp_cr; drop table tmp_db; select sum(valor) as totalCR, count(correlativo) as docsCR, caja into tmp_cr from transaccion as t, codigocaja as c where c.codigo = t. codigo and c.tipomov = 'CR' group by caja; select sum(valor) as totalDB, count(correlativo) as docsDB, caja into tmp_db from transaccion t, codigocaja c where c.codigo = t. codigo and c.tipomov = 'DB' group by caja; select db.caja, totalcr, totaldb, docsdb, docscr from tmp_db db, tmp_cr cr where cr.caja = db.caja; ' stmt_with_params='drop table tmp_cr; drop table tmp_db; select sum(valor) as totalCR, count(correlativo) as docsCR, caja into tmp_cr from transaccion as t, codigocaja as c where c.codigo = t. codigo and c.tipomov = 'CR' group by caja; select sum(valor) as totalDB, count(correlativo) as docsDB, caja into tmp_db from transaccion t, codigocaja c where c.codigo = t. codigo and c.tipomov = 'DB' group by caja; select db.caja, totalcr, totaldb, docsdb, docscr from tmp_db db, tmp_cr cr where cr.caja = db.caja; ' data_at_exec=-1, current_exec_param=-1, put_data=0 currTuple=-1, current_col=-1, lobj_fd=-1 maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0, scroll_concurrency=1 cursor_name='SQL_CUR036A7B8C' ----------------QResult Info ------------------------------- fields=63909344, manual_tuples=0, backend_tuples=0, tupleField=0, conn=0 fetch_count=0, fcount=0, num_fields=0, cursor='(NULL)' message='(NULL)', command='DROP', notice='NOTICE: mdopen: couldn't open tmp_cr: No such file or directory ' status=6, inTuples=0 CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR: relation_info: Relation 2300301 not found ' ------------------------------------------------------------ henv=63901552, conn=57295424, status=1, num_stmts=16 sock=63901504, stmts=63901424, lobj_type=-999 ---------------- Socket Info ------------------------------- socket=180, reverse=0, errornumber=0, errormsg='(NULL)' buffer_in=57301892, buffer_out=57305992 buffer_filled_in=3, buffer_filled_out=0, buffer_read_in=2 Thank you for your help! Ligia