[BUGS] BeginTransaction failed when calling postgresql procedure with ado

2007-06-20 Thread nasim . sindri
PLATEFORM: VC++ 7 , ADO, WINDOWS 2003, POSTGRE 8.2 I m having a problem while calling the procedure in prostgresql 8.2 from adoconnection, It gets executed for some time and after 5-10 call it gives error either startTransaction failed or commit failed. CREATE OR REPLACE FUNCTION sp_getnewfiles(I

[BUGS] commit transaction failed

2007-06-20 Thread nasim . sindri
I m having a problem while calling the procedure in prostgresql 8.2 from adoconnection, It gets executed for some time and after 5-10 call it gives error startTransaction failed or CommitTransaction Failed. CREATE OR REPLACE FUNCTION sp_getnewfiles(IN strserverid character varying, IN nmaxcount in