Обсуждение: error since upgrading to 9.3.3 plpgsql

Greetings,

Since upgrading to 9.3.3 on Arch Linux, I have been receiving an error
whenattempting to execute or recreate plpgsql functions in mydatabase.

I'm not clear if this is an error with the compilation by the Arch
package manager or an error with Postgres, or some problem with my
database permissions/configuration/plpgsql extension that has not been
brought into focus until now.

When attempting to execute or create I receive:

ERROR: could not load library "/usr/lib/postgresql/plpgsql.so":
/usr/lib/postgresql/plpgsql.so: undefined symbol:
CheckFunctionValidatorAccess
SQL state: 58P01

The does exist in my filesystem.

Thanks, Greg

Gregory Gincley <rollenwiese@fastmail.net> writes:
> Since upgrading to 9.3.3 on Arch Linux, I have been receiving an error
> whenattempting to execute or recreate plpgsql functions in mydatabase.

> ERROR: could not load library "/usr/lib/postgresql/plpgsql.so":
> /usr/lib/postgresql/plpgsql.so: undefined symbol:
> CheckFunctionValidatorAccess
> SQL state: 58P01

You didn't actually restart the server, so you're still running 9.3.2
server, with which 9.3.3 plpgsql.so will not work.

            regards, tom lane