> I'm not sure whether it's mentioned explicitly, but large objects are
> referenced by an OID, which is a 32 bit value (and a global resource).
Large object is not necessarily referenced by OID since 8.1. You can
assign arbitrary 32 bit integers as long as they are unique in the
pg_largeobject ta
On 1/29/15, Steve Atkins wrote:
>
> On Jan 29, 2015, at 9:53 AM, Roger Pack wrote:
>
>> On 1/29/15, Roger Pack wrote:
>>> Hello. I see on this page a mention of basically a 4B row limit for
>>> tables that have BLOB's
>>
>> Oops I meant for BYTEA or TEXT columns, but it's possible the
>> reason
Forgot to reply all on this one, many thanks to Steve Adrian and Bill
for their answers.
On Jan 29, 2015, at 12:32 PM, Roger Pack wrote:
> On 1/29/15, Steve Atkins wrote:
>>
>> On Jan 29, 2015, at 9:53 AM, Roger Pack wrote:
>>
>>> On 1/29/15, Roger Pack wrote:
Hello. I see on this page
On Thu, 29 Jan 2015 10:41:58 -0800
Steve Atkins wrote:
>
> >> Is this fact mentioned in the documentation anywhere? Is there an
> >> official source for this? (If not, maybe consider this a feature
> >> request to mention it in the documentation on BLOB).
> >> Cheers and thanks.
> >> -roger
>
> I
On Jan 29, 2015, at 9:53 AM, Roger Pack wrote:
> On 1/29/15, Roger Pack wrote:
>> Hello. I see on this page a mention of basically a 4B row limit for
>> tables that have BLOB's
>
> Oops I meant for BYTEA or TEXT columns, but it's possible the
> reasoning is the same...
It only applies to lar
On 01/29/2015 09:51 AM, Roger Pack wrote:
Hello. I see on this page a mention of basically a 4B row limit for
tables that have BLOB's
https://wiki.postgresql.org/wiki/BinaryFilesInDB
Is this fact mentioned in the documentation anywhere? Is there an
official source for this? (If not, maybe consi
On 1/29/15, Roger Pack wrote:
> Hello. I see on this page a mention of basically a 4B row limit for
> tables that have BLOB's
Oops I meant for BYTEA or TEXT columns, but it's possible the
reasoning is the same...
> https://wiki.postgresql.org/wiki/BinaryFilesInDB
>
> Is this fact mentioned in t
Hello. I see on this page a mention of basically a 4B row limit for
tables that have BLOB's
https://wiki.postgresql.org/wiki/BinaryFilesInDB
Is this fact mentioned in the documentation anywhere? Is there an
official source for this? (If not, maybe consider this a feature
request to mention it in
