Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Hackers > Command executi...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 4 Topic 9621 of 11009
Post > Topic >>

Command execution

by azzmosphere@[EMAIL PROTECTED] (Aaron Spiteri) Jul 3, 2008 at 11:15 PM

Hi guys,

I have been following the mailing list and reading the source code  
for a little while,  and was wandering if someone could fill in the  
gaps for me.  Does PostgresQL view updates and inserts performed in a  
function as part of the same transaction or are they considered  
separate transactions:

For instance say I had a function name foo and ran the command:

SELECT foo();

Inside foo there was a INSERT and UPDATE, and the INSERT failed but  
the UPDATE succeeded would the UPDATE be rolled back?

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
 




 4 Posts in Topic:
Command execution
azzmosphere@[EMAIL PROTEC  2008-07-03 23:15:33 
Re: Command execution
andreas.kretschmer@[EMAIL  2008-07-03 15:22:50 
Re: Command execution
nagy@[EMAIL PROTECTED] (  2008-07-03 15:27:44 
Re: Command execution
azzmosphere@[EMAIL PROTEC  2008-07-03 23:37:17 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Fri Dec 5 8:04:08 CST 2008.