pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedERROR: dynamic load not supported
4+ messages / 3 participants
[nested] [flat]
* ERROR: dynamic load not supported
@ 2003-09-17 14:55 Rich Cullingford <rculling@sysd.com>
2003-09-17 16:04 ` Re: ERROR: dynamic load not supported Tom Lane <tgl@sss.pgh.pa.us>
2003-09-17 19:31 ` Re: ERROR: dynamic load not supported Robert Treat <xzilla@users.sourceforge.net>
0 siblings, 2 replies; 4+ messages in thread
From: Rich Cullingford @ 2003-09-17 14:55 UTC (permalink / raw)
To: pgsql-interfaces
All,
This is with a new 7.3.4 installation. Every CREATE FUNCTION call I
make, e.g.,
CREATE FUNCTION plpgsql_call_handler () RETURNS LANGUAGE_HANDLER AS
'<absolute-path-to-pg-install>/lib/plpgsql' LANGUAGE C;
fails with this error. I know the specification of absolute paths for
the library lookup is deprecated, but it's supposed to still work, and,
as of last week, did. "I haven't changed anything." :) (But doubtless
have done something stupid.)
Thanks for any advice.
Rich Cullingford
rculling@sysd.com
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: ERROR: dynamic load not supported
2003-09-17 14:55 ERROR: dynamic load not supported Rich Cullingford <rculling@sysd.com>
@ 2003-09-17 16:04 ` Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 4+ messages in thread
From: Tom Lane @ 2003-09-17 16:04 UTC (permalink / raw)
To: Rich Cullingford <rculling@sysd.com>; +Cc: pgsql-interfaces
Rich Cullingford <rculling@sysd.com> writes:
> This is with a new 7.3.4 installation.
On what platform? What PG version were you using when it worked before?
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: ERROR: dynamic load not supported
2003-09-17 14:55 ERROR: dynamic load not supported Rich Cullingford <rculling@sysd.com>
@ 2003-09-17 19:31 ` Robert Treat <xzilla@users.sourceforge.net>
1 sibling, 0 replies; 4+ messages in thread
From: Robert Treat @ 2003-09-17 19:31 UTC (permalink / raw)
To: Rich Cullingford <rculling@sysd.com>; +Cc: pgsql-interfaces
I had a similar problem with some pgcrypto functions until i specified
the specific .so file.
Robert Treat
On Wed, 2003-09-17 at 10:55, Rich Cullingford wrote:
> All,
> This is with a new 7.3.4 installation. Every CREATE FUNCTION call I
> make, e.g.,
>
> CREATE FUNCTION plpgsql_call_handler () RETURNS LANGUAGE_HANDLER AS
> '<absolute-path-to-pg-install>/lib/plpgsql' LANGUAGE C;
>
> fails with this error. I know the specification of absolute paths for
> the library lookup is deprecated, but it's supposed to still work, and,
> as of last week, did. "I haven't changed anything." :) (But doubtless
> have done something stupid.)
>
> Thanks for any advice.
> Rich Cullingford
> rculling@sysd.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
^ permalink raw reply [nested|flat] 4+ messages in thread
* Fwd: Re: ERROR: dynamic load not supported
@ 2003-09-18 13:09 Robert Treat <xzilla@users.sourceforge.net>
0 siblings, 0 replies; 4+ messages in thread
From: Robert Treat @ 2003-09-18 13:09 UTC (permalink / raw)
To: pgsql-interfaces
for future reference
---------- Forwarded Message ----------
Subject: Re: [INTERFACES] ERROR: dynamic load not supported
Date: Wednesday 17 September 2003 15:40
From: Rich Cullingford <rculling@sysd.com>
To: Robert Treat <xzilla@users.sourceforge.net>
Robert Treat wrote:
> I had a similar problem with some pgcrypto functions until i specified
> the specific .so file.
>
> Robert Treat
>
> On Wed, 2003-09-17 at 10:55, Rich Cullingford wrote:
>>All,
>>This is with a new 7.3.4 installation. Every CREATE FUNCTION call I
>>make, e.g.,
>>
>>CREATE FUNCTION plpgsql_call_handler () RETURNS LANGUAGE_HANDLER AS
>> '<absolute-path-to-pg-install>/lib/plpgsql' LANGUAGE C;
>>
>>fails with this error. I know the specification of absolute paths for
>>the library lookup is deprecated, but it's supposed to still work, and,
>>as of last week, did. "I haven't changed anything." :) (But doubtless
>>have done something stupid.)
Robert,
Thanks for replying!
This turned out to be a nasty incompatibility between the way libtool &
autoconf function in GNU and PG. Here's the note that describes the
problem (attached to the RT ticket that records it):
*******
If you configure a shared config.cache for multiple packages, be aware that
Postgres's use of autoconf variables is incompatible with the way they are
used in packages that use libtool.
Specifically, Postgres uses
AC_CHECK_LIB(dl, main)
...
AC_CHECK_FUNCS([cbrt ... dlopen fdatasync])
which adds -ldl to LIBS (if libdl exists) and then searches for the dlopen
function in the current set of LIBS; on systems with dlopen in libdl, this
sets the cache variable $ac_cv_func_dlopen = "yes". If a cached "no" value
is seen, Postgres (maybe incorrectly) believes that dlopen is not
available.
Libtool-based programs, on the other hand, set $ac_cv_func_dlopen = "no"
if dlopen is not present in libc, and use another mechanism to determine if
dlopen is available in libdl instead. If a cached "yes" value is seen,
libtool (maybe incorrectly) believes that -ldl need not be added to LIBS.
Workaround for this is to use separate configure caches for Postgres and
other (libtool-based) programs. You can copy the caches as long as you
filter
out the ac_cv_func_dlopen line using something like:
sed /ac_cv_func_dlopen/d < ../config.cache > config.cache
*****
Watch out if you try to package PG with GNU utilities!
Rich Cullingford
rculling@sysd.com
-------------------------------------------------------
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2003-09-18 13:09 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-09-17 14:55 ERROR: dynamic load not supported Rich Cullingford <rculling@sysd.com>
2003-09-17 16:04 ` Tom Lane <tgl@sss.pgh.pa.us>
2003-09-17 19:31 ` Robert Treat <xzilla@users.sourceforge.net>
2003-09-18 13:09 Fwd: Re: ERROR: dynamic load not supported Robert Treat <xzilla@users.sourceforge.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox