Adam Bartoszewicz sent instructions and compiled ddl for plpgsql_check for windows
Adam wrote (this is a how to build a PostgreSQL extension on MS Windows):
My general steps to compile plpgsql_check plugin on Windows 7:
- Download and install PostgreSQL 9.3.4 for Win32 from http://www.enterprisedb.com
- Download and install Microsoft Visual C++ 2010 Express
- Lern tutorial http://blog.2ndquadrant.com/compiling-postgresql-extensions-visual-studio-windows
- The plpgsql_check depends on plpgsql and we need to add plpgsql.lib to the library list. Unfortunately PostgreSQL 9.4.3 does not contain this library.
- Create a plpgsql.lib from plpgsql.dll as described in http://adrianhenke.wordpress.com/2008/12/05/create-lib-file-from-dll
- Change plpgsql_check.c file, add
PGDLLEXPORT
line before evry extension function, as described in http://blog.2ndquadrant.com/compiling-postgresql-extensions-visual-studio-windows
...PGDLLEXPORT Datum plpgsql_check_function_tb(PG_FUNCTION_ARGS); PGDLLEXPORT Datum plpgsql_check_function(PG_FUNCTION_ARGS); ... PGDLLEXPORT Datum plpgsql_check_function(PG_FUNCTION_ARGS) { Oid funcoid = PG_GETARG_OID(0); ... PGDLLEXPORT Datum plpgsql_check_function_tb(PG_FUNCTION_ARGS) { Oid funcoid = PG_GETARG_OID(0); ...- Build plpgsql_check.dll
- Install plugin
- copy
plpgsql_check.dll
toPostgreSQL\9.3\lib
- copy
plpgsql_check.control
andplpgsql_check--0.8.sql
toPostgreSQL\9.3\share\extension
No comments:
Post a Comment