Re: [HACKERS] Re: new set of psql patches for loading (saving) datafrom (to) text, binary files

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: [HACKERS] Re: new set of psql patches for loading (saving) datafrom (to) text, binary files
Дата
Msg-id CAFj8pRBK60zgHqMiSGaCEHCRVMBZozvh2wEJ8o-aT9J_Y+B4Mw@mail.gmail.com
обсуждение исходный текст
Ответ на [HACKERS] Re: new set of psql patches for loading (saving) data from (to) text, binary files  (Jason O'Donnell <odonnelljp01@gmail.com>)
Ответы Re: [HACKERS] Re: new set of psql patches for loading (saving) datafrom (to) text, binary files  (Michael Paquier <michael.paquier@gmail.com>)
[HACKERS] Re: new set of psql patches for loading (saving) data from (to)text, binary files  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-hackers
Hi

Thank you for review

2017-01-09 17:24 GMT+01:00 Jason O'Donnell <odonnelljp01@gmail.com>:
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 be nice if a test case was included that proves results more than one row, one column wide will fail.

fixed
 

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. "

super 


Parameterized Queries:

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

fixed 


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."

fixed
 

Hope this helps!

Jason O'Donnell
Crunchy Data

The new status of this patch is: Waiting on Author

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: [HACKERS] Hash support for grouping sets
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] pageinspect: Hash index support