On Wed, 2011-07-13 at 18:10 +0100, Duarte Fonseca wrote:
> Hi list,
>
> I'm currently upgrading from Postgresql 8.1 to 8.4 one of the steps of the
> process for me involves compiling the replication toolkit we use against 8.4.
>
> I've just run into a problem since this replication code references
> SerializableSnapshot which as been removed in 8.4, i was wondering what
> should our code use instead, I found a thread[1] in the hackers mailing list
> where GetActiveSnapshot() was recommended, i would greatly appreciate it if
> someone could point me in the right direction on this.
>
>
> The code in question goes something like:
>
> if (SerializableSnapshot == NULL)
> elog(ERROR, "SerializableSnapshot is NULL ");
>
> // Return the minxid from the current snapshot
> PG_RETURN_TRANSACTIONID(SerializableSnapshot->xmin);
I believe that equivalent code in 8.4 would look something like:
if (!IsXactIsoLevelSerializable || !ActiveSnapshotSet())
elog(ERROR, "Could not find serializable snapshot");
PG_RETURN_TRANSACTIONID(GetActiveSnpashot()->xmin);
However, be careful! Some of this code changes again in 9.1. In 9.1, you
probably want to look for the "repeatable read" transaction.
Regards,
Jeff Davis
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
