plpgsql_check 1.0.5 for MS Windows PostgreSQL 9.4, 9.5 and 9.6

278 views
Skip to first unread message

Pavel Stehule

unread,
Aug 25, 2016, 4:35:12 PM8/25/16
to postgresql-extensions-hacking
Hi

I am sending compiled dll for these PostgreSQL releases.

Please test it.

Compiled by Visual C++ 2015, so you Visual C++ Redistrbutable for Visual Studio 2015 is necessary.

Usage:

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).


Regards

Pavel
plpgsql-1.0.5-dll.zip

Nathanaël TERRIEN

unread,
Aug 29, 2016, 7:17:23 AM8/29/16
to postgresql-extensions-hacking
Hi.
I tried to install the extension on PostgreSQL 9.5.4, 64 bits, Windows 10 (french) but got this error after executing "CREATE EXTENSION plpgsql_check;" :
"ERREUR: n'a pas pu charger la bibliothèque « C:/PostgreSQL/9.5/lib/plpgsql_check.dll » : unknown error 126

********** Erreur **********

ERREUR: n'a pas pu charger la bibliothèque « C:/PostgreSQL/9.5/lib/plpgsql_check.dll » : unknown error 126
État SQL :XX000"

It's partially in french, sorry, but basically it says that the DLL could not be loaded. I double checked though, and I'm pretty sure I copied the right dll (plpgsql_check-9.5-x64.dll) file to /lib/ (plpgsql_check.dll)

Anything I could try ?

Pavel Stehule

unread,
Aug 29, 2016, 7:19:54 AM8/29/16
to Nathanaël TERRIEN, postgresql-extensions-hacking
Hi

do you have so Visual C++ Redistrbutable for Visual Studio 2015 on your computer?

Regards

Pavel


--
You received this message because you are subscribed to the Google Groups "postgresql-extensions-hacking" group.
To unsubscribe from this group and stop receiving emails from it, send an email to postgresql-extensions-hacking+unsub...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Nathanaël TERRIEN

unread,
Aug 29, 2016, 1:05:52 PM8/29/16
to Pavel Stehule, postgresql-extensions-hacking
Thanks for answering so quickly.
Yes, I do have "Visual C++ Redistrbutable for Visual Studio 2015" installed (both 32 and 64 bits versions).
--

Nathanaël

Nathanaël TERRIEN

unread,
Aug 29, 2016, 1:05:52 PM8/29/16
to postgresql-extensions-hacking
>>do you have so Visual C++ Redistrbutable for Visual Studio 2015 on your computer?

I rechecked and I do (both 32 and 64 bits versions).

Pavel Stehule

unread,
Sep 2, 2016, 3:21:03 AM9/2/16
to Nathanaël TERRIEN, postgresql-extensions-hacking
Hi

I found a issue - the dll was linked with broken library. I'll send new version early.

Regards

Pavel

--

Pavel Stehule

unread,
Sep 3, 2016, 1:21:20 AM9/3/16
to Nathanaël TERRIEN, postgresql-extensions-hacking
Hi

2016-09-02 9:20 GMT+02:00 Pavel Stehule <pavel....@gmail.com>:
Hi

I found a issue - the dll was linked with broken library. I'll send new version early.

I am sending fresh build - it should be ok now.

Regards

Pavel
plpgsql_check-1.0.5-2.zip

Nathanaël TERRIEN

unread,
Sep 5, 2016, 9:36:00 AM9/5/16
to Pavel Stehule, postgresql-extensions-hacking
Working great!
Thanks.
--

Nathanaël

Reply all
Reply to author
Forward
0 new messages