Re: pg_restore depending on user functions - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_restore depending on user functions
Date
Msg-id 2048100.1636934771@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_restore depending on user functions  (Дмитрий Иванов <firstdismay@gmail.com>)
Responses Re: pg_restore depending on user functions  (Дмитрий Иванов <firstdismay@gmail.com>)
List pgsql-general
=?UTF-8?B?0JTQvNC40YLRgNC40Lkg0JjQstCw0L3QvtCy?= <firstdismay@gmail.com> writes:
> вс, 14 нояб. 2021 г. в 23:46, Tom Lane <tgl@sss.pgh.pa.us>:
>> This is not "details", this is an evidence-free assertion.  Please show
>> a concrete example of problematic functions.

> Ok, I'll do it.
> [ example ]

This is pretty far from being a self-contained example; I had to guess
at the definitions of several types that you didn't provide.  Having
done so, though, the set of functions and types seem to dump and restore
just fine.  So I still don't see any problem here.

Possibly worth noting is that pg_dump is careful to include this in
its output script:

SET check_function_bodies = false;

Without that, I can believe that you'd have some trouble restoring
these functions, since pg_dump doesn't know anything about the
cross-references appearing in the function bodies.  But with that,
there don't appear to be any troublesome cross-references here.

            regards, tom lane



pgsql-general by date:

Previous
From: Дмитрий Иванов
Date:
Subject: Re: pg_restore depending on user functions
Next
From: "Chen, Yan-Jack (NSB - CN/Hangzhou)"
Date:
Subject: PostgreSQL debug log doesn't record whole procedure(from receiving request to sending response)