Too many commands in a transaction

From: sam <sam(dot)mahindrakar(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Too many commands in a transaction
Date: 2008-04-01 20:34:44
Message-ID: b3fb2fdd-339c-4bff-9c60-5598e0227000@e67g2000hsa.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi
ERROR: cannot have more than 2^32-1 commands in a transaction
SQL state: 54000
Iam getting the above error when iam running my program. If iam not
wrong this error ocuurs when there are too many statements executing
in one single transaction.
But this error is occuring in a function that iam least expecting it
to occur in. The function it occurs in is as follows:
BEGIN
resultindex := 1;

-- Go through summedprobs, find where rnum falls, set resultindex
FOR i IN REVERSE (array_upper(summedprobs,1)-1)..1 LOOP
IF rnum >= summedprobs[i] AND rnum <= summedprobs[i+1] THEN
resultindex := i;
END IF;
END LOOP;

RETURN (dobs[resultindex]);
EXCEPTION WHEN program_limit_exceeded THEN
RAISE NOTICE 'Exception in GETRES';
RETURN (dobs[resultindex]);
END;

Is is beacuse of the REVERSE command? or because the program is
executiung many select and update statements?
Catching the exception isnt helping here either.Can anyone explain me
why this error occurs and what i can do to resolve it?

Thanks
Sam

Responses

Browse pgsql-general by date

  From Date Subject
Next Message mark 2008-04-01 20:41:34 Re: simple update queries take a long time - postgres 8.3.1
Previous Message Daniel Verite 2008-04-01 20:25:24 Re: Using tables in other PostGreSQL database