From: Tom Lane <tgl@sss.pgh.pa.us>
To: =?UTF-8?B?0JTQvNC40YLRgNC40Lkg0JjQstCw0L3QvtCy?= <firstdismay@gmail.com>
cc: pgsql-general@lists.postgresql.org
Subject: Re: pg_restore depending on user functions
In-reply-to: 
 <CAPL5KHrkVKVp22XE4S0ByA94-3OvH+9HC19WFFMePK2_c1VF0g@mail.gmail.com>
References: 
 <CAPL5KHoGa3uvyKp6z6m48LwCnTsK+LRQ_mcA4uKGfqAVSEjV_A@mail.gmail.com>
 <2011525.1636911069@sss.pgh.pa.us>
 <CAPL5KHrkVKVp22XE4S0ByA94-3OvH+9HC19WFFMePK2_c1VF0g@mail.gmail.com>
Comments: In-reply-to =?UTF-8?B?0JTQvNC40YLRgNC40Lkg0JjQstCw0L3QvtCy?=
 <firstdismay@gmail.com>
	message dated "Sun, 14 Nov 2021 23:37:19 +0500"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <2016239.1636915579.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Sun, 14 Nov 2021 13:46:19 -0500
Message-ID: <2016240.1636915579@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/2016240.1636915579%40sss.pgh.pa.us>
Precedence: bulk

=3D?UTF-8?B?0JTQvNC40YLRgNC40Lkg0JjQstCw0L3QvtCy?=3D <firstdismay@gmail.co=
m> writes:
> =D0=B2=D1=81, 14 =D0=BD=D0=BE=D1=8F=D0=B1. 2021 =D0=B3. =D0=B2 22:31, To=
m Lane <tgl@sss.pgh.pa.us>:
>> Usually this is caused by being careless about search_path assumptions
>> in your functions ... but with no details, it's impossible to say
>> anything with certainty.

> No, in this case it is not:
> Function A using function B.
> =D0=A1reating function A before function B results in a compilation erro=
r.
> Function B has no dependencies and is generated without errors. The seco=
nd
> run of the circuit creates function A.
> If I could specify a function dependency, it would change the order of
> recovery

This is not "details", this is an evidence-free assertion.  Please show
a concrete example of problematic functions.

>> ...  What minor release are you using?

>  PostgreSQL 14.1 (Debian 14.1-1.pgdg110+1) on x86_64-pc-linux-gnu, compi=
led
> by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
> pg_restote, pg_dump from this build

Ok, so you're up to date all right.  But again, you didn't say what
concrete problem you were having with a dump/restore of an identity
column.  It works fine for me.

			regards, tom lane