On 11/16/2012 02:46 PM, Markus Wanner wrote:
Andres,
On 11/15/2012 01:27 AM, Andres Freund wrote:
In response to this you will soon find the 14 patches that currently
implement $subject.
Congratulations on that piece of work.
I'd like to provide a comparison of the proposed change set format to
the one used in Postgres-R. I hope for this comparison to shed some
light on the similarities and differences of the two projects. As the
author of Postgres-R, I'm obviously biased, but I try to be as neutral
as I can.
...
Let's compare by example:
table "replication_example": INSERT: id[int4]:1 somedata[int4]:1 text[varchar]:1
table "replication_example": UPDATE: id[int4]:1 somedata[int4]:-1
text[varchar]:1
table "replication_example": DELETE (pkey): id[int4]:1
In Postgres-R, the change sets for these same operations would carry the
following information, in a binary representation:
table "replication_example": INSERT: VALUES (1, 1, '1')
table "replication_example": UPDATE: PKEY(1) COID(77) MODS('nyn') VALUES(-1)
table "replication_example": DELETE: PKEY(1) COID(78)
Is it possible to replicate UPDATEs and DELETEs without a primary key in
PostgreSQL-R
Hannu
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
