Postgres Pro
Downloads
Home   >   mailing lists

BUG #1534: 2^32-1 commands limitation in one transcation - Mailing list pgsql-bugs

From yingqun wang
Subject BUG #1534: 2^32-1 commands limitation in one transcation
Date
Msg-id 20050310154232.02C84F0C98@svr2.postgresql.org
Whole thread Raw
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      1534
Logged by:          yingqun wang
Email address:      yqwang@cert.ucr.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:

Previous
From: johnnnnnn
Date:
Subject: Re: [HACKERS] We are not following the spec for HAVING without GROUP BY
Next
From: "Henk van den Toorn"
Date:
Subject: BUG #1533: "*OLD*" relation not recognized in CREATE RULE