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