Transaction support

[hammeronthenet]

Hi,
not properly an issue but i don't understand if it's possible in some way to use transaction with automatic rollback if an error occoured.

If yes, how/where to find some example/documentation about that?

Thanks in advance.

[Alkarex]

Hello,
You can write any SQL statement you want. Have you tried something like the following?

BEGIN;
INSERT INTO products (product_no, name, price) VALUES (1, 'Cheese', 9.99);
COMMIT;

See https://www.postgresql.org/docs/current/tutorial-transactions.html