createlang fails

I was able to get it to work by editing the createlang
script and adding the library path to the PGLIB var.
I'd tried setting PGLIB as an environment variable,
but that didn't work either.

--- CSN <cool_screen_name90001@yahoo.com> wrote:

createlang plpgsql template1

ERROR: stat failed on file '$libdir/plpgsql': No
such
file or directory
ERROR: stat failed on file '$libdir/plpgsql': No
such
file or directory
createlang: language installation failed

I compiled from source using prefix=/usr. plpgsql.so
is in /usr/lib/postgresql/. I did psql -c 'select
version()' and verified 7.3 is being used. Also
tried
setting 'dynamic_library_path' to
'/usr/lib/postgresql' path in postgres.conf. Any
help? Thanks.

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up
now.
http://mailplus.yahoo.com

---------------------------(end of
broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please
send an appropriate
subscribe-nomail command to majordomo@postgresql.org
so that your
message can get through to the mailing list cleanly

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

CSN wrote:

I was able to get it to work by editing the createlang
script and adding the library path to the PGLIB var.
I'd tried setting PGLIB as an environment variable,
but that didn't work either.

createlang plpgsql template1

ERROR: stat failed on file '$libdir/plpgsql': No
such
file or directory
ERROR: stat failed on file '$libdir/plpgsql': No
such
file or directory
createlang: language installation failed

I compiled from source using prefix=/usr. plpgsql.so
is in /usr/lib/postgresql/. I did psql -c 'select
version()' and verified 7.3 is being used. Also
tried
setting 'dynamic_library_path' to
'/usr/lib/postgresql' path in postgres.conf. Any
help? Thanks.

I don't think that you'll change the libraries location so
you can type the full path: /usr/lib/postgresql/... instead of $libdir/...