From: | Alvaro Herrera <alvherre(at)atentus(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | vadim4o(at)email(dot)com |
Subject: | rserv |
Date: | 2001-05-08 16:02:23 |
Message-ID: | 989337743.1918.0.camel@petrel.protecne.cl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi:
I'm using rserv (from contrib) to replicate one DB to another. Works fine
for all the easy tables, i.e. those that have a one column primary key.
However, I'm also trying to replicate a couple of man-in-the-middle for
many-to-many relatinships tables, so they don't have any unique fields.
In the rserv documentation it says that you have to specify a column
"that is updated" for each table, but is not clear to me which one to
specify for that kind of tables.
I'm currently creating a new field of type bigint, where I store a
combination of the primary key, that I can assure will be unique --
until I get lots of entries in the main tables, that is.
What is the "right" approach for this?
--
Alvaro Herrera (<alvherre[(at)]atentus(dot)com>)
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-05-08 16:40:49 | Re: Minor documentation bug |
Previous Message | Jeff Eckermann | 2001-05-08 15:40:42 | RE: Fixed width COPY |