Roger Niederland <roger@xxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
