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 06:20, Michael Banck <michael.banck@credativ.de> wrote:
> Am Montag, den 13.05.2019, 15:44 -0300 schrieb Leandro Doctors:

Hi, Michael!

Thanks for your detailed answer.

> > Package: qa.debian.org
> > Severity: grave
> > Justification: causes non-serious data loss>
> not sure whether that is warranted; a materialized view is by definition
> no new data that could be lost.

As I'm no DD, I wasn't sure about the severity level... That being
said, the fact is that this error renders impossible the full restore
of the dump...
If you can think of a more appropriate one, please feel free to change it :-)

[...]
> The problem is that the UDD schema does not schema-qualify functions
> when using them.
[...]
> The actual problem appears to be in the bugs_rt_affect_dist
> function that calls release_name($1) without schema-qualifiying it:
>
> https://salsa.debian.org/qa/udd/blob/master/sql/udd-schema.sql#L553

I'll give it a try and open a MR on salsa.d.o to solve this. (I guess
that changing the schema itself should be trivial. I will only have to
think a little bit about the migration process of the current DB.)

Thanks again, Michael!

Best,
Leandro