Re: BUG #5882: last_value of sequence on replicated properly

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "lou fridkis" <lfridkis(at)earthlink(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5882: last_value of sequence on replicated properly
Date: 2011-02-11 17:59:45
Message-ID: 10546.1297447185@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"lou fridkis" <lfridkis(at)earthlink(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Andres Freund 2011-02-12 14:39:19 Re: [PATCH] crash in 9.1's psql:describeOneTableDetails
Previous Message lou fridkis 2011-02-11 16:39:37 BUG #5882: last_value of sequence on replicated properly