From: Tom Lane <tgl@sss.pgh.pa.us>
To: Ron Johnson <ronljohnsonjr@gmail.com>
cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Subject: Re: In-order pg_dump (or in-order COPY TO)
In-reply-to: <CANzqJaAYu6ff9KqrEqU==JMNErGqszC__SZuZp1Wnwz=nFkXWQ@mail.gmail.com>
References: <s0491qrn-343s-0757-8sn5-120rr8610qqq@tzk.arg> <daf47435-539f-4368-869c-dd19a341399b@aklaver.com> <3541781s-75o7-26pp-46pp-qs54o4406192@tzk.arg> <1389082.1756304193@sss.pgh.pa.us> <CANzqJaAYu6ff9KqrEqU==JMNErGqszC__SZuZp1Wnwz=nFkXWQ@mail.gmail.com>
Comments: In-reply-to Ron Johnson <ronljohnsonjr@gmail.com>
	message dated "Wed, 27 Aug 2025 10:31:24 -0400"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <1392026.1756305777.1@sss.pgh.pa.us>
Content-Transfer-Encoding: 8bit
Date: Wed, 27 Aug 2025 10:42:57 -0400
Message-ID: <1392027.1756305777@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/1392027.1756305777%40sss.pgh.pa.us>
Precedence: bulk

Ron Johnson <ronljohnsonjr@gmail.com> writes:
> On Wed, Aug 27, 2025 at 10:16 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Don't use --format=custom (and not -v either).  That causes pg_dump to
>> include the OIDs and pg_dump object IDs of all the tables and other
>> objects,

> That's interesting.  Why?  (Since isn't it supposed to be Bad to rely on
> OIDs?)

-v in a text-format dump includes that data for debugging purposes:

--
-- TOC entry 1401 (class 1255 OID 16499)
-- Name: fipshash(text); Type: FUNCTION; Schema: public; Owner: postgres
--

(The "TOC entry" comment line wouldn't be there without -v.)
Then custom format has to store the same info so that pg_restore
can produce this identical text output on demand.

Yeah, this is all pretty historical, but nobody wants to change it
at this point.

			regards, tom lane