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.
Дмитрий Иванов <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.
От:
Masahiko Sawada Дата: Сообщение:
Re: References to parameters by name are lost in INSERT INTO ... SELECT .... statements in case of routines with the SQL-standard function body