Re: [GENERAL] COPY vs \COPY FROM PROGRAM $$ quoting difference?

2017-09-29 Thread Alexander Stoddard
On Fri, Sep 29, 2017 at 11:54 AM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Fri, Sep 29, 2017 at 9:27 AM, Alexander Stoddard < > alexander.stodd...@gmail.com> wrote: > >> I found what seems to be an odd difference between COPY and \copy parsing.

[GENERAL] COPY vs \COPY FROM PROGRAM $$ quoting difference?

2017-09-29 Thread Alexander Stoddard
I found what seems to be an odd difference between COPY and \copy parsing. I am using a bash pipeline of sed commands to clean up a source data file before importing it into a table. This works fine when working from the command line and piping the result to psql on STDIN. However I attempted to

[GENERAL] Plans to lift no write limitation on parallelism?

2017-09-07 Thread Alexander Stoddard
The documentation for 9.6 suggests the future possibility of lifting the limitation on parallel query where it cannot be used in a query that writes data. Is lifting this limitation on the roadmap? https://www.postgresql.org/docs/current/static/when-can-parallel-query-be-used.html Thank you, Ale