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? ;)
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
