Do postgres use implicit transaction in UPDATE ... RETURNING queries?

Поиск
Список
Период
Сортировка
От Debraj Manna
Тема Do postgres use implicit transaction in UPDATE ... RETURNING queries?
Дата
Msg-id CAF6DVKNEbSXLVOs=BBNxhQ_+pjQJL8uMrwx9GWHNyAZyvirvmA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Do postgres use implicit transaction in UPDATE ... RETURNING queries?
Список pgsql-admin

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
);

В списке pgsql-admin по дате отправления: