From: Tom Lane <tgl@sss.pgh.pa.us>
To: Marcus Müller <m.mueller@schwarz-infosysteme.de>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: pg_upgrade from PostgreSQL 12.4 to PostgreSQL 13.2 on Windows 10 failes because of missing function pg_catalog.ascii_to_mic
Date: Wed, 10 Mar 2021 10:16:00 -0500
Message-ID: <2088847.1615389360@sss.pgh.pa.us> (raw)
In-Reply-To: <001101d7159a$91f9c0d0$b5ed4270$@schwarz-infosysteme.de>
References: <001101d7159a$91f9c0d0$b5ed4270$@schwarz-infosysteme.de>
=?iso-8859-1?Q?Marcus_M=FCller?= <m.mueller@schwarz-infosysteme.de> writes:
> pg_upgrade should actually correctly handle features that no longer exist in
> a new version. This seems like a bug.
> 2021-03-10 10:37:07.199 CET [18868] FEHLER: Funktion
> pg_catalog.ascii_to_mic(integer, integer, cstring, internal, integer)
> existiert nicht
> 2021-03-10 10:37:07.199 CET [18868] ANWEISUNG: GRANT ALL ON FUNCTION
> "pg_catalog"."ascii_to_mic"(integer, integer, "cstring", "internal",
> integer) TO "wwsuser";
Yeah, that's a known issue, but fixing it is harder than you might think
--- people have been poking at a fix for some time without success.
There's no good place to locate knowledge about things having gone
away.
Since I can see no actual reason to grant nondefault permissions on an
encoding conversion function, I'd suggest just revoking those in the
source DB before upgrading.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, m.mueller@schwarz-infosysteme.de, pgsql-bugs@lists.postgresql.org
Subject: Re: pg_upgrade from PostgreSQL 12.4 to PostgreSQL 13.2 on Windows 10 failes because of missing function pg_catalog.ascii_to_mic
In-Reply-To: <2088847.1615389360@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox