Re: standard interfaces for replication providers

From: Markus Schiltknecht <markus(at)bluegap(dot)ch>
To: alfranio correia junior <alfranio(at)lsd(dot)di(dot)uminho(dot)pt>
Cc: Christopher Browne <cbbrowne(at)acm(dot)org>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: standard interfaces for replication providers
Date: 2006-08-09 07:33:35
Message-ID: 44D98FCF.90408@bluegap.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Richard Huxton 2006-08-09 07:38:22 Re: proposal for PL packages for 8.3.
Previous Message James 2006-08-09 06:08:34 BUG #2569: statement_timeout bug on Windows