The following bug has been logged online: Bug reference: 1534 Logged by: yingqun wang Email address: [EMAIL PROTECTED] 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