Re: Re: Bootstrapping fails trying determine data type on Postgresql 14

[Karsten Hilbert]

Am Sun, Jan 08, 2023 at 12:49:42PM +0100 schrieb lennart.reuther@gmail.com:

> >> Trying an install using postgres13 on a fresh debian 10 failed with a
> >> different error
>
> OS: Debian GNU/Linux 11 (bullseye)
> GnuMed-Server: 22.15-1
> Postgresql: 13+225
>
> Executing: /usr/sbin/gm-bootstrap_server
>
> Error during bootstrapping "clinical":
>
> 2023-01-08 06:10:08  ERROR     gm.bootstrapper  [140358500529984
> MainThread]  (/var/lib/gnumed/Gnumed/pycommon/gmPsql.py::run() #144):
> create function clin.f_announce_h_issue_mod() returns opaque as '
> declare
>       patient_id integer;
> begin
>       -- get patient ID
>       if TG_OP = ''DELETE'' then
>               patient_id := OLD.id_patient;
>       else
>               patient_id := NEW.id_patient;
>       end if;
>       execute ''notify "health_issue_change_db:'' || patient_id ||
> ''"'';
>       return NULL;
> end;
> ' language 'plpgsql'
> Traceback (most recent call last):
>   File "/var/lib/gnumed/Gnumed/pycommon/gmPsql.py", line 137, in run
>     curs.execute(curr_cmd)
>   File "/usr/lib/python3/dist-packages/psycopg2/extras.py", line 146,
> in execute
>     return super(DictCursor, self).execute(query, vars)
> psycopg2.errors.UndefinedObject: type "opaque" does not exist
> -----------------------

This has been fixed in database version 22.17.

There's about zero chance to get that in to Debian/Stable
(which is at v22.15).

Karsten
--
GPG  40BE 5B0E C98E 1713 AFA6  5BC0 3BEA AC80 7D4F C89B