Re: Re(2): Re(2): Large Object dump ? - Mailing list pgsql-sql

From Tom Lane
Subject Re: Re(2): Re(2): Large Object dump ?
Date
Msg-id 25781.973185425@sss.pgh.pa.us
Whole thread Raw
In response to Re(2): Re(2): Large Object dump ?  ("pgsql-sql" <pgsql-sql@fc.emc.com.ph>)
List pgsql-sql
"pgsql-sql" <pgsql-sql@fc.emc.com.ph> writes:
> Exported 1131 large objects.
> NOTICE:  LockReleaseAll: xid loop detected, giving up

Pre-7.0 LockReleaseAll() contained an entirely arbitrary assumption
that it should never encounter a situation where there were more than
1000 locks held by one transaction :-(.  So it chokes when you access
more than 1000 LOs in the same transaction.

Dunno about your other issue, but clearly your application is
failing to report whatever error message was returned when the
transaction was aborted...
        regards, tom lane


pgsql-sql by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Outer Joins
Next
From: Bruno Boettcher
Date:
Subject: PL/PGSQL beginning is hard....