pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Markus Schiltknecht <markus@bluegap.ch>
To: alfranio correia junior <alfranio@lsd.di.uminho.pt>
Cc: Christopher Browne <cbbrowne@acm.org>
Cc: pgsql-hackers@postgresql.org
Subject: Re: standard interfaces for replication providers
Date: Wed, 09 Aug 2006 07:33:35 +0000
Message-ID: <44D98FCF.90408@bluegap.ch> (raw)
In-Reply-To: <44D8D9DE.50000@lsd.di.uminho.pt>
References: <44D30B31.2070403@lsd.di.uminho.pt>
	<200608041733.24228.jop@lsd.di.uminho.pt>
	<44D70EDA.9060602@bluegap.ch>
	<200608071940.26750.jop@lsd.di.uminho.pt>
	<44D89EA5.5090703@bluegap.ch>
	<87irl3uqgx.fsf@wolfe.cbbrowne.com>
	<44D8D334.5050808@bluegap.ch>
	<44D8D9DE.50000@lsd.di.uminho.pt>

Hello Alfranio,

alfranio correia junior wrote:
> Of course not...
> It is impossible to build a replication system entirely by only using
> triggers...

Hm, I don't think it's impossible, just unpractical. Anyway, if you say 
so yourself, I really doubt the use of GAPI. If you need to create your 
own hooks anyway beside GAPI, why use GAPI at all? Better have one kind 
of 'hooking' (i.e. with a dynamically loaded library).

> But definitely, there is a set of common requirements among a variety of
> replication systems. Moreover, such requirements are also useful to
> other systems as well.

So far, they are only partly usable for replication. I never looked into 
materialized views or anything else that would benefit from such triggers.

Regards

Markus



view thread (21+ messages)  latest in thread

Message-ID: <44D98FCF.90408@bluegap.ch>
Permalink:  ../44D98FCF.90408@bluegap.ch/
Also on:    postgresql.org/message-id/44D98FCF.90408@bluegap.ch

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: markus@bluegap.ch, alfranio@lsd.di.uminho.pt, cbbrowne@acm.org
  Subject: Re: standard interfaces for replication providers
  In-Reply-To: <44D98FCF.90408@bluegap.ch>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox