Re: pg_restore depending on user functions - Mailing list pgsql-bugs

From Tom Lane
Subject Re: pg_restore depending on user functions
Date
Msg-id 2254203.1637093046@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_restore depending on user functions  (Дмитрий Иванов <firstdismay@gmail.com>)
Responses Re: pg_restore depending on user functions
List pgsql-bugs
=?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



pgsql-bugs by date:

Previous
From: Дмитрий Иванов
Date:
Subject: Re: pg_restore depending on user functions
Next
From: Tom Lane
Date:
Subject: Re: References to parameters by name are lost in INSERT INTO ... SELECT .... statements in case of routines with the SQL-standard function body