Re: undefined symbol: SPI_plan_get_cached_plan

Roger Niederland <roger@niederland.com> writes:
> I am getting the following error when trying to execute a plpgsql funtion:

> PSTERROR:  could not load library "/usr/pgsql-9.2/lib/plpgsql.so":
> /usr/pgsql-9.2/lib/plpgsql.so: undefined symbol: SPI_plan_get_cached_plan

> This is on a SL6.3 system running postgres 9.2.2

SPI_plan_get_cached_plan was added to the backend in 9.2.3.  It looks
like you're trying to use a 9.2.3 plpgsql.so with a 9.2.2 (or older)
server.

> After restarting the postgres service, the error went away.

So you had upgraded, but not actually restarted the server ...
just for future reference, SLES apparently doesn't do a service
restart automatically during package upgrade.

            regards, tom lane