pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Дмитрий Иванов <firstdismay@gmail.com>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: pg_restore depending on user functions
Date: Thu, 18 Nov 2021 10:32:36 -0500
Message-ID: <2915502.1637249556@sss.pgh.pa.us> (raw)
In-Reply-To: <CAPL5KHp-R6JV_NRLbyxLQe_7sq9oyS+vcEP83bRvSjJLqfo2Uw@mail.gmail.com>
References: <CAPL5KHoGa3uvyKp6z6m48LwCnTsK+LRQ_mcA4uKGfqAVSEjV_A@mail.gmail.com>
	<2011525.1636911069@sss.pgh.pa.us>
	<CAPL5KHrkVKVp22XE4S0ByA94-3OvH+9HC19WFFMePK2_c1VF0g@mail.gmail.com>
	<2016240.1636915579@sss.pgh.pa.us>
	<CAPL5KHoiNP8Z4Jq=EP0WBKr+07bfwk4sdH9k-+RQSJvYFVsC1A@mail.gmail.com>
	<2048100.1636934771@sss.pgh.pa.us>
	<CAPL5KHpN=pz97X+7vThsSn1V0ag8dSBrhMxjpWr1Z=wwU2BPow@mail.gmail.com>
	<2124696.1636991365@sss.pgh.pa.us>
	<CAPL5KHo46S6kRRiaTfNdm63eR3u72gcnS9zMa2DYOjqZyPrFsw@mail.gmail.com>
	<2157331.1637014065@sss.pgh.pa.us>
	<CAPL5KHpT4rZyt0U4tVCbMOxhsaTbYNY9b5XGr-cQnHGz1mPOzA@mail.gmail.com>
	<2230909.1637080154@sss.pgh.pa.us>
	<CAPL5KHouYG+Bi4DWYdzixUwJuL6HK9uruW5JKqU+1CJfB39G0Q@mail.gmail.com>
	<2254203.1637093046@sss.pgh.pa.us>
	<CAPL5KHpnvkoch1ViCKWmPoNcSQM3j671ohGwtwRWOrOWwGMVPA@mail.gmail.com>
	<2361578.1637113664@sss.pgh.pa.us>
	<CAPL5KHp-R6JV_NRLbyxLQe_7sq9oyS+vcEP83bRvSjJLqfo2Uw@mail.gmail.com>

=?UTF-8?B?0JTQvNC40YLRgNC40Lkg0JjQstCw0L3QvtCy?= <firstdismay@gmail.com> writes:
> 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);

I'm only going to say this one more time, because I'm getting really
tired of looping around on this: please send a file that you have
tested to be loadable.  This one is missing at least three casts
and several functions:

psql:bpd_tl3.sql:2274: ERROR:  cannot cast type bpd.vdoc_category to bpd.cdoc_ca
tegory
psql:bpd_tl3.sql:2287: ERROR:  cannot cast type bpd.vdoc_file to bpd.cdoc_file
psql:bpd_tl3.sql:3110: ERROR:  cannot cast type bpd.vobject_prop to bpd.cobject_
prop
psql:bpd_tl3.sql:5388: ERROR:  function bpd.cfg_procargs(oid) does not exist
psql:bpd_tl3.sql:5654: ERROR:  function bpd.cfg_tblcol2(oid) does not exist
psql:bpd_tl3.sql:6189: ERROR:  function bpd.int_cast_vclass_prop_to_cclass_prop(
bpd.vclass_prop_snapshot) does not exist
psql:bpd_tl3.sql:9815: ERROR:  function bpd.int_class_name_format_check(bigint) 
does not exist

I might've missed some in the cascade of follow-on errors, but those
objects are certainly not defined in this script.

			regards, tom lane





view thread (27+ messages)  latest in thread

Message-ID: <2915502.1637249556@sss.pgh.pa.us>
Permalink:  ../2915502.1637249556@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/2915502.1637249556@sss.pgh.pa.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: tgl@sss.pgh.pa.us, firstdismay@gmail.com, pgsql-bugs@lists.postgresql.org
  Subject: Re: pg_restore depending on user functions
  In-Reply-To: <2915502.1637249556@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox