Pages

▼
Thursday, April 2, 2026

Using non ACID storage as workaround instead missing autonomous transactions

›
When I was younger, the culture war (in my bubble) was about transactional versus non-transactional engines, Postgres versus MySQL (MyISAM...
Friday, December 19, 2025

fresh dll of orafce and plpgsql_check for PostgreSQL 17 and PostgreSQL 18

›
I compiled and uploaded zip files with latest orafce and plpgsql_check for PostgreSQL 17 and PostgreSQL 18 - I used Microsoft Visual C 202...
Saturday, April 19, 2025

Article about PostgreSQL 18

›
I wrote an article about PostgreSQL 18.  It is in Czech language, but translators from Czech to English, German, ... works relatively well t...
Saturday, March 29, 2025

How to fix Hibernate bug by conditional index

›
Yesterday I found significant grow of seq read tuples. After some investigation I found query with strange predicate: WHERE 1 = case when p...
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: download plp...
2 comments:
Wednesday, February 5, 2025

plpgsql_check, raise warning when syntax of plpgsql expression is not pure

›
Originally the PL/pgSQL was very simple language and integration procedural language with SQL was very primitive. Very specific feature of P...
Monday, December 2, 2024

compiled win x64 dll of orafce-4.14.0 and plpgsql_check-2.7.12 for PostgreSQL 16 and 17

›
I compiled and uploaded zip files with latest orafce and plpgsql_check for PostgreSQL 16 and PostgreSQL 17 - I used Microsoft Visual C 202...