pgsql: Doc: commit performs rollback of aborted transactions.

Doc: commit performs rollback of aborted transactions.

The COMMIT command handles an aborted transaction in the same
manner as the ROLLBACK command, but this wasn't explained in
its official reference page. Also mention that behavior in
the tutorial's material on transactions.

Also add a comment mentioning that we don't raise an exception
for COMMIT within an aborted transaction, as the SQL standard
would have us do.

Hyperlink a couple of cross-references while we're at it.

Author: David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
Reviewed-by: Gurjeet Singh <gurjeet(at)singh(dot)im>
Reviewed-by: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Discussion: https://postgr.es/m/CAKFQuwYgYR3rWt6vFXw=ZWZ__bv7PqvdOnHujG+UyqE11f+3sg@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/10e2a8ac6a621352e032a0ca5c74a2be88d157e4

Modified Files
--------------
doc/src/sgml/advanced.sgml | 18 +++++++++++++++---
doc/src/sgml/ref/commit.sgml | 45 ++++++++++++++++++++++++++++++++++++++++++--
2 files changed, 58 insertions(+), 5 deletions(-)