From: Tom Lane <tgl@sss.pgh.pa.us>
To: Greg Stark <stark@mit.edu>
cc: "David G. Johnston" <david.g.johnston@gmail.com>,
        "thierrym@gmail.com" <thierrym@gmail.com>,
        "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #17902: export/import tenant not possible due to PG internal
 id on jsonB fields.
In-reply-to: 
 <CAM-w4HPP8Ki33mqkv10aYuMZMJwMuX4xyZ1_6r9yqg+iGLFFgQ@mail.gmail.com>
References: <17902-e75daa72de96a626@postgresql.org>
 <CAKFQuwa4BsgppQ_w09nq1oXp=Hcvofo9k=tHjoTR+Po7KO2MUQ@mail.gmail.com>
 <CAM-w4HPP8Ki33mqkv10aYuMZMJwMuX4xyZ1_6r9yqg+iGLFFgQ@mail.gmail.com>
Comments: In-reply-to Greg Stark <stark@mit.edu>
	message dated "Mon, 17 Apr 2023 11:51:49 -0400"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <2444930.1681748317.1@sss.pgh.pa.us>
Date: Mon, 17 Apr 2023 12:18:37 -0400
Message-ID: <2444931.1681748317@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/2444931.1681748317%40sss.pgh.pa.us>
Precedence: bulk

Greg Stark <stark@mit.edu> writes:
> But large objects are kind of a leaky abstraction in that the internal
> ID becomes a user-visible identifier that is the only way users have
> of referencing these objects.

> I could see it being pretty useful to have an user-controlled
> identifier instead of forcing users to use OIDs.

You already can create LOBs with any identifier you want, as long
as it's an int4.  The OP seems to think he can mix manual allocation
with automatic allocation of those IDs and it should just work.

> But the bad news is that I don't think anyone's really excited about
> working on the LOB facility.

Yeah.  There's been some discussion of widening the identifiers to
int8, but I can't see going further than that.  UUIDs would be a
disaster for a number of reasons, both performance and compatibility
related.

			regards, tom lane