Re: [BUGS] BUG #3983: pgxs files still missing in win32 install (8.3.1)

2008-04-14 Thread Magnus Hagander

Joe Conway wrote:

Magnus Hagander wrote:

In general, mingw built modules should load just fine in msvc built
postgres. AFAIK, that's how PostGIS does it for 8.3 (though I know Mark
is working on getting MSVC build support for them). Debugging may be a
bit harder (since they use different kinds of debug symbols - postgres
uses Windows style and mingw uses mingw style), but it should certainly
load.

What trouble exactly are you seeing?


Basically, "Procedure not found", even though it is there. Also note 
that the same R.dll is being used from the MinGW Postgres installation 
(where plr loads successfully) and the MSVC Postgres.


Could this be somethingl ike missing PGDLLIMPORT specifications in your 
addon module or something like that? Try checking the names of the 
functions that are actually exported using "depends" or a similar tool.




postgres=# load '$libdir/dblink';
LOAD
postgres=# load '$libdir/plr';
ERROR:  could not load library "C:/Program 
Files/PostgreSQL/8.3/lib/plr.dll": The specified procedure could not be 
found.


Actually, this looks like perhaps the backend is unable to load a DLL 
that plr.dll depends on. Again, the "depends" tool can hopefully show 
you what's missing there.


//Magnus


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs


Re: [BUGS] BUG #3983: pgxs files still missing in win32 install (8.3.1)

2008-04-14 Thread Joe Conway

Magnus Hagander wrote:
Could this be somethingl ike missing PGDLLIMPORT specifications in your 
addon module or something like that? Try checking the names of the 
functions that are actually exported using "depends" or a similar tool.


Ah, that sounds likely, since I have never had to worry about explicit 
exports with PL/R before. Can you point me to an example or cheat sheet 
on what I need to do?


ERROR:  could not load library "C:/Program 
Files/PostgreSQL/8.3/lib/plr.dll": The specified procedure could not 
be found.


Actually, this looks like perhaps the backend is unable to load a DLL 
that plr.dll depends on. Again, the "depends" tool can hopefully show 
you what's missing there.


That's what I was originally thinking (R.dll), but now I suspect the 
exported functions is probably the issue. I'll check this out when I get 
home tonight.


Thanks,

Joe

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs