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

Поиск
Список
Период
Сортировка
От yingqun wang
Тема BUG #1534: 2^32-1 commands limitation in one transcation
Дата
Msg-id 20050310154232.02C84F0C98@svr2.postgresql.org
обсуждение исходный текст
Список pgsql-bugs
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 по дате отправления:

Предыдущее
От: johnnnnnn
Дата:
Сообщение: Re: [HACKERS] We are not following the spec for HAVING without GROUP BY
Следующее
От: "Henk van den Toorn"
Дата:
Сообщение: BUG #1533: "*OLD*" relation not recognized in CREATE RULE