Re: Too many commands in a transaction

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: sam <sam(dot)mahindrakar(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Too many commands in a transaction
Date: 2008-04-01 21:24:46
Message-ID: 14675.1207085086@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

sam <sam(dot)mahindrakar(at)gmail(dot)com> writes:
> ERROR: cannot have more than 2^32-1 commands in a transaction

> But this error is occuring in a function that iam least expecting it
> to occur in.

If you haven't marked the function as read-only (IMMUTABLE or STABLE)
then each statement in it counts as a command. At least in pre-8.3
releases. You might find that updating to 8.3 would eliminate the
need to change your code.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Wigal (Referee Assistant) 2008-04-01 21:44:05 Re: Connection reset by peer / broken pipe
Previous Message Tom Lane 2008-04-01 21:22:08 Re: simple update queries take a long time - postgres 8.3.1