Transactions over several db sessions
От | |
---|---|
Тема | Transactions over several db sessions |
Дата | |
Msg-id | Pine.LNX.4.33.0205201625300.7043-100000@donkey.noc.u-net.net обсуждение исходный текст |
Список | 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
В списке pgsql-novice по дате отправления: