Re: pg_restore depending on user functions

From: Дмитрий Иванов <firstdismay(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: pg_restore depending on user functions
Date: 2021-11-18 07:33:40
Message-ID: CAPL5KHp-R6JV_NRLbyxLQe_7sq9oyS+vcEP83bRvSjJLqfo2Uw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-general

Выполнено.
I only made a bpd schema, so I added an artificial cast, but in fact this
is almost the end of the general base script:
CREATE CAST (bpd.vclass_prop AS bpd.cclass_prop) WITH FUNCTION
bpd.int_cast_vclass_prop_to_cclass_prop(bpd.vclass_prop);
PS:
Thanks to your instructions, I now know how, in principle, to manually
correct the script. But I would like it to be operational right away.
Thanks.

ср, 17 нояб. 2021 г. в 06:47, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:

> =?UTF-8?B?0JTQvNC40YLRgNC40Lkg0JjQstCw0L3QvtCy?= <firstdismay(at)gmail(dot)com>
> writes:
> > Am I correct in understanding that I need to dump --schema-only in SQL
> > format and then delete everything, leaving one chain for example? If so,
> it
> > will have to be postponed until the weekend.
>
> I don't care how you make the file exactly. But please confirm that
> it can be re-loaded and then will reproduce the problem.
>
> regards, tom lane
>

Attachment Content-Type Size
bpd_tl3.zip application/x-zip-compressed 43.7 KB

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2021-11-18 07:40:23 Re: BUG #17288: PSQL bug with COPY command (Windows)
Previous Message Kyotaro Horiguchi 2021-11-18 07:19:45 Re: BUG #17280: global-buffer-overflow on select from pg_stat_slru

Browse pgsql-general by date

  From Date Subject
Next Message Abdul Mohammed 2021-11-18 11:24:08 Execute command in PL/pgSQL function not executing
Previous Message Prathima Mulpuri 2021-11-18 04:30:03 Re: Account privileges