Transactions over several db sessions

From: <ghinchliffe(at)vianetworks(dot)co(dot)uk>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Transactions over several db sessions
Date: 2002-05-20 15:29:57
Message-ID: Pine.LNX.4.33.0205201625300.7043-100000@donkey.noc.u-net.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hiya
I use postgres as the backend db for several CGI apps. I would
really like to use the transaction features of postgres with this so I
could get the systems to rollback on partially complete forms etc (for all
those times users decided they didn't really want to do this and just
stop).

The problem I have is that quite often (90% of the time I think).
such transactions require the user to fill in a form, which is then
passed to the CGI app, which then presents another form to be completed
etc etc. Now each time the CGI app is called the connections to the db
are established, used and then closed once it has produced it's output.

Is there anyway that a single transaction can run across the db
connection being closed and re-opened (possibly several different
instances at the same time) ?

Thanks for your help

--
-----
Graeme Hinchliffe BSc (Hons) _
Unix Systems Engineer (UK Datacentre) ASCII ribbon campaign ( )
- against HTML email X
VIA NET.WORKS & vCards / \
http://arc.pasp.de/
Tel +44-1925-484065
Fax +44-1925-484055

ICQ : 3842605 (name : Link)

www.vianetworks.co.uk

Browse pgsql-novice by date

  From Date Subject
Next Message andre 2002-05-20 20:17:09 Guarantee uniqueness of PGP key
Previous Message Henshall, Stuart - WCP 2002-05-20 08:47:38 Re: Accessing table attributes from within PlPgSQL