On 21 May 2010, at 11:58, Glyn Astill wrote: > Well I've ony just gotten round to taking another look at this, response > inline below: > > --- On Fri, 30/4/10, Tom Lane <[email protected]> wrote: > >> Glyn Astill <[email protected]> >> writes: >>> The schema is fairly large, but I will try. >> >> My guess is that you can reproduce it with not a lot of >> data, if you can >> isolate the trigger condition. >> > > Hmm, tried reducing the amount of data and the issue goes away. Could this > indicate some issue with the file, like an issue with it's size (~~ 5gb)? Or > could it be an issue with the data itself?
The file-size in combination with an "out of order" error smells of a 32-bit integer wrap-around problem. And indeed, from the documentation (http://www.postgresql.org/docs/8.4/interactive/lo-intro.html): "One remaining advantage of the large object facility is that it allows values up to 2 GB in size" So I guess your large object is too large. Alban Hertroys -- If you can't see the forest for the trees, cut the trees and you'll see there is no forest. !DSPAM:737,4bf6617510414104348269! -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
