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 <tgl@xxxxxxxxxxxxx> wrote: > >> Glyn Astill <glynastill@xxxxxxxxxxx> >> 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 (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
