pg_restore depending on user functions

From: Дмитрий Иванов <firstdismay(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: pg_restore depending on user functions
Date: 2021-11-14 10:10:32
Message-ID: CAPL5KHoGa3uvyKp6z6m48LwCnTsK+LRQ_mcA4uKGfqAVSEjV_A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-general

Good day!
Deploying a cluster: from PostgreSQL 12 Windows 10 (EDB) to PostgreSQL 14
Debian 11.
In general, I succeeded, but there are a number of questions:
1. I can determine the dependencies of the custom functions when creating
the pg_dump? I did not find anything suitable for SUPPORT, probably this is
not the case?
To recreate all of the functionality, I had to run schema recovery twice.
(--schema-only)
2. Why is pg_restore trying to set the value of fields of type GENERATED
ALWAYS?
COPY mode also does not work with INSERT. I had to do a COPY by manually
deleting the fields type GENERATED ALWAYS
Can this behavior be influenced?

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2021-11-14 17:31:09 Re: pg_restore depending on user functions
Previous Message Thomas Munro 2021-11-14 01:24:54 Re: conchuela timeouts since 2021-10-09 system upgrade

Browse pgsql-general by date

  From Date Subject
Next Message Avi Weinberg 2021-11-14 14:14:47 Logical Replication - Source and Destination Table Name Not The Same
Previous Message yarden tamam 2021-11-13 09:13:25 help with a query