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: 20050310154232.02C84F0C98@svr2.postgresql.org (view raw or flat)
Thread:
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
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

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-2014 The PostgreSQL Global Development Group