> Please copy out the files as requested in that email - I'm sure Tom is > still interested in debugging it to find the issue. After that, try a > REINDEX to see if it solves your problem.
Ok, see the snippets below. I just cut them from the PgAdminIII interface. Drop me a mail if you need more info. > And while you're at it, you guys should be at 8.2.7, not 8.2.4.. :-P Yes, you're right. But as we are trying out tsearch2 for full text searching it might just as well be a good idea to go straight to 8.3 during the summer. > There are some index fixes between those versions (specifically in > 8.2.5), but I don't know the details of them enough to say if this > could be the problem you're hitting. Thanks Magnus! // John -- Table: _replication.sl_seqlog CREATE TABLE _replication.sl_seqlog ( seql_seqid integer, -- Sequence ID seql_origin integer, -- Publisher node at which the sequence originates seql_ev_seqno bigint, -- Slony-I Event with which this sequence update is associated seql_last_value bigint -- Last value published for this sequence ) WITH (OIDS=FALSE); ALTER TABLE _replication.sl_seqlog OWNER TO slony; COMMENT ON TABLE _replication.sl_seqlog IS 'Log of Sequence updates'; COMMENT ON COLUMN _replication.sl_seqlog.seql_seqid IS 'Sequence ID'; COMMENT ON COLUMN _replication.sl_seqlog.seql_origin IS 'Publisher node at which the sequence originates'; COMMENT ON COLUMN _replication.sl_seqlog.seql_ev_seqno IS 'Slony-I Event with which this sequence update is associated'; COMMENT ON COLUMN _replication.sl_seqlog.seql_last_value IS 'Last value published for this sequence'; -- Index: _replication.sl_seqlog_idx CREATE INDEX sl_seqlog_idx ON _replication.sl_seqlog USING btree (seql_origin, seql_ev_seqno, seql_seqid); -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs