[HACKERS] Re: new set of psql patches for loading (saving) data from (to) text, binary files - Mailing list pgsql-hackers

From Jason O'Donnell
Subject [HACKERS] Re: new set of psql patches for loading (saving) data from (to) text, binary files
Date
Msg-id 20170109162428.9879.70388.pgcf@coridan.postgresql.org
Whole thread Raw
In response to [HACKERS] new set of psql patches for loading (saving) data from (to) text,binary files  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: [HACKERS] Re: new set of psql patches for loading (saving) datafrom (to) text, binary files
List pgsql-hackers
The following review has been posted through the commitfest application:
make installcheck-world:  tested, passed
Implements feature:       tested, passed
Spec compliant:           not tested
Documentation:            tested, failed

Pavel,

gstore/gbstore:

The functionality worked as expected - one row, one column results of queries can be sent to a file or shell.  It would
benice if a test case was included that proves results more than one row, one column wide will fail.
 

The documentation included is awkward to read.  How about:

"Sends the current query input buffer to the server and stores
the result to an output file specified in the query or pipes the output 
to a shell command.  The file or command are written to only if the query 
successfully returns exactly one, non-null row and column.  If the 
query fails or does not return data, an error is raised. "


Parameterized Queries:

The functionality proposed works as expected.  Throughout the documentation, code and test cases the word
"Parameterized"is spelled incorrectly: "PARAMETRIZED_QUERIES"
 


set_from_file/set_from_bfile:

The functionality proposed worked fine, I was able to set variables in sql from files.  Minor typo in the
documentation:
"The content is escapeaed as bytea value."

Hope this helps!

Jason O'Donnell
Crunchy Data

The new status of this patch is: Waiting on Author

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [HACKERS] [PATCH] Rename pg_switch_xlog to pg_switch_wal
Next
From: Vladimir Rusinov
Date:
Subject: Re: [HACKERS] [PATCH] Rename pg_switch_xlog to pg_switch_wal