[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Re: Bootstrapping fails trying determine data type on Postgresql 14
From: |
Karsten Hilbert |
Subject: |
Re: Re: Bootstrapping fails trying determine data type on Postgresql 14 |
Date: |
Sun, 8 Jan 2023 23:26:09 +0100 |
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
Re: Re: Bootstrapping fails trying determine data type on Postgresql 14, lennart . reuther, 2023/01/10