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