[COMMITTERS] pgsql: Teach contrib/pg_stat_statements to handle multi-statement comma

2017-01-14 Thread Tom Lane
Teach contrib/pg_stat_statements to handle multi-statement commands better. Make use of the statement boundary info added by commit ab1f0c822 to let pg_stat_statements behave more sanely when multiple SQL queries are jammed into one query string. It now records just the relevant part of the sourc

[COMMITTERS] pgsql: Change representation of statement lists, and add statement loca

2017-01-14 Thread Tom Lane
Change representation of statement lists, and add statement location info. This patch makes several changes that improve the consistency of representation of lists of statements. It's always been the case that the output of parse analysis is a list of Query nodes, whatever the types of the indivi

[COMMITTERS] pgsql: Throw suitable error for COPY TO STDOUT/FROM STDIN in a SQL func

2017-01-14 Thread Tom Lane
Throw suitable error for COPY TO STDOUT/FROM STDIN in a SQL function. A client copy can't work inside a function because the FE/BE wire protocol doesn't support nesting of a COPY operation within query results. (Maybe it could, but the protocol spec doesn't suggest that clients should support thi

[COMMITTERS] pgsql: Throw suitable error for COPY TO STDOUT/FROM STDIN in a SQL func

2017-01-14 Thread Tom Lane
Throw suitable error for COPY TO STDOUT/FROM STDIN in a SQL function. A client copy can't work inside a function because the FE/BE wire protocol doesn't support nesting of a COPY operation within query results. (Maybe it could, but the protocol spec doesn't suggest that clients should support thi

[COMMITTERS] pgsql: Throw suitable error for COPY TO STDOUT/FROM STDIN in a SQL func

2017-01-14 Thread Tom Lane
Throw suitable error for COPY TO STDOUT/FROM STDIN in a SQL function. A client copy can't work inside a function because the FE/BE wire protocol doesn't support nesting of a COPY operation within query results. (Maybe it could, but the protocol spec doesn't suggest that clients should support thi

[COMMITTERS] pgsql: Throw suitable error for COPY TO STDOUT/FROM STDIN in a SQL func

2017-01-14 Thread Tom Lane
Throw suitable error for COPY TO STDOUT/FROM STDIN in a SQL function. A client copy can't work inside a function because the FE/BE wire protocol doesn't support nesting of a COPY operation within query results. (Maybe it could, but the protocol spec doesn't suggest that clients should support thi

[COMMITTERS] pgsql: Throw suitable error for COPY TO STDOUT/FROM STDIN in a SQL func

2017-01-14 Thread Tom Lane
Throw suitable error for COPY TO STDOUT/FROM STDIN in a SQL function. A client copy can't work inside a function because the FE/BE wire protocol doesn't support nesting of a COPY operation within query results. (Maybe it could, but the protocol spec doesn't suggest that clients should support thi

[COMMITTERS] pgsql: Throw suitable error for COPY TO STDOUT/FROM STDIN in a SQL func

2017-01-14 Thread Tom Lane
Throw suitable error for COPY TO STDOUT/FROM STDIN in a SQL function. A client copy can't work inside a function because the FE/BE wire protocol doesn't support nesting of a COPY operation within query results. (Maybe it could, but the protocol spec doesn't suggest that clients should support thi

[COMMITTERS] pgsql: Change default values for backup and replication parameters

2017-01-14 Thread Magnus Hagander
Change default values for backup and replication parameters This changes the default values of the following parameters: wal_level = replica max_wal_senders = 10 max_replication_slots = 10 in order to make it possible to make a backup and set up simple replication on the default settings, withou

[COMMITTERS] pgsql: pg_ctl: Change default to wait for all actions

2017-01-14 Thread Peter Eisentraut
pg_ctl: Change default to wait for all actions The different actions in pg_ctl had different defaults for -w and -W, mostly for historical reasons. Most users will want the -w behavior, so make that the default. Remove the -w option in most example and test code, so avoid confusion and reduce ve