It looks like I still have this bug after updating to slony 2.0.1.
Can anyone confirm that this is the case or  additional info that you
require?
Thanks.
Tam

Details:
 ERROR,XX000,"Slony-I: old key column entities.cat_2_validation IS NULL on
UPDATE",,,,,,"update UK4628.entities set status_val_2 =3D 'STANDBY'
,status_val_3 =3D 'STANDBY'  where entity =3D 'SIR-1'",,
ERROR,XX000,"Slony-I: old key column lots_history_data.hold_name IS NULL on
UPDATE",,,,,,"update UK4628.lots_history_data set next_txid =3D 65298 where
lot =3D 'K009AX02' and next_txid is null",,

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
$ psql --version
psql (PostgreSQL) 8.3.3
contains support for command-line editing
$ slon -v
slon version 2.0.1


SET default_with_oids =3D false;

CREATE TABLE lots_history_data (
    txid bigint NOT NULL,
    next_txid bigint,
    lot character varying(20) NOT NULL,
    product character varying(30),
    route character varying(20),
    operation integer,
    next_std_route character varying(20),
    next_std_oper integer,
    lot_is_parent character(1) DEFAULT 'N'::bpchar,
    qty real,
    owner character varying(20),
    due_date date,
    terminated character(1) DEFAULT 'N'::bpchar,
    hot_lot character(1) DEFAULT 'N'::bpchar,
    restricted character(1) DEFAULT 'N'::bpchar,
    in_rework character(1) DEFAULT 'N'::bpchar,
    kitt_comp character(1) DEFAULT 'N'::bpchar,
    in_transit character(1) DEFAULT 'N'::bpchar,
    in_non_seq_mode character(1) DEFAULT 'N'::bpchar,
    on_hold character(1) DEFAULT 'N'::bpchar,
    in_process character(1) DEFAULT 'Y'::bpchar,
    unit_trace character(1) DEFAULT 'N'::bpchar,
    sub_products character(1) DEFAULT 'N'::bpchar,
    allo_comp character(1) DEFAULT 'N'::bpchar,
    movein_reqd character(1) DEFAULT 'N'::bpchar,
    script_id character varying(20),
    script_ver numeric,
    script_step integer,
    next_script_id character varying(20),
    next_script_ver numeric,
    next_script_step integer,
    child_of character varying(20),
    hold_cat character varying(20),
    hold_name character varying(20),
    hold_note character varying(80),
    lotname character varying(20),
    eng_owner character varying(40),
    stores character(1) DEFAULT 'N'::bpchar,
    own_entity character varying(20),
    password character varying(20),
 created timestamp without time zone,
    updated timestamp without time zone,
    main_route character varying(20),
    main_seqno integer,
    seqno integer
);

ALTER TABLE uk4628.lots_history_data OWNER TO mes;

ALTER TABLE ONLY lots_history_data
    ADD CONSTRAINT lots_history_data_pk PRIMARY KEY (txid, lot);
CREATE INDEX lot_history_data_lot_next_txid_idx ON lots_history_data USING
btree (lot, next_txid);

CREATE INDEX lots_history_data_next_idx ON lots_history_data USING btree
(next_txid);

CREATE TRIGGER _mesrep_denyaccess
    BEFORE INSERT OR DELETE OR UPDATE ON lots_history_data
    FOR EACH ROW
    EXECUTE PROCEDURE _mesrep.denyaccess('_mesrep');

ALTER TABLE lots_history_data DISABLE TRIGGER _mesrep_denyaccess;

CREATE TRIGGER _mesrep_logtrigger
    AFTER INSERT OR DELETE OR UPDATE ON lots_history_data
    FOR EACH ROW
    EXECUTE PROCEDURE _mesrep.logtrigger('_mesrep', '83', 'kvk');

ALTER TABLE ONLY lots_history_data
    ADD CONSTRAINT lots_history_data_lot_fkey FOREIGN KEY (lot) REFERENCES
lots(lot);

REVOKE ALL ON TABLE lots_history_data FROM PUBLIC;
REVOKE ALL ON TABLE lots_history_data FROM mes;
GRANT ALL ON TABLE lots_history_data TO mes;
GRANT SELECT ON TABLE lots_history_data TO mesview;

-------------------------------------------------------
CREATE TABLE entities (
    entity character varying(20) NOT NULL,
    entity_type character varying(20),
    rtc_model character varying(20),
    description character varying(40),
    status_cat_0 character varying(20),
    status_val_0 character varying(20),
    status_cat_1 character varying(20),
    status_val_1 character varying(20),
    status_cat_2 character varying(20),
    status_val_2 character varying(20),
    status_cat_3 character varying(20),
    status_val_3 character varying(20),
    status_cat_4 character varying(20),
    status_val_4 character varying(20),
    status_cat_5 character varying(20),
    status_val_5 character varying(20),
    status_cat_6 character varying(20),
    status_val_6 character varying(20),
    status_cat_7 character varying(20),
    status_val_7 character varying(20),
    status_cat_8 character varying(20),
    status_val_8 character varying(20),
    status_cat_9 character varying(20),
    status_val_9 character varying(20),
    deleted character(1),
    location character varying(20),
    entity_group_1 character varying(20),
    entity_group_2 character varying(20),
    entity_group_3 character varying(20),
    entity_group_4 character varying(20),
    entity_group_5 character varying(20),
    cat_0_validation character varying(20),
    cat_1_validation character varying(20),
    cat_2_validation character varying(20),
    cat_3_validation character varying(20),
    cat_4_validation character varying(20),
    cat_5_validation character varying(20),
    cat_6_validation character varying(20),
    cat_7_validation character varying(20),
    cat_8_validation character varying(20),
    cat_9_validation character varying(20)
);

ALTER TABLE uk4628.entities OWNER TO mes;
ALTER TABLE ONLY entities
    ADD CONSTRAINT entities_pk PRIMARY KEY (entity);
CREATE TRIGGER _mesrep_denyaccess
    BEFORE INSERT OR DELETE OR UPDATE ON entities
    FOR EACH ROW
    EXECUTE PROCEDURE _mesrep.denyaccess('_mesrep');
ALTER TABLE entities DISABLE TRIGGER _mesrep_denyaccess;

CREATE TRIGGER _mesrep_logtrigger
    AFTER INSERT OR DELETE OR UPDATE ON entities
    FOR EACH ROW
    EXECUTE PROCEDURE _mesrep.logtrigger('_mesrep', '59', 'k');
REVOKE ALL ON TABLE entities FROM PUBLIC;
REVOKE ALL ON TABLE entities FROM mes;
GRANT ALL ON TABLE entities TO mes;
GRANT SELECT ON TABLE entities TO mesview;
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-bugs/attachments/20090306/c59=
4f3ef/attachment.htm