It's because of things like that it's still hard for me to respect MySQL in 2022.
I use Postgres since 2008. It has never bitten me even once.
I use Postgres since 2008. It has never bitten me even once.
If Postgres has never bitten you, then you aren't using it much.
PostgreSQL has some sharp edges, sure, but a lot less obvious footguns like these.