Thread: ERROR: dynamic load not supported

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'
LANGUAGEC;
 

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

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

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