Bug#928942: Bug #928942: udd: cannot import database dump into PostgreSQL ("function release_name(text) does not exist")

[Leandro Doctors <ldoctors@gmail.com>]

On Tue, 14 May 2019 at 19:01, Mattia Rizzolo <mattia@debian.org> wrote:
> TTBOMK, the schema Is just handled pseudo-manually, so any change would need to be applied directly.
>
> I'm not even sure if the schema dump in git is current anymore (being 7 months old).

Then, probably the best course of action would be to delete it from
the repo and make it so it gets generated automatically along every
dump?


> Also, thank you for the analysis, and the upcoming patch! :)

Don't thank me so much yet: I only came up with an idea. I still have
to make it work :-)

I think that, for now, I will simply try to make the dump
forward-compatible with newer versions of PostgreSQL, and the schema
to be generated automatically along every dump.

(After having quickly read the PostgreSQL 10 release notes, it seems
that the solution involves using 'pg_dumpall' instead of 'pg_dump' - I
will have to explore this...)

I will let you know once I progress on this.

Best,
Leandro