From: Adriana Marcela Aguirre <ing_adriana_aguirre@yahoo.com.ar>
To: pgsql-sql@postgresql.org
Subject: Sql - Error : Relation tmp_datos already exists
Date: Thu, 20 Oct 2005 14:44:49 +0000 (GMT)
Message-ID: <20051020144450.80663.qmail@web36712.mail.mud.yahoo.com> (raw)
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í
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 using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ing_adriana_aguirre@yahoo.com.ar
Subject: Re: Sql - Error : Relation tmp_datos already exists
In-Reply-To: <20051020144450.80663.qmail@web36712.mail.mud.yahoo.com>
* 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