when transaction is committed in postgres

agora inbox for pgsql-sql@postgresql.org  
help / color / mirror / Atom feed

From: abctevez <swqshapu@163.com>
To: pgsql-sql@postgresql.org
Subject: when transaction is committed in postgres
Date: Thu, 29 Mar 2018 14:46:17 +0800 (CST)
Message-ID: <3b1b40d4.7fc7.1627081ce30.Coremail.swqshapu@163.com> (raw)

      Hello,I read the introduction of transaction on the postgresql official website. It notes that transaction is committed when commit call.
      Suppose that , I execute begin、execute command and then commit using some postgres client such as jdbc or odbc, what happens if the postgresql server receive commit command and response commit message failure,like tcp shakehand?If it is still to be committed, the client has no way to know whether the transaction is committed successfully or not.How does postgresql handle such situation


Thanks advances
Richard

view thread (2+ messages)  latest in thread

Message-ID: <3b1b40d4.7fc7.1627081ce30.Coremail.swqshapu@163.com>
Permalink:  ../3b1b40d4.7fc7.1627081ce30.Coremail.swqshapu@163.com/
Also on:    postgresql.org/message-id/3b1b40d4.7fc7.1627081ce30.Coremail.swqshapu@163.com

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: swqshapu@163.com
  Subject: Re: when transaction is committed in postgres
  In-Reply-To: <3b1b40d4.7fc7.1627081ce30.Coremail.swqshapu@163.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox