Transactions - Mailing list pgsql-novice

From Chris Thompson
Subject Transactions
Date
Msg-id Pine.LNX.4.33L2.0201300918160.7425-100000@boyce.ednet.co.uk
Whole thread Raw
Responses Re: Transactions  ("Josh Berkus" <josh@agliodbs.com>)
Re: Transactions  (Torbjörn Andersson <tobbe@embryo.se>)
List pgsql-novice
Hi,
I am wondering how I would go about updating 2 database's in one go,
safely.

The databases are in different locations and so the network is a point of
failure.

I was hoping I could do it in a single transaction block? is this
possible. If not can anyone suggest any alternatives? I also had thought
about triggers but don't really know enough about them at present :-).

Thanks for any help.
Cheers
Chris

--

This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the sender. Any
offers or quotation of service are subject to formal specification.
Errors and omissions excepted.  Please note that any views or opinions
presented in this email are solely those of the author and do not
necessarily represent those of edNET or lightershade ltd. Finally, the
recipient should check this email and any attachments for the presence of
viruses.  edNET and lightershade ltd accepts no liability for any damage
caused by any virus transmitted by this email.

--

--
Virus scanned by edNET.

pgsql-novice by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: [Fwd: Re: pgaccess connection problems]
Next
From: Torbjörn Andersson
Date:
Subject: 16k query limit