Pages

Saturday, February 7, 2015

plpgsql_check is available for Microsoft Windows

I compiled the plpgsql_check by Visual Studio 2010 Express. The dll for PostgreSQL 9.2, 9.3, 9.4 and x86 and x64 platform are available in zip archive http://pgsql.cz/files/plpgsql_check-1.0.1-1-mswin.zip.

Installation

  1. Download, unzip and choose related dll file
  2. rename to plpgsql_check.dll and copy to PostgreSQL's lib directory (Program Files/PostgreSQL/9.2/lib)
  3. copy plpgsql_check-1.0.sql and plpgsql_check.control to PostgreSQL's share/extension directory (PostgreSQL/9.2/share/extension).

It can needed installed a Microsoft Visual C++ 2010 SP1 Redistributable Package http://www.microsoft.com/en-us/download/details.aspx?id=8328.

Please, check it.

8 comments:

  1. I have an error calling plpgsql_check_function:

    ERROR: could not load library "C:/Program Files/PostgreSQL/9.4/lib/plpgsql_check.dll": unknown error 126

    Windows 8.1 x64, PostgreSQL 9.4.1 x64

    (I tried with plpgsql.lib too)

    ReplyDelete
  2. have you installed Microsoft Visual C++ 2010 SP1 Redistributable Package? Have you last update of plpgsql_lib? It have to be "http://pgsql.cz/files/plpgsql_check-1.0.1-1-mswin.zip"

    ReplyDelete
  3. Any chance you could build this for 9.5 as well?

    Thanks in advance

    ReplyDelete
  4. Any chance you could build this for 9.5?

    Thanks in advance,

    *B

    ReplyDelete
  5. I checked all links there and all are valid

    ReplyDelete
  6. Strange, now I have access. Thank you for checking it out.
    Unfortunate that there is no build for 9.5

    ReplyDelete
  7. The work with visual studio is pretty unfriendly for me. But I'll refresh packages at end of August.

    ReplyDelete