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: Tue, 16 Nov 2021 15:04:06 -0500
Message-ID: <2254203.1637093046@sss.pgh.pa.us> (raw)
In-Reply-To: <CAPL5KHouYG+Bi4DWYdzixUwJuL6HK9uruW5JKqU+1CJfB39G0Q@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>

=?UTF-8?B?0JTQvNC40YLRgNC40Lkg0JjQstCw0L3QvtCy?= <firstdismay@gmail.com> writes:
> --Line 4048:
> CREATE TABLE bpd.class (

There are still a lot of problems in this example:

* references to nonexistent columns val_text, val_bytea, val_json

* int_class_ext refers to int_class_ready, int_class_path,
bpd.object, which weren't supplied

I figured maybe I didn't need int_class_ext, since it doesn't appear
to be referenced elsewhere.  But with the objects I have, pg_dump
doesn't do anything wrong; the output can be loaded just fine.

Please, send a self-contained SQL script that you have actually
tested to be loadable, and which produces a database that
causes pg_dump to do the wrong thing.

			regards, tom lane





view thread (27+ messages)  latest in thread

Message-ID: <2254203.1637093046@sss.pgh.pa.us>
Permalink:  ../2254203.1637093046@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/2254203.1637093046@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: <2254203.1637093046@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