3 ms·
I’m interested to hear what those PostgreSQL limitations are more specifically.
by jiggawatts 4y ago
I’m interested to hear what those PostgreSQL limitations are more specifically.
- samhuk 4y agoI don't want to get too much in the weeds, but one well-known example is missing support for LIMIT on DELETE and UPDATE statements. The workarounds that exist range from fairly pedestrian (like using the scary ctid column) to totally wild (like creating temp tables or using transactions and all sorts). The rabbit hole goes.
- rjbwork 4y agoPostgres still doesn't support SQL:2011, and the temporal_table extension doesn't support the proper syntax, and is a bit jank to boot. If you have any kind of complex DW or SCD needs Postgres is pretty much immediately out the window. I think MSSQL probably has the best support for that, unfortunately.