Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #5882: last_value of sequence on replicated properly - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #5882: last_value of sequence on replicated properly
Date
Msg-id 10546.1297447185@sss.pgh.pa.us
Whole thread Raw
In response to BUG #5882: last_value of sequence on replicated properly  ("lou fridkis" <lfridkis@earthlink.net>)
List pgsql-bugs
Tree view 
"lou fridkis" <lfridkis@earthlink.net> writes:
> The problem is that the values for loutest1_lou_id_seq are different
> after the test:

This is expected.  The slave may have a larger value than the primary.
It's because of the way that WAL logging for nextval() works.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "lou fridkis"
Date:
Subject: BUG #5882: last_value of sequence on replicated properly
Next
From: Andres Freund
Date:
Subject: Re: [PATCH] crash in 9.1's psql:describeOneTableDetails