Re:The challenges of supporting foreign key constraints
by saltcured on Wednesday December 06, 2023 @06:46PM
(#38551052)
Ah, in my worldview those steps are still in a single transaction. It's just formulated as several ordered statements.
Is that mechanism unique to PostgreSQL? Or is it just that this transaction is impractical for you, due to the wall clock duration and how it impacts other use of the DB?
Is that mechanism unique to PostgreSQL? Or is it just that this transaction is impractical for you, due to the wall clock duration and how it impacts other use of the DB?