Re: BUG #16843: pg_upgrade from 12.5 to 13.1 with extension plperlu failed - Mailing list pgsql-bugs

From GMX LINREG
Subject Re: BUG #16843: pg_upgrade from 12.5 to 13.1 with extension plperlu failed
Date
Msg-id 4340453.cEBGB3zze1@wolfclan.ang.de
Whole thread Raw
In response to Re: BUG #16843: pg_upgrade from 12.5 to 13.1 with extension plperlu failed  (Bruce Momjian <bruce@momjian.us>)
List pgsql-bugs

Hello, (third trial)

to clearify,

- plperl package is already installed (see below).

- command 'CREATE OR REPLACE PROCEDURAL LANGUAGE "plperlu";' doesn't create a

language object, but just an extension object (see below)

Output from failed database upgrade:

botdb=# \dL

                      Liste der Sprachen

 Name   | Eigentümer | Vertraut |         Beschreibung         

---------+------------+----------+------------------------------

plpgsql | postgres   | t        | PL/pgSQL procedural language

(1 Zeile)

botdb=# \dx

                        Liste der installierten Erweiterungen

    Name     | Version |   Schema   |                   Beschreibung                   

--------------+---------+------------

+--------------------------------------------------

hstore       | 1.5     | pg_catalog | data type for storing sets of (key,

value) pairs

pg_cron      | 4.0.4   | public     | Cron-like Job Scheduler for PostgreSQL

pg_http      | 1.4.1   | public     | A web service for PostgreSQL

pg_mqtt      | 1.1     | public     | A mqtt client daemon for PostgreSQL

pg_reporting | 1.1     | public     | A reporting extension for PostgreSQL

plperlu      | 1.0     | pg_catalog | PL/PerlU untrusted procedural language

plpgsql      | 1.0     | pg_catalog | PL/pgSQL procedural language

best regards

Thomas Steffen

Attachment

pgsql-bugs by date:

Previous
From: linreg@gmx.net
Date:
Subject: Re: BUG #16843: pg_upgrade from 12.5 to 13.1 with extension plperlu failed
Next
From: Tom Lane
Date:
Subject: Re: BUG #16843: pg_upgrade from 12.5 to 13.1 with extension plperlu failed