Jan Wieck <wieck at lists.slony.info> writes:
> Update of /home/cvsd/slony1/slony1-engine/src/slon
> In directory main.slony.info:/tmp/cvs-serv9076
>
> Modified Files:
> 	cleanup_thread.c local_listen.c remote_listen.c 
> 	remote_worker.c slon.h 
> Log Message:
> Move slony to use the new txid contrib module instead of xxid.

It looks to me as though you still need to commit a change to
src/backend/slony1_base.sql (and possibly src/backend/slony1_func.sql)
in order to have table sl_event contain the new "ev_snapshot" column
in lieu of the old ones.

I was just trying to do a build of HEAD, and while I did get it to
compile, it failed to run.

slon reported:

CONFIG version for "dbname=slonyregress1 host=localhost user=cbbrowne port=5834" is 80300
DEBUG1 remoteListenThread_1: connected to 'dbname=slonyregress1 host=localhost user=cbbrowne port=5834'
ERROR  remoteListenThread_1: "select ev_origin, ev_seqno, ev_timestamp,        ev_snapshot,        "public".txid_snapshot_xmin(ev_snapshot),        "public".txid_snapshot_xmax(ev_snapshot),        ev_type,        ev_data1, ev_data2,        ev_data3, ev_data4,        ev_data5, ev_data6,        ev_data7, ev_data8 from "_slony_regress1".sl_event e where ev_timestamp < now() - '0 minutes'::interval and ( (e.ev_origin = '1' and e.ev_seqno > '5')) order by e.ev_origin, e.ev_seqno" - ERROR:  column "ev_snapshot" does not exist
LINE 1: select ev_origin, ev_seqno, ev_timestamp,        ev_snapshot...
                                                         ^

And the table does indeed lack the column:

slonyregress1 at localhost:5834=# \d _slony_regress1.sl_event
            Table "_slony_regress1.sl_event"
    Column    |            Type             | Modifiers 
--------------+-----------------------------+-----------
 ev_origin    | integer                     | not null
 ev_seqno     | bigint                      | not null
 ev_timestamp | timestamp without time zone | 
 ev_minxid    | _slony_regress1.xxid        | 
 ev_maxxid    | _slony_regress1.xxid        | 
 ev_xip       | text                        | 
 ev_type      | text                        | 
 ev_data1     | text                        | 
 ev_data2     | text                        | 
 ev_data3     | text                        | 
 ev_data4     | text                        | 
 ev_data5     | text                        | 
 ev_data6     | text                        | 
 ev_data7     | text                        | 
 ev_data8     | text                        | 
Indexes:
    "sl_event-pkey" PRIMARY KEY, btree (ev_origin, ev_seqno)
-- 
let name="cbbrowne" and tld="linuxdatabases.info" in String.concat "@" [name;tld];;
http://cbbrowne.com/info/internet.html
"The American Republic will endure until the day Congress discovers
that it can bribe the public with the public's money" 
-- Alexis de Toucqueville