Can someone let me know if Postgres 15 uses implicit transactions for UPDATE...RETURNING
queries?
For example, is there any differences between the two queries
BEGIN;
UPDATE counter
SET value = value + 1
RETURNING value;
COMMIT;
and
UPDATE counter
SET value = value + 1
RETURNING value;
Table is like below
CREATE TABLE IF NOT EXISTS counter
(
value bigint PRIMARY KEY NOT NULL DEFAULT 0,
updated_at TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP
);