pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ligia Pimentel <lmpimentel@yahoo.com>
To: pgsql-sql@postgresql.org
Subject: Error when selecting rows from a temporary table in ODBC
Date: Wed, 21 Mar 2001 11:25:09 -0600
Message-ID: <99ao69$25ul$1@news.tht.net> (raw)

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





view thread (3+ messages)  latest in thread

Message-ID: <99ao69$25ul$1@news.tht.net>
Permalink:  ../99ao69$25ul$1@news.tht.net/
Also on:    postgresql.org/message-id/99ao69$25ul$1@news.tht.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: lmpimentel@yahoo.com
  Subject: Re: Error when selecting rows from a temporary table in ODBC
  In-Reply-To: <99ao69$25ul$1@news.tht.net>
  References: <99ao69$25ul$1@news.tht.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox