Re: trigger, transactions, eek

From: Manuel Sugawara <masm(at)fciencias(dot)unam(dot)mx>
To: Chris Thompson <thompson(at)ednet(dot)co(dot)uk>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: trigger, transactions, eek
Date: 2002-05-15 17:35:30
Message-ID: m38z6liaos.fsf@dep4.fciencias.unam.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Chris Thompson <thompson(at)ednet(dot)co(dot)uk> writes:

> Hi,
> I'm trying to find some info on how to safely maintain 2 separate
> databases.
>
> Basically, an INSERT or UPDATE will happen the master db, and this should
> call a trigger to a cpp app that will exec the appropriate query on the
> second db.

This requires two pass commit which is not implemented in postgres and
will not be implemented in the foreseeable future. May be you should
re think your design or use Oracle :-(

Regards,
Manuel.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message gerry.smit 2002-05-15 17:37:56 Answering my own question
Previous Message Manuel Sugawara 2002-05-15 17:35:16 Re: Catching errors inside transactions