Re: Commit not required for update statement

Поиск
Список
Период
Сортировка
От prasanna rk
Тема Re: Commit not required for update statement
Дата
Msg-id CADzxCad1qK4b520-c+5EHcM7O0+zktuDK0PKfZkUVD7Pgz3yVw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Commit not required for update statement  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
Ответы Re: Commit not required for update statement
Список pgsql-admin
Дерево обсуждения
Hi Mark

Thank you for sharing, as per the link

"PostgreSQL actually treats every SQL statement as being executed within a transaction. If you do not issue a BEGINcommand, then each individual statement has an implicit BEGIN and (if successful) COMMIT wrapped around it. A group of statements surrounded by BEGIN and COMMIT is sometimes called a transaction block."

Note

Some client libraries issue BEGINand COMMIT commands automatically, so that you might get the effect of transaction blocks without asking. Check the documentation for the interface you are using.

Does this mean..every statement which does not have begin will be automatically commited. 


On Mon, 15 Oct 2018, 09:20 Mark Kirkwood, <mark.kirkwood@catalyst.net.nz> wrote:
Hi,

Definitely worth reading what the docs say about this, should clear
things up:
https://www.postgresql.org/docs/current/static/tutorial-transactions.html

regards

Mark


On 15/10/18 15:30, prasanna rk wrote:
> Hi all
>
> We are running posters 10.4 version, wanted to know if commit
> statement is not required for update.



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

Предыдущее
От: Mark Kirkwood
Дата:
Сообщение: Re: Commit not required for update statement
Следующее
От: soumitra bhandary
Дата:
Сообщение: Re: Null value returned by function pg_last_wal_receive_lsn()inLogical Replication