Обсуждение: PostgreSQL function can not load dll library.
Hi All,
I am creating a dll using MSVC 2005 and trying to call the dll from my Postgres function but unfortunately PostgreSQL is throwing an error message saying:
ERROR: could not load library "C:/Program Files/PostgreSQL/8.3/lib/watchlist.dll": The specified module could not be found.
SQL state: 58P01
However I have created the dll and exported the required function to make the dll the callable by PostgeSQL.
I am using PostgreSQL 8.3 and the dll have been created successfully without any compilation errors.
It would be nice if anyone can help me as I am stuck in this for almost a week.
Many thanks.
AB
On Tue, 2009-10-27 at 02:19 -0400, A.Bhattacharya@sungard.com wrote: > I am creating a dll using MSVC 2005 and trying to call the dll from my > Postgres function OK, so you're creating a PostgreSQL module implementing one or more SQL-callable functions in C. When you load it into the server with `CREATE FUNCTION' ? > but unfortunately PostgreSQL is throwing an error message saying: > > > > ERROR: could not load library "C:/Program > Files/PostgreSQL/8.3/lib/watchlist.dll": The specified module could > not be found. Assuming that the file is, in fact, on the path you've specified: Is it possible that your DLL links to other DLLs that are not on the PostgreSQL server's path? If your DLL links to another that cannot be found, that error message is the one you'll get. Dependency walker (depends.exe) from http://dependencywalker.com/ may help you track that down. -- Craig Ringer