[GENERAL] Reasons to reorder results *within* a transaction?

2013-10-04 Thread Evan Jones
ime commit; Needless to say, this is one of those fun rare bugs that appeared occasionally in the logs in our production server, and we couldn't seem to reproduce it in development. Thanks! Evan Jones -- Work: https://www.mitro.co/Personal: http://evanjones.ca/ -- Sent via pgsql-

Re: [GENERAL] Reasons to reorder results *within* a transaction?

2013-10-04 Thread Evan Jones
On Oct 4, 2013, at 13:03 , Kevin Grittner wrote: > That is not a valid assumption. For one thing, the default > transaction isolation level is read committed, and at that > isolation level you are not guaranteed to even get the same *rows* > running the same query twice within the same transactio