Re: One-shot expanded output in psql using \gx

Tobias Bussmann <t.bussmann@gmx.net>

From: Tobias Bussmann <t.bussmann@gmx.net>

To: PostgreSQL Hackers <pgsql-hackers@postgresql.org>

Cc: Christoph Berg <christoph.berg@credativ.de>, Daniel Verite <daniel@manitou-mail.org>, David Fetter <david@fetter.org>, Stephen Frost <sfrost@snowman.net>

Date: 2017-08-15T20:24:34Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

psql: Fix \gx when FETCH_COUNT is used
- 0cdc3e47bea4 11.0 landed
- 51d0fa8ed93f 10.0 landed
psql: Add \gx command
- b2678efd43f1 10.0 landed

Attachments

psql_gx_fetch_count_v1.patch (application/octet-stream) patch v1
(unnamed) (text/plain)

I've tested the new \gx against 10beta and current git HEAD. Actually one of my favourite features of PostgreSQL 10! However in my environment it was behaving strangely. After some debugging I found that \gx does not work if you have \set FETCH_COUNT n before. Please find attached a patch that fixes this incl. new regression test.

Best regards,
Tobias