out-of-order caution - Mailing list pgsql-hackers

From Kevin Grittner
Subject out-of-order caution
Date
Msg-id 4EA93576020000250004276C@gw.wicourts.gov
Whole thread Raw
Responses Re: out-of-order caution
List pgsql-hackers
On the docs page for the SELECT statement, there is a caution which
starts with:
| It is possible for a SELECT command using ORDER BY and FOR
| UPDATE/SHARE to return rows out of order. This is because ORDER BY
| is applied first.
Is this risk limited to queries running in READ COMMITTED
transactions?  If so, I think that should be mentioned in the
caution.
-Kevin


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Hot Backup with rsync fails at pg_clog if under load
Next
From: Simon Riggs
Date:
Subject: Re: out-of-order caution