pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Sql - Error : Relation tmp_datos already exists
2+ messages / 2 participants
[nested] [flat]

* Sql - Error : Relation tmp_datos already exists
@ 2005-10-20 14:44 Adriana Marcela Aguirre <ing_adriana_aguirre@yahoo.com.ar>
  2005-10-21 12:44 ` Re: Sql - Error : Relation tmp_datos already exists tobbe <tobbe@tripnet.se>
  0 siblings, 1 reply; 2+ messages in thread

From: Adriana Marcela Aguirre @ 2005-10-20 14:44 UTC (permalink / raw)
  To: pgsql-sql


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í

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Sql - Error : Relation tmp_datos already exists
  2005-10-20 14:44 Sql - Error : Relation tmp_datos already exists Adriana Marcela Aguirre <ing_adriana_aguirre@yahoo.com.ar>
@ 2005-10-21 12:44 ` tobbe <tobbe@tripnet.se>
  0 siblings, 0 replies; 2+ messages in thread

From: tobbe @ 2005-10-21 12:44 UTC (permalink / raw)
  To: pgsql-sql

PgAdmin probably encloses all querys in transactions. Do you?

If not, try execute "BEGIN" and "COMMIT" just before and after your
query..




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2005-10-21 12:44 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-10-20 14:44 Sql - Error : Relation tmp_datos already exists Adriana Marcela Aguirre <ing_adriana_aguirre@yahoo.com.ar>
2005-10-21 12:44 ` tobbe <tobbe@tripnet.se>

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