Hacker News new | past | comments | ask | show | jobs | submit login

That only applies for the read committed isolation level. It seems to me that at least serializable should not show inconsistent state in this situation?



A row lock is released on a delete.


What does that have to do with serializable transactions?

"The Serializable isolation level provides the strictest transaction isolation. This level emulates serial transaction execution for all committed transactions; as if transactions had been executed one after another, serially, rather than concurrently."

If you don't get the right behavior with serializable transactions, as you seem to be claiming, it seems to me that serializable transactions should be considered buggy. In this case they do not provide the guarantees they are claimed to provide.


You get the right behavior (a serialization conflict) in PostgreSQL. If you do not in some other database I would consider it to be buggy.


This is an already known problem. See SSI vs PSSI.




Consider applying for YC's Spring batch! Applications are open till Feb 11.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: