Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 792537 - dev-db/postgresql-13.3 - plperl functions broken with dev-lang/perl-5.32.1
Summary: dev-db/postgresql-13.3 - plperl functions broken with dev-lang/perl-5.32.1
Status: UNCONFIRMED
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: Current packages (show other bugs)
Hardware: All Linux
: Normal normal with 1 vote (vote)
Assignee: PgSQL Bugs
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-05-27 18:39 UTC by Chris Mayo
Modified: 2023-12-15 01:28 UTC (History)
3 users (show)

See Also:
Package list:
Runtime testing required: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Chris Mayo 2021-05-27 18:39:47 UTC
Fix introduced in [1]:
plperl.on_init = 'use utf8; use re; package utf8; require "utf8_heavy.pl";'

now causes plperl functions to fail with:
ERROR:  attempt to redefine parameter "plperl.use_strict" 

which is an unhelpful error message indicating a missing module [2].
utf8_heavy.pl has been dropped by Perl [3].

Original example code from [1] now runs fine for me without defining plperl.on_init.

[1] https://bugs.gentoo.org/518522
[2] https://www.postgresql.org/message-id/E1U66cu-0004dL-Qg@wrigleys.postgresql.org
[3] https://github.com/Perl/perl5/commit/483a80b4eb1ce75c33945f69455138be14944460
Comment 1 Chris Wood 2023-12-15 01:28:11 UTC
When migrating from 15 to 16 this default config setting causes the process to fail if any database makes use of plperl or plperlu with the following error:
could not load library "$libdir/plperl": ERROR:  
CONTEXT:  while running Perl initialization

updating the config to the below prevents the issue.
plperl.on_init = 'use utf8; use re; package utf8;'

However I do not know what the impact of this change is and if Unicode::UCD should replace utf8_heavy.pl.