pgsql: Have \copy go through SendQuery - Mailing list pgsql-committers

From Alvaro Herrera
Subject pgsql: Have \copy go through SendQuery
Date
Msg-id E1RqAJq-0007jZ-GS@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Have \copy go through SendQuery

This enables a bunch of features, notably ON_ERROR_ROLLBACK.  It also
makes COPY failure (either in the server or psql) as a whole behave more
sanely in psql.

Additionally, having more commands in the same command line as COPY
works better (though since psql splits lines at semicolons, this doesn't
matter much unless you're using -c).

Also tighten a couple of switches on PQresultStatus() to add
PGRES_COPY_BOTH support and stop assuming that unknown statuses received
are errors; have those print diagnostics where warranted.

Author: Noah Misch

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/08146775acd8bfe0fcc509c71857abb928697171

Modified Files
--------------
src/bin/psql/command.c                   |   15 --
src/bin/psql/common.c                    |  205 ++++++++++++++++++++++--------
src/bin/psql/copy.c                      |  111 ++++++++--------
src/test/regress/expected/copyselect.out |   31 ++++-
src/test/regress/sql/copyselect.sql      |   14 ++
5 files changed, 250 insertions(+), 126 deletions(-)


pgsql-committers by date:

Previous
From: Robert Haas
Date:
Subject: pgsql: Make CheckIndexCompatible simpler and more bullet-proof.
Next
From: Robert Haas
Date:
Subject: pgsql: Instrument index-only scans to count heap fetches performed.