Thursday, February 27, 2025

fresh plpgsql_check 2.7.15 for PostgreSQL 16, 17 for MS Windows

 

I compiled and uploaded zip files plpgsql_check for PostgreSQL 16 and PostgreSQL 17 - I used Microsoft Visual C 2022.

Setup:

  1. download plpgsql_check-2.7.15-x86_64-windows.zip and extract files 
  2. copy related dll file to PostgreSQL lib directory (NN is number of pg release)
    plpgsql_check_NN.dll
    -> "c:\Program Files\PostgreSQL\NN\lib"
  3. copy *.sql and *.control files to extension directory (the version number) should be removed.
    *.sql, *.control -> "c:\Program Files\PostgreSQL\NN\share\extension"
  4. execute with super user rights SQL command CREATE EXTENSION
    CREATE EXTENSION plpgsql_check;



2 Comments:

At September 2, 2025 at 5:10 AM , Anonymous Anonymous said...

Step 2. Copy the appropriate plpgsql_check_NN.dll (plpgsql_check_16.dll if you are running PG16) as plpgsql_check.dll (without the version number) into the lib dir.

p.s. Thanks for the compiled version

 
At September 7, 2025 at 9:04 AM , Anonymous Anonymous said...

Addition: DLL file should be renamed, e.g. "plpgsql_check_16.dll" to "plpgsql_check.dll".
For me this did not help (ERROR: could not access file "$libdir/plpgsql_check": No such file or directory SQL state: 58P01), but my case should be exceptional some way.

 

Post a Comment

Subscribe to Post Comments [Atom]

<< Home