Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mnjP1-0002kd-Bs for pgsql-bugs@arkaria.postgresql.org; Thu, 18 Nov 2021 15:32:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mnjOz-0001iI-Kv for pgsql-bugs@arkaria.postgresql.org; Thu, 18 Nov 2021 15:32:41 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mnjOz-0001eE-CI for pgsql-bugs@lists.postgresql.org; Thu, 18 Nov 2021 15:32:41 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mnjOx-0007BU-1B for pgsql-bugs@lists.postgresql.org; Thu, 18 Nov 2021 15:32:40 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 1AIFWaOi2915503; Thu, 18 Nov 2021 10:32:37 -0500 From: Tom Lane To: =?UTF-8?B?0JTQvNC40YLRgNC40Lkg0JjQstCw0L3QvtCy?= cc: pgsql-bugs@lists.postgresql.org Subject: Re: pg_restore depending on user functions In-reply-to: References: <2011525.1636911069@sss.pgh.pa.us> <2016240.1636915579@sss.pgh.pa.us> <2048100.1636934771@sss.pgh.pa.us> <2124696.1636991365@sss.pgh.pa.us> <2157331.1637014065@sss.pgh.pa.us> <2230909.1637080154@sss.pgh.pa.us> <2254203.1637093046@sss.pgh.pa.us> <2361578.1637113664@sss.pgh.pa.us> Comments: In-reply-to =?UTF-8?B?0JTQvNC40YLRgNC40Lkg0JjQstCw0L3QvtCy?= message dated "Thu, 18 Nov 2021 12:33:40 +0500" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <2915501.1637249556.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Thu, 18 Nov 2021 10:32:36 -0500 Message-ID: <2915502.1637249556@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk =3D?UTF-8?B?0JTQvNC40YLRgNC40Lkg0JjQstCw0L3QvtCy?=3D writes: > I only made a bpd schema, so I added an artificial cast, but in fact thi= s > 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.c= doc_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.co= bject_ prop psql:bpd_tl3.sql:5388: ERROR: function bpd.cfg_procargs(oid) does not exi= st psql:bpd_tl3.sql:5654: ERROR: function bpd.cfg_tblcol2(oid) does not exis= t 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(bi= gint) = 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