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 found this error. I've seen error creating languages on other boxes, but none of them like this one. What makes me a litle bit 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 talking about 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

Wed, 15 Sep 2004 13:04:37 -0300 (GMT+3)
G u i d o B a r o s i o <gbarosio@uolsinectis.com.ar>
PG_exception_stack
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
Wed, 15 Sep 2004 09:30:07 -0700
James William Pye <flaw@rhid.com>
Re: PG_exception_stack
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

Wed, 15 Sep 2004 12:38:59 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: PG_exception_stack 