Pages

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:

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

    ReplyDelete
  2. 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.

    ReplyDelete