Re: Hot Standby 0.2.1 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Hot Standby 0.2.1
Date
Msg-id 2476.1253721784@sss.pgh.pa.us
Whole thread Raw
In response to Re: Hot Standby 0.2.1  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-hackers
Jeff Janes <jeff.janes@gmail.com> writes:
> Unfortunately, isolation level "serializable" is not truly
> serializable.  Usually it is good enough, but when it isn't good
> enough and you need an explicit table lock (a very rare but not
> nonexistent situation), I think it should either lock the table in the
> manner it would do on the primary, or throw an error.  I think that
> silently changing the behavior between primary and standby is not a
> good thing.

+1 --- this proposal made me acutely uncomfortable, too.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Jeff Janes
Date:
Subject: Re: SELECT ... FOR UPDATE [WAIT integer | NOWAIT] for 8.5
Next
From: Heikki Linnakangas
Date:
Subject: Re: Hot Standby 0.2.1