-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Stéphane A. Schildknecht a écrit :
> Stéphane A. Schildknecht a écrit :
>> Christopher Browne a écrit :
>>> Quoting "Stéphane A. Schildknecht"
>>> <stephane.schildknecht at postgresqlfr.org>:
>>>> Any update on this?
>>> I had put this off, pending 1.2.16's release...
>>> I'll see if I can come up with resolution to this problem this week.
>> Hi,
> 
>> I searched a little further.
> 
>> Searching for SerializableSnapshot in 8.3 tree, I found:
> 
>> ../postgresql-8.3.7/src/backend/access/transam/xact.c:          if
>> (SerializableSnapshot)
>> ../postgresql-8.3.7/src/backend/access/transam/xact.c:
>> SerializableSnapshot->curcid = currentCommandId;
>> ../postgresql-8.3.7/src/backend/commands/variable.c:    if
>> (SerializableSnapshot != NULL)
>> ../postgresql-8.3.7/src/backend/utils/time/tqual.c:static SnapshotData
>> SerializableSnapshotData = {HeapTupleSatisfiesMVCC};
>> ../postgresql-8.3.7/src/backend/utils/time/tqual.c:Snapshot
>> SerializableSnapshot = NULL;
>> ../postgresql-8.3.7/src/backend/utils/time/tqual.c: * The SerializableSnapshot
>> is the first one taken in a transaction.
>> ../postgresql-8.3.7/src/backend/utils/time/tqual.c:     if
>> (SerializableSnapshot == NULL)
>> ../postgresql-8.3.7/src/backend/utils/time/tqual.c:
>> SerializableSnapshot = GetSnapshotData(&SerializableSnapshotData, true);
>> ../postgresql-8.3.7/src/backend/utils/time/tqual.c:             return
>> SerializableSnapshot;
>> ../postgresql-8.3.7/src/backend/utils/time/tqual.c:             return
>> SerializableSnapshot;
>> ../postgresql-8.3.7/src/backend/utils/time/tqual.c:     if
>> (SerializableSnapshot == NULL)
>> ../postgresql-8.3.7/src/backend/utils/time/tqual.c:     SerializableSnapshot =
>> NULL;
>> ../postgresql-8.3.7/src/include/utils/tqual.h:extern PGDLLIMPORT Snapshot
>> SerializableSnapshot;
> 
>> I did not find it in 8.4 source tree.
> 
>> So I tried to add that line in src/xxid/xxid.c and src/backend/slony1_func.c:
> 
>> Snapshot     SerializableSnapshot = NULL;

I had doubt it could work. Now, I know it does not :-(

<stdin>:13: PGRES_FATAL_ERROR select "_test2".initializeLocalNode(1, 'test2 : 1
- - test - localhost'); select "_test2".enableNode(1);  - ERREUR:  Slony-I:
SerializableSnapshot is NULL in createEvent()
CONTEXT:  PL/pgSQL function "enablenode" line 31 at RETURN
<stdin>:13: Possible unsupported PostgreSQL version (80400) 8.4, defaulting to
8.1 support


SAS
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFKHACjA+REPKWGI0ERAof+AJ0YRmNzTtEq/ZCVKMBcQRPS6uQ1ggCeMPcX
ERLBxABwMi9PJ6SkoPLh3H0=
=q72d
-----END PGP SIGNATURE-----