Postgres Pro
Downloads
Home   >   mailing lists

Re: data volume resizing and large objects - Mailing list pgsql-general

From Tom Lane
Subject Re: data volume resizing and large objects
Date
Msg-id 22447.1199479350@sss.pgh.pa.us
Whole thread Raw
In response to data volume resizing and large objects  ("beer@cmu.edu" <beer@cmu.edu>)
Responses Re: data volume resizing and large objects
List pgsql-general
Tree view 
"beer@cmu.edu" <beer@cmu.edu> writes:
> lo_creat fails with:
>      ERROR: large object <oid> already exists

Well, does it?

What PG version is this?  I'm suspicious that it's pre-8.1 and the
problem is that your OID counter has wrapped around to a region that
is already pretty densely populated with large objects.  8.1 and up
are able to pick unused OIDs but earlier versions just fail on
collisions.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Concurrent modification of plpgsql function body
Next
From: Alvaro Herrera
Date:
Subject: Re: [OT] Slony (initial) Replication - Slow