Re: [GENERAL] commit transaction failed

2007-06-29 Thread Jim Nasby
I don't know about the error, but I think there's far more efficient ways to do what you're doing see below: On Jun 20, 2007, at 1:25 AM, [EMAIL PROTECTED] wrote: I m having a problem while calling the procedure in prostgresql 8.2 from adoconnection, It gets executed for some time and afte

[GENERAL] commit transaction failed

2007-06-25 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