Re: 4B row limit for CLOB tables

From: Tatsuo Ishii <ishii(at)postgresql(dot)org>
To: steve(at)blighty(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: 4B row limit for CLOB tables
Date: 2015-01-29 23:17:03
Message-ID: 20150130.081703.86526503323626229.t-ishii@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

> 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 table.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2015-01-30 00:59:58 Re: trouble adding a node to BDR
Previous Message Alex Hunsaker 2015-01-29 23:09:33 Re: segmentation fault postgres 9.3.5 core dump perlu related ?

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2015-01-29 23:38:46 Re: INSERT ... ON CONFLICT {UPDATE | IGNORE} 2.0
Previous Message Tom Lane 2015-01-29 23:14:02 Re: Proposal: two new role attributes and/or capabilities?