Re: [SQL] Sql - Error : Relation tmp_datos already exists

2005-10-24 Thread tobbe
PgAdmin probably encloses all querys in transactions. Do you? If not, try execute "BEGIN" and "COMMIT" just before and after your query.. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[SQL] Sql - Error : Relation tmp_datos already exists

2005-10-20 Thread Adriana Marcela Aguirre
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 cr