out-of-order caution

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: out-of-order caution
Date: 2011-10-27 15:41:58
Message-ID: 4EA93576020000250004276C@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2011-10-27 15:55:07 Re: out-of-order caution
Previous Message Simon Riggs 2011-10-27 15:25:25 Re: Hot Backup with rsync fails at pg_clog if under load