Steve Atkins <[EMAIL PROTECTED]> writes:
> On Fri, Jun 11, 2004 at 12:17:57PM -0400, Greg Stark wrote:
>
> > no, read committed would see any other updates that have been committed since
> > the start of your transaction.
>
> Uhm... only updates within the current transaction.
No, "read committed" refers to being able to read any updates that are
committed, even if they were committed after the start of your transaction:
For example:
db=> begin;
BEGIN
db=> begin;
BEGIN
db=> insert into test values (1);
INSERT 6725927 1
db=> select * from test;
a
---
1
(1 row)
db=> select * from test;
a
---
(0 rows)
db=> commit;
COMMIT
db=> select * from test;
a
---
1
(1 row)
--
greg
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
