Re: Commands per transaction

Rod Taylor schrieb:
> On Sat, 2006-01-21 at 12:48 -0300, Alvaro Herrera wrote:
> 
>>Rod Taylor wrote:
>>
>>>Is there any way of bumping this limit or am I stuck breaking up the
>>>transaction?
>>
>>Wow, I never heard of anyone reaching the limit :-(  Sorry, you are
>>stuck (short of changing CommandId to 64 bits, which would bloat your
>>tables considerably ...)
> 
...

As a quick fix (as is quickly fixed, quick running ;)
You could load your update data to a temp table via
COPY and then update a large table in one sweep.
I guess you dont have 2^31 tables to update? ;)