469,111 Members | 1,961 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,111 developers. It's quick & easy.

resilient transactions

Hi all!
Apologies for sending this mail but some time back there was a thread on
supporting resilient transactions - i.e. transactions which do not roll
back if one query in 100 fails.
This was thought to be useful in case someone is typing on the psql prompt
and makes a spelling mistake. I would like to know what was the result of
that thread.
I tried searching in postgres-general but could not find it.
Can anyone point out the link to me?

thanks a lot
paramveer singh

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 23 '05 #1
1 969

On Sep 7, 2004, at 3:35 AM, Pa*************@trilogy.com wrote:
Hi all!
Apologies for sending this mail but some time back there was a thread
on
supporting resilient transactions - i.e. transactions which do not roll
back if one query in 100 fails.


transactions can either entirely succeed or entirely fail, there is no
"sometimes". Any discussion or even patches that do change that will
be rejected immediately (Well, I'm simply assuming they will. I think
myself and many others would be mighty surprised if a patch like that
got applied!)

PG 8.0 introduces a feature called savepoints which allows you to trap
errors inside a transaction (and also rollback parts of the
transaction, etc.) You may want to look into that.

http://developer.postgresql.org/docs...savepoint.html

--
Jeff Trout <je**@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Iain Mcleod | last post: by
11 posts views Thread by Mike P | last post: by
12 posts views Thread by Rami | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.