Skip site navigation (1) Skip section navigation (2)

Transactions

From: Chris Thompson <thompson(at)lightershade(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Transactions
Date: 2002-01-30 09:21:17
Message-ID: Pine.LNX.4.33L2.0201300918160.7425-100000@boyce.ednet.co.uk (view raw or flat)
Thread:
Lists: 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.

Responses

pgsql-novice by date

Next:From: Raphael BauduinDate: 2002-01-30 10:16:08
Subject: Granting rights on all tables, sequences and views
Previous:From: Oliver ElphickDate: 2002-01-30 06:58:47
Subject: Re: [Fwd: Re: pgaccess connection problems]

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group