Re: trigger, transactions, eek - Mailing list pgsql-novice

From Manuel Sugawara
Subject Re: trigger, transactions, eek
Date
Msg-id m38z6liaos.fsf@dep4.fciencias.unam.mx
Whole thread Raw
In response to trigger, transactions, eek  (Chris Thompson <thompson@ednet.co.uk>)
List pgsql-novice
Chris Thompson <thompson@ednet.co.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.

pgsql-novice by date:

Previous
From: Manuel Sugawara
Date:
Subject: Re: Catching errors inside transactions
Next
From: gerry.smit@lombard.ca
Date:
Subject: Answering my own question