| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Roger Niederland <roger(at)niederland(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: undefined symbol: SPI_plan_get_cached_plan |
| Date: | 2013-02-11 14:47:20 |
| Message-ID: | 19232.1360594040@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Roger Niederland <roger(at)niederland(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Devrim GÜNDÜZ | 2013-02-11 14:58:41 | Re: undefined symbol: SPI_plan_get_cached_plan |
| Previous Message | Alvaro Herrera | 2013-02-11 14:44:09 | Re: fascinating article on postgresql mailing lists |