Cursor stability vs ReadConsistency

[Attila Molnár]

Hi *!

What is the difference between cursor stability and ReadConsistency.

Thank you!

[Dmitry Yemanov]

06.03.2023 19:48, Attila Molnár wrote:
>
> What is the difference between cursor stability and ReadConsistency.

Cursor stability is about visibility of changes performed by the same
transaction/statement, e.g. INSERT INTO T SELECT * FROM T. Read
consistency is about visibility of changes performed by other
(concurrent) transactions. In both cases technically you can see the
changes, but the SQL standard declares that you shouldn't (during the
current statement execution -- it must be isolated).


Dmitry

[Attila Molnár]

Thanks Dmitry for the clarification!