4 ms·

DELETE in SKIP LOCKED scenario is recipe for failure. God/Postgres gave you transactions for atomicity... only UPDATE w/ SKIP LOCKED, holy brother in Christ, an

by tucnak 1y ago

DELETE in SKIP LOCKED scenario is recipe for failure. God/Postgres gave you transactions for atomicity... only UPDATE w/ SKIP LOCKED, holy brother in Christ, and only DELETE completed normally.

baq 1y ago
God gave us Postgres to teach humanity that everything is an INSERT.
- tucnak 1y ago
  SWE's are learning about Type-2 tables the hard way round; of course, this is pure entertainment to data engineering people! Wait until "Audit table considered harmful" blog posts start popping up...