By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,948 Members | 852 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,948 IT Pros & Developers. It's quick & easy.

Starting More Than one Transaction

P: 18
Thanks To Moderator for your valuable and Quick reply.

I would like to start more than one transaction in single database connection using libpq 'c' interface. let explian me this one detail.

here I have started Transaction 'T1' and without ending that transaction again I would like to start another transaction 'T2'. How can I achieve This one Using the Libpq 'C' Interface.

Mar 19 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 534
For nested transactions you will use savepoints. See BEGIN and SAVEPOINT for details.

More details on how to use transactions in libpq can be found here

Multiple queries sent in a single PQexec call are processed in a single
transaction, unless there are explicit BEGIN/COMMIT commands included
in the query string to divide it into multiple transactions.
Mar 19 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.