Re: Plpsql connecting to more than one database? - Mailing list pgsql-general

On 3/30/2016 2:02 PM, Francisco Reyes wrote:
> Have users that are familiar with plpsql and have a process which
> needs to be done withing  transactions in 2 databases.
> begin in db1
> begin in db2
>
> work on 1
> work on 2
>
> if work on both dbs worked
>
> commit db1
> commit db2


and what if commit db2 fails for any number of reasons?  you've already
committed db1, so you can't roll it back.      this sort of work
requires '2pc' (2-phase commit), which is rather gnarly to implement.



--
john r pierce, recycling bits in santa cruz