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
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?
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2005-03-10 17:44:50|
|Subject: Re: [HACKERS] We are not following the spec for HAVING without GROUP BY |
|Previous:||From: Tom Lane||Date: 2005-03-10 15:15:08|
|Subject: Re: ALTER DATABASE ... RENAME: permission denied for superuser |