2013/2/11 Roger Niederland :
>
> On 2/11/2013 6:47 AM, Tom Lane wrote:
>>
>> Roger Niederland 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: und
On 2/11/2013 6:47 AM, Tom Lane wrote:
Roger Niederland 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 SL
Hi,
On Mon, 2013-02-11 at 09:47 -0500, Tom Lane wrote:
> > 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 upgra
Roger Niederland 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
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
We set this server up about
