I've been saying for years to just roll back to MySQL only because while support for other RDBMS' is good it's such a niche use case that's really only well suited for custom builds, and at that point Joomla isn't going to be a good choice for your needs (in part because there is so little ecosystem support, there are not many extension vendors providing PostgreSQL or SQL Server compatible packages and of those I know who have tried it they have also rolled back on the support because the niche use cases didn't justify the extra time and cost for that work).

We already fixed many postgres problems in j4 to make the situation better.

Drone already run postgresql tests, not many but it's a string point. Also system tests will run on both mysql and postgresql as soon as we start writing them. But for starting writing tests the system should be stable.

If there are problem please write an issue and we will try to fix it. In best case you have much more knowledge with pgsql as the most of us so you maybe able to provide a fix too.

Looks like @alikon does not only refers to postgres but also to the MySQL version.
Have I understood correctly?

mea culpa, i was one of them who strongly believed in miracles, unfortunately, now i'm making count with the sad reality, even if it seems i'm only one of the few looking at the real things.... but even if it cost a lot to me to admit.... the reality is under of eyes, if you really want to really look at it

What's wrong with PDO?