Thread: PG_exception_stack

Didn't find a solution for this on the lists, and I am not a yet-brand-new-guru, so... I ask :)

What about this?

I've found a box (dual  Intel(R) Xeon(TM) CPU 2.80GHz) in which to test  the beta2. Trying to cretae proc languages I
foundthis error. I've seen error creating languages on other boxes, but none of them like this one. What makes me a
litlebit lazy is the PG_except... msg.
 

I am trying to do something nasty or just watching something not usual? I've found recent posts related to the BKI and
talkingabout the PG_exception_stack, but none of them seem to handle the createlang situation.
 

Any hints?

[postgres@prdpwgb0208 postgres]$ createlang plpgsql tech_mis
createlang: language installation failed: ERROR:  could not load library "/usr/local/pgsql/lib/plpgsql.so":
/usr/local/pgsql/lib/plpgsql.so:undefined symbol: PG_exception_stack
 
[postgres@prdpwgb0208 postgres]$ pg_config --configure
'--enable-thread-safety' '--with-perl' '--without-docdir'
[postgres@prdpwgb0208 postgres]$ pg_config --version
PostgreSQL 8.0.0beta2
[postgres@prdpwgb0208 postgres]$ cd /usr/local/pgsql/lib/
[postgres@prdpwgb0208 lib]$ ls -ltrh plpgsql.so
-rwxr-xr-x    1 root     root         123k Sep 15 15:41 plpgsql.so
[postgres@prdpwgb0208 lib]$uname -a
Linux prdpwgb0208 2.4.22ow1np-ht #8 SMP Mon Oct 13 19:54:55 GMT 2003 i686 unknown

Regards,
Guido

On Wed, 2004-09-15 at 09:04, G u i d o B a r o s i o wrote:
> [postgres@prdpwgb0208 postgres]$ createlang plpgsql tech_mis
> createlang: language installation failed: ERROR:  could not load
> library "/usr/local/pgsql/lib/plpgsql.so":
> /usr/local/pgsql/lib/plpgsql.so: undefined symbol: PG_exception_stack

It looks like your build is a bit fubar'd. I don't know why exactly, but
it can't find that symbol, so I'd suggest a gmake distclean, configure,
and gmake all install. (hrm, might also want to make sure that your
installations arent crossing paths somewhere here, if you have multiple
versions installed)
(Note that I just did it with my dev build without trouble)

--
Regards,       James William Pye

G u i d o B a r o s i o <gbarosio@uolsinectis.com.ar> writes:
> [postgres@prdpwgb0208 postgres]$ createlang plpgsql tech_mis
> createlang: language installation failed: ERROR:  could not load library "/usr/local/pgsql/lib/plpgsql.so":
/usr/local/pgsql/lib/plpgsql.so:undefined symbol: PG_exception_stack
 

I think you've got a version mismatch problem --- specifically, it looks
like you are trying to load an 8.0 plpgsql.so into a pre-8.0 backend.
PG_exception_stack is (just by chance no doubt) the first symbol the
newer code tries to reference that's not in the older backend.
        regards, tom lane