470,580 Members | 2,327 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Transaction question


Hi, I have a question about transactions.

I am developing a Postgresql client.

If I start a transaction in a Postgresql client code, and in this
process a trigger is executed. Are all the processes within the trigger
in the transaction too?

Thank you

P.D. Sorry for my English.
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 11 '05 #1
1 1193
Fredy Ramirez wrote:

Hi, I have a question about transactions.

I am developing a Postgresql client.

If I start a transaction in a Postgresql client code, and in this
process a trigger is executed. Are all the processes within the trigger
in the transaction too?


Yes, the trigger is in the same transaction as the statement that
triggered it.

--
Bruce Momjian | http://candle.pha.pa.us
pg***@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 11 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Avanish Pandey | last post: by
8 posts views Thread by Alex | last post: by
12 posts views Thread by John Sidney-Woollett | last post: by
15 posts views Thread by Zeng | last post: by
1 post views Thread by REB | last post: by
14 posts views Thread by Jim Michaels | last post: by
10 posts views Thread by Lit | last post: by
1 post views Thread by livre | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.