The following bug has been logged online:
Bug reference: 1534
Logged by: yingqun wang
Email address: yqwang(at)cert(dot)ucr(dot)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