The following bug has been logged online:

Bug reference: 1534
Logged by: yingqun wang
Email address: yqwang (AT) cert (DOT) ucr.edu
PostgreSQL version: 8.0
Operating system: fedora
Description: 2^32-1 commands limitation in one transcation
Details:

My plpgsql function loop through a table(40,000) and do a calculation for 24
hours* 365 days for each record. When the preogram run about 74 records, it
give a error that can not have more than 2^32-1 commands in one transcation.
How can I avoid this?


thanks

ying

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org