Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql General > Too many comman...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 15130 of 17637
Post > Topic >>

Too many commands in a transaction

by sam <sam.mahindrakar@[EMAIL PROTECTED] > Apr 1, 2008 at 01:34 PM

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
 




 2 Posts in Topic:
Too many commands in a transaction
sam <sam.mahindrakar@[  2008-04-01 13:34:44 
Re: Too many commands in a transaction
tgl@[EMAIL PROTECTED] (T  2008-04-01 17:24:46 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Fri Dec 5 6:52:57 CST 2008.