PostgreSQL error while commit/ rollback in function

Question

I am creating a Postgres function where I want to insert data into multiple tables and if any of them get failed then I want to rollback the transaction. But while writing the code begin transaction; in my function it says below error: ERROR: syntax error at or near "transaction"

Post your code...

Nick
– Nick

2017-08-03 23:16:38 +00:00
Commented Aug 3, 2017 at 23:16 — Nick
– Nick, Commented Aug 3, 2017 at 23:16

Craig Ringer · Accepted Answer · 2017-08-04 02:19:51Z

1

PL/PgSQL functions cannot begin or commit transactions.

You appear to want autonomous transactions, but they are not supported.

Perhaps you can do what you need with a PL/PgSQL BEGIN ... EXCEPTION ... block. You can abort the (sub)transaction with a RAISE command to raise an error, instead of ROLLBACK.

answered Aug 4, 2017 at 2:19

Craig Ringer

329k83 gold badges742 silver badges820 bronze badges

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

Collectives™ on Stack Overflow

PostgreSQL error while commit/ rollback in function

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related