Is it necessary to replicate sequences that are tied to table columns? Or,
does having the table as part of the replicated set sufficient to keep the
sequence-dependant data in sync.
eg.
CREATE TABLE test1
(
id serial NOT NULL, -- Unique identifier number (autoincrement)
...
CONSTRAINT test1_pkey PRIMARY KEY (id)
)
which creates "implicit sequence 'test1_id_seq' for SERIAL column 'test1.id'"
All of our sequences are this type and I would rather not add them to the
replication set unless necessary.
Thanks in advance.
BillW
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general