PostgreSQL return value after update table using function & trigger

Question

I have one question about the function flow in PostgreSQL. I used function to insert/update in table A and the function return integer value 1-> insert transaction, 0->update transaction. My question is if I add AFTER trigger in table A to update the new value to table B, when the return function will be delivered? First or second scenario?

First scenario: Call function -> update table A -> return function value -> call trigger -> update table B

Second scenario: Call function -> update table A -> call trigger -> update table B -> return function value?

Thanks in advance.

I want to know if I call function to update table A, and where table A have trigger to update table B. When the function will return the integer value? First or second scenario? Thanks — user430926
– user430926, Commented Dec 9, 2013 at 10:48
I desagre with @Denis the question has all elements to understand the problem. — Jorge Campos
– Jorge Campos, Commented Dec 9, 2013 at 10:53

Denis de Bernardy · Accepted Answer · 2013-12-09 10:56:30Z

1

+50

The second scenario. Updating B will be part of updating A, and your function will wait until that completes before returning.

answered Dec 9, 2013 at 10:56

Denis de Bernardy

79.1k14 gold badges138 silver badges158 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user430926 Over a year ago

Do you have any article/document that suggest it's the second scenario? Thanks.

Denis de Bernardy Over a year ago

Not off the top of my head, but per specs, a statement and all of the triggers it fires are part of the same transaction. You can readily see this by consulting the xmin of affected rows (they'll all be the same) or raising an arbitrary error in an after trigger (in which case your entire transaction is rolled back and your function will return nothing).

Collectives™ on Stack Overflow

PostgreSQL return value after update table using function & trigger

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related