Postgres Pro
Downloads
Home   >   mailing lists

Re: Repeatable read and serializable transactions see data committed after tx start - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Repeatable read and serializable transactions see data committed after tx start
Date
Msg-id 27166.1415049550@sss.pgh.pa.us
Whole thread Raw
In response to Repeatable read and serializable transactions see data committed after tx start  (Álvaro Hernández Tortosa <aht@8Kdata.com>)
Responses Re: Repeatable read and serializable transactions see data committed after tx start  (Álvaro Hernández Tortosa <aht@8Kdata.com>)
List pgsql-hackers
Tree view 
Álvaro Hernández Tortosa <aht@8Kdata.com> writes:
>      IMHO, from a user perspective the transaction begins when the BEGIN 
> command is issued. If I really want to see a "frozen" view of the 
> database before any real SELECT, I have to issue another query like 
> "SELECT 1". This seems odd to me. I understand tx snapshot may be 
> deferred until real execution for performance reasons, but it is 
> confusing from a user perspective. Is this really expected, or is it a 
> bug? Am I having a bad day and missing some point here? ^_^

It's expected.  Without this behavior, you could not take out any locks
before freezing the transaction snapshot, which would be a bad thing.
I think there are some examples in the "concurrency control" chapter
of the manual.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Fabrízio de Royes Mello
Date:
Subject: Re: Re[2]: [HACKERS] Patch: add recovery_timeout option to control timeout of restore_command nonzero status code
Next
From: Alexey Vasiliev
Date:
Subject: Re[3]: [HACKERS] Patch: add recovery_timeout option to control timeout of restore_command nonzero status code