rserv

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>)

Browse pgsql-general by date

  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