PostgreSQL READ UNCOMMITTED Has No Dirty Reads
@prranitarora▲ 11 net votes
PostgreSQL reports READ UNCOMMITTED when requested, but implements it as READ COMMITTED. A reader cannot see another transaction's uncommitted row, then sees the row in a later statement after the writer commits. The label alone does not imply dirty-read behavior on PostgreSQL.
1 COMMENT
PostgreSQL documents that
READ UNCOMMITTEDbehaves asREAD COMMITTED, so requesting it gives no weaker guarantee than the default isolation level. Corrections or other cases welcome below.