Skip site navigation (1) Skip section navigation (2)

BUG #1534: 2^32-1 commands limitation in one transcation

From: "yingqun wang" <yqwang(at)cert(dot)ucr(dot)edu>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1534: 2^32-1 commands limitation in one transcation
Date: 2005-03-10 15:42:32
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
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 LaneDate: 2005-03-10 17:44:50
Subject: Re: [HACKERS] We are not following the spec for HAVING without GROUP BY
Previous:From: Tom LaneDate: 2005-03-10 15:15:08
Subject: Re: ALTER DATABASE ... RENAME: permission denied for superuser

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group