Bill Willits bwillits at cox.net
Mon Apr 30 22:57:33 PDT 2007
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 r=
eplication set unless necessary.

Thanks in advance.
BillW
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20070430/=
eb252b79/attachment.htm


More information about the Slony1-general mailing list