FS#64618 - postgresql 12.1: creation of PL/pgSQL functions fails
Attached to Project:
Arch Linux
Opened by Andrius (andrius4669) - Friday, 22 November 2019, 23:53 GMT
Last edited by Levente Polyak (anthraxx) - Saturday, 23 November 2019, 13:32 GMT
Opened by Andrius (andrius4669) - Friday, 22 November 2019, 23:53 GMT
Last edited by Levente Polyak (anthraxx) - Saturday, 23 November 2019, 13:32 GMT
|
Details
Description:
Creating new function with PL/pgSQL language fails with: ERROR: could not load library "/usr/lib/postgresql/plpgsql.so": /usr/lib/postgresql/plpgsql.so: undefined symbol: pg_printf Additional info: * package version(s) postgresql 12.1-1 postgresql-libs 12.1-1 Steps to reproduce: $ psql -U postgres postgres=# CREATE FUNCTION testf1() RETURNS VOID AS $$ $$ LANGUAGE sql; CREATE FUNCTION postgres=# CREATE FUNCTION testf2() RETURNS VOID AS $$ BEGIN RETURN NULL; END; $$ LANGUAGE plpgsql; ERROR: could not load library "/usr/lib/postgresql/plpgsql.so": /usr/lib/postgresql/plpgsql.so: undefined symbol: pg_printf |
This task depends upon
Closed by Levente Polyak (anthraxx)
Saturday, 23 November 2019, 13:32 GMT
Reason for closing: Not a bug
Saturday, 23 November 2019, 13:32 GMT
Reason for closing: Not a bug
after proper migration and restart it works properly.