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

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.

Joe

p.s. actual output below

8<------------------------------

Welcome to psql 8.3.1, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

Warning: Console code page (437) differs from Windows code page (1252)
8-bit characters might not work correctly. See psql reference
page "Notes for Windows users" for details.

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.

postgres=# CREATE TYPE plr_environ_type AS (name text, value text);
CREATE TYPE
postgres=# CREATE OR REPLACE FUNCTION plr_environ ()
postgres-# RETURNS SETOF plr_environ_type
postgres-# AS '$libdir/plr','plr_environ'
postgres-# LANGUAGE 'C';
ERROR: could not load library "C:/Program
Files/PostgreSQL/8.3/lib/plr.dll": The specified procedure could not be
found.

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\jconway>dir "C:\Program Files\PostgreSQL\8.3\lib"
Volume in drive C has no label.
Volume Serial Number is A006-8372

Directory of C:\Program Files\PostgreSQL\8.3\lib

[...]
03/17/2008 03:49 AM 57,344 dblink.dll
[...]
03/17/2008 03:47 AM 28,264 libpq.lib
[...]
04/06/2008 12:50 PM 686,579 plr.dll