Skip site navigation (1) Skip section navigation (2)

Re: Query on support for trigger functions defined in a Shared library in Windows

From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: "Mehul Doshi-A20614" <mehul(at)motorola(dot)com>,<pgsql-hackers-win32(at)postgresql(dot)org>
Subject: Re: Query on support for trigger functions defined in a Shared library in Windows
Date: 2006-01-27 08:31:59
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCE6C7F64@algol.sollentuna.se (view raw or flat)
Thread:
Lists: pgsql-hackers-win32
> On Windows for the same I get: (Includes extra \ to account 
> for Windows)
> 
> test=# CREATE OR REPLACE FUNCTION trigf_test_pid_insert() 
> RETURNS trigger
> test-#   AS 'C:\\Program Files\\Test\\lib\\testtrigfuncs.dll'
> test-#   LANGUAGE C ;
> ERROR:  could not load library "C:\Program
> Files\Test\lib\testtrigfuncs.dll": The specified module could 
> not be found.
> 
> I went and modified the dynamic_library_path to 
> dynamic_library_path = 'C:\Program Files\Test\lib;$libdir'
> 
> I also added C:\Program Files\Test\lib to the PATH variable. 
> I restarted postgres service and then retried the below.

Are you sure you added this to the SYSTEM path and not the USER path?
Because if it's the second, it won't affect the pg service. I'd also try
a reboot after changing the one in SYSTEM - I've seen cases where it
didn't "take" even if the service was restarted.

//Magnus

pgsql-hackers-win32 by date

Next:From: Reini UrbanDate: 2006-01-27 10:00:51
Subject: Re: Query on support for trigger functions defined in a Shared library in Windows
Previous:From: Mehul Doshi-A20614Date: 2006-01-24 21:21:24
Subject: Re: Query on support for trigger functions defined in a Shared library in Windows

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group