public inbox for [email protected]  
help / color / mirror / Atom feed
BUG #19419: Cannot create custom functions using python3u
2+ messages / 2 participants
[nested] [flat]

* BUG #19419: Cannot create custom functions using python3u
@ 2026-02-26 15:54  PG Bug reporting form <[email protected]>
  0 siblings, 1 reply; 2+ messages in thread

From: PG Bug reporting form @ 2026-02-26 15:54 UTC (permalink / raw)
  To: [email protected]; +Cc: [email protected]

The following bug has been logged on the website:

Bug reference:      19419
Logged by:          yafei wu
Email address:      [email protected]
PostgreSQL version: 18.2
Operating system:   windows
Description:        

When I was installing the Windows version of PostgreSQL 18.2.1, I executed
the command "CREATE EXTENSION plpython3u;". Error message
[2026-02-26 23:35:02] [58P01] Error: Unable to load library
"D:/postgresql/PostgreSQL/18/lib/plpython3.dll": The specified module could
not be found.
[2026-02-26 23:35:02] At location: SQL statement "CREATE FUNCTION
plpython3_call_handler() RETURNS language_handler" [2026-02-26 23:35:02]
LANGUAGE c AS '$libdir/plpython3'"
[2026-02-26 23:35:02] Extension script file "plpython3u--1.0.sql", near line
3
When I placed the python313.dll file in the installation directory of Python
3.13 under the C:\Windows\System32 directory, and executed the command
"CREATE EXTENSION plpython3u;" Success, but when creating the Python custom
function, an error occurred.
[2026-02-26 23:45:01] An I/O error occurred while sending to the backend.
[2026-02-26 23:45:01] Received an irrecoverable error. The connection has
been damaged.








^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: BUG #19419: Cannot create custom functions using python3u
@ 2026-02-27 07:44  yafei wu <[email protected]>
  parent: PG Bug reporting form <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: yafei wu @ 2026-02-27 07:44 UTC (permalink / raw)
  To: [email protected]; [email protected]

The problem has been resolved. The issue was related to the environment.
The PostgreSQL user did not have sufficient permissions to access the
installation directory of Python.

PG Bug reporting form <[email protected]> 于2026年2月26日周四 23:55写道:

> The following bug has been logged on the website:
>
> Bug reference:      19419
> Logged by:          yafei wu
> Email address:      [email protected]
> PostgreSQL version: 18.2
> Operating system:   windows
> Description:
>
> When I was installing the Windows version of PostgreSQL 18.2.1, I executed
> the command "CREATE EXTENSION plpython3u;". Error message
> [2026-02-26 23:35:02] [58P01] Error: Unable to load library
> "D:/postgresql/PostgreSQL/18/lib/plpython3.dll": The specified module could
> not be found.
> [2026-02-26 23:35:02] At location: SQL statement "CREATE FUNCTION
> plpython3_call_handler() RETURNS language_handler" [2026-02-26 23:35:02]
> LANGUAGE c AS '$libdir/plpython3'"
> [2026-02-26 23:35:02] Extension script file "plpython3u--1.0.sql", near
> line
> 3
> When I placed the python313.dll file in the installation directory of
> Python
> 3.13 under the C:\Windows\System32 directory, and executed the command
> "CREATE EXTENSION plpython3u;" Success, but when creating the Python custom
> function, an error occurred.
> [2026-02-26 23:45:01] An I/O error occurred while sending to the backend.
> [2026-02-26 23:45:01] Received an irrecoverable error. The connection has
> been damaged.
>
>
>


^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2026-02-27 07:44 UTC | newest]

Thread overview: 2+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2026-02-26 15:54 BUG #19419: Cannot create custom functions using python3u PG Bug reporting form <[email protected]>
2026-02-27 07:44 ` yafei wu <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox