Re: 32/64-bit transaction IDs?

"Ed L." <pgsql@bluepolka.net> writes:
> Actually, dbmirror does it in a couple of steps, but I think this is the
> basic idea.  So the queued tuple changes are groupable (and thus
> replayable) by xid and order of queueing.  Then the slave gets them in the
> hopefully-correct order via
>     select ...
>     from queue q
>     where q.xid is in some appropriate range
>     order by xid asc, tuple_id asc;

I think this last part is wrong.  It shouldn't be using the xid as part
of the ordering, only the sequence value.

            regards, tom lane