| 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: | Whole Thread | Raw Message | 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?
| 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 |
| 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 |