Thread: BUG #9349: plpgsql.so: undefined symbol: CheckFunctionValidatorAccess

The following bug has been logged on the website:

Bug reference:      9349
Logged by:          John Hord
Email address:      john.k.hord@nasa.gov
PostgreSQL version: 9.2.7
Operating system:   RedHat LINUX v5.x
Description:

It appears that the CheckFunctionValidatorAccess function is now being used
in plpgsql.so but the fmgr.o object which defines the function is not being
linked when plpgsql.so is compiled.

john.k.hord@nasa.gov writes:
> It appears that the CheckFunctionValidatorAccess function is now being used
> in plpgsql.so but the fmgr.o object which defines the function is not being
> linked when plpgsql.so is compiled.

If you upgraded to 9.2.7 but failed to restart the server, you will get
link errors like that when new sessions (still running the old server
executable) attempt to load the updated version of plpgsql.so.

            regards, tom lane