Description of problem: undefined symbol in plpgsql.so Version-Release number of selected component (if applicable): How reproducible: always Steps to Reproduce: 1. use psql 2. try to use plpgsql as follows... test=# do $$ test$# select * from file limit 2; test$# end; $$; ERROR: could not load library "/usr/lib64/postgresql/plpgsql.so": /usr/lib64/postgresql/plpgsql.so: undefined symbol: SPI_execute_extended where "file" is a table in database "test". "select * from file limit 2;" doesn't need to be inside a plpgsql block; but it's the simplest example to illustrate the issue.
Thank you for the report. Please say which version of Postgresql you are using: 13 or 15.
Source RPM: (none) => postgresql15-plpgsql, postgresql13-plpgsqlCC: (none) => lewyssmith
Sorry. 15... it was part of the recent update -- I update Cauldron daily if there's anything; though kernel/glibc reboots are scheduled.
Thanks. Assigning accordingly to NicolasS for postgresql15.
Assignee: bugsquad => nicolas.salgueroCC: lewyssmith => (none)Source RPM: postgresql15-plpgsql, postgresql13-plpgsql => postgresql15-plpgsql
See Also: (none) => https://bugs.mageia.org/show_bug.cgi?id=31354
Hi, As that bug has the same cause as bug 31354, I close it. Best regards, Nico.
Resolution: (none) => INVALIDStatus: NEW => RESOLVED