pgsql: Have \copy go through SendQuery

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Have \copy go through SendQuery
Date: 2012-01-25 21:23:50
Message-ID: E1RqAJq-0007jZ-GS@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Robert Haas 2012-01-26 01:42:01 pgsql: Instrument index-only scans to count heap fetches performed.
Previous Message Robert Haas 2012-01-25 20:31:17 pgsql: Make CheckIndexCompatible simpler and more bullet-proof.