Hi
And could it be at pg_dump level ?
It seems more aware of what is doing...
Stephane
Le mer. 16 nov. 2022 à 15:42, Tom Lane <tgl@xxxxxxxxxxxxx> a écrit :
Guillaume Lelarge <guillaume@xxxxxxxxxxxx> writes:
> Le mer. 16 nov. 2022 à 13:08, Fabrice Chapuis <fabrice636861@xxxxxxxxx> a
> écrit :
>> I worked on the pg_dump source code to add remap schema functionality to
>> use it internally where I work. This is a first version that allows to
>> remap tables, views and sequences (only to export schema). Is this
>> development likely to interest the PG community and to continue this
>> development further?
> If it doesn't work on functions, that will be a big issue. And to be
> honest, I don't think you can do it reliably on functions, especially with
> dynamic queries in PL/pgsql.
Yeah --- I fear there is no hope of making a feature like this that
works reliably enough that we'd accept it. pg_restore is just not
that smart about what is in the chunks of DDL that it processes,
and trying to make it smart enough is a losing game.
regards, tom lane
"Où se posaient les hirondelles avant l'invention du téléphone ?"
-- Grégoire Lacroix
