From: | GMX LINREG <linreg(at)gmx(dot)net> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Bruce Momjian <bruce(at)momjian(dot)us>, pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Re: BUG #16843: pg_upgrade from 12.5 to 13.1 with extension plperlu failed |
Date: | 2021-01-29 17:38:18 |
Message-ID: | 5448993.DvuYhMxLoT@wolfclan.ang.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Am Freitag, 29. Januar 2021, 18:29:34 CET schrieb Tom Lane:
> Looking at this more closely, it seems like there must be something broken
> about the plperlu extension in the source database. We see
>
> pg_restore: erstelle EXTENSION »plperlu«
> pg_restore: erstelle COMMENT »EXTENSION "plperlu"«
> pg_restore: erstelle PROCEDURAL LANGUAGE »plperlu«
> pg_restore: in Phase PROCESSING TOC:
> pg_restore: in Inhaltsverzeichniseintrag 2151; 2612 16427 PROCEDURAL
> LANGUAGE plperlu postgres pg_restore: Fehler: could not execute query:
> FEHLER: Sprache »plperlu« existiert nicht Die Anweisung war: CREATE OR
> REPLACE PROCEDURAL LANGUAGE "plperlu";
>
> but a binary-upgrade dump should have dumped the plperlu support functions
> before the procedural language object. And the CREATE PROCEDURAL LANGUAGE
> command should have included explicit HANDLER etc clauses. Both things
> could be explained by supposing that pg_dump didn't see the support
> functions as part of the extension, but why not?
>
> It might be interesting to check the results of "\dx+ plperlu" in the
> source database.
>
> regards, tom lane
Hello
output from source database:
botdb=# \dx+ plperlu
Objekte in Erweiterung »plperlu«
Objektbeschreibung
--------------------
language plperlu
thomas steffen
From | Date | Subject | |
---|---|---|---|
Next Message | Lucas Valardao | 2021-01-29 17:44:45 | Re: BUG #16844: Relation mapping file "global/pg_filenode.map" contains invalid data |
Previous Message | Tom Lane | 2021-01-29 17:29:34 | Re: BUG #16843: pg_upgrade from 12.5 to 13.1 with extension plperlu failed |