X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id D162CD904F
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 20 Oct 2005 11:44:50 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 48974-07
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 20 Oct 2005 14:44:44 +0000 (GMT)
Received: from web36712.mail.mud.yahoo.com (web36712.mail.mud.yahoo.com
	[209.191.85.46])
	by svr1.postgresql.org (Postfix) with SMTP id 614A8D6F4A
	for <pgsql-sql@postgresql.org>; Thu, 20 Oct 2005 11:44:45 -0300 (ADT)
Received: (qmail 80665 invoked by uid 60001); 20 Oct 2005 14:44:50 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.ar;
	h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=Kh+Kzt+yG9bXyq7d6SSc4lyVmhq2aL3n3zpa1WpBkB0bWPiGuEBkgOU1mE7HEWtJKv45Bi4uHfZehinZZErGpAwLGz9BzxrzO53Ar+GZPTh78zK0BF684dOWp5uUmWnUH02AF9m9pzfimDMVdxLQHiQiniK68oCw27tujv3e1Ck=
	;
Message-ID: <20051020144450.80663.qmail@web36712.mail.mud.yahoo.com>
Received: from [200.82.94.246] by web36712.mail.mud.yahoo.com via HTTP;
	Thu, 20 Oct 2005 14:44:49 GMT
Date: Thu, 20 Oct 2005 14:44:49 +0000 (GMT)
From: Adriana Marcela Aguirre <ing_adriana_aguirre@yahoo.com.ar>
Subject: Sql - Error : Relation tmp_datos already exists
To: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-567503415-1129819489=:80643"
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.505 required=5 tests=[HTML_20_30=0.504,
	HTML_MESSAGE=0.001]
X-Spam-Level: 
X-Archive-Number: 200510/234
X-Sequence-Number: 23087

--0-567503415-1129819489=:80643
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit


Hello!

Mario Splivalo:Thank you very much for your helpl!!!

 

I´m working with postgres 7.4.1.  and VFoxPro 5. 
I call a function (Postgresql) many times from VFoxPro:

sql = "select * from f_rep_datos_lab( 'USUARIO')"
aaa=sqlexec(db_cone,sql, "report")

 

This function use temporary tables wich are created with "ON COMMIT DROP".

There is a problem because the temporary table already exists during the second execution of the function. ("Relation tmp_datos already exists")

 

But...iIf i call this function many times in the same PgAdmin' session, f.e.,  there weren't problems. The querys in that functions are execuded with "EXECUTE".

 

Whi?....what's wrong whit this calling?

Any idea will be welcome.

 

Thanks

 

Adriana

 


		
---------------------------------
 1GB gratis, Antivirus y Antispam
 Correo Yahoo!, el mejor correo web del mundo
 Abrí tu cuenta aquí
--0-567503415-1129819489=:80643
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

<P>Hello!</P>
<P>Mario Splivalo:Thank you very much for your helpl!!!</P>
<P>&nbsp;</P>
<P>I´m working with postgres 7.4.1.&nbsp; and VFoxPro 5. <BR>I call a function (Postgresql) many times from VFoxPro:</P>
<P>sql = "select * from f_rep_datos_lab( 'USUARIO')"<BR>aaa=sqlexec(db_cone,sql, "report")</P>
<P>&nbsp;</P>
<P>This function use temporary tables wich are created with "ON COMMIT DROP".</P>
<P>There is a problem because the temporary table already exists during the second execution of the function. ("Relation tmp_datos already exists")</P>
<P>&nbsp;</P>
<P>But...iIf i call this function many times in the same PgAdmin' session, f.e.,&nbsp; there weren't problems. The querys in that functions are execuded with "EXECUTE".</P>
<P>&nbsp;</P>
<P>Whi?....what's wrong whit this calling?</P>
<P>Any idea will be welcome.</P>
<P>&nbsp;</P>
<P>Thanks</P>
<P>&nbsp;</P>
<P>Adriana</P>
<P>&nbsp;</P>
<DIV></DIV><p>
		<hr size=1> 
<font color="#9900FF"><b>1GB gratis</b></font>, Antivirus y Antispam<br> 
<font color="#9900FF">Correo Yahoo!</font>, el mejor correo web del mundo<br> 
<a href="http://login.yahoo.com/config/mail?.intl=ar">Abrí tu cuenta aquí</a>
--0-567503415-1129819489=:80643--