Re: [COMMITTERS] pgsql: Enable logical slots to follow timeline switches

2016-03-31 Thread Michael Paquier
On Thu, Mar 31, 2016 at 8:45 AM, Alvaro Herrera wrote: > Tom Lane wrote: >> Alvaro Herrera writes: >> > Enable logical slots to follow timeline switches >> >> Buildfarm doesn't like this one bit :-( > > Argh, forgot the alternate expected file when the needed feature is > disabled. Will fix. ha

[COMMITTERS] pgsql: Another zic portability fix.

2016-03-31 Thread Tom Lane
Another zic portability fix. I should have remembered that we can't use INT64_MODIFIER with sscanf(): configure chooses that to work with snprintf(), but it might be for our src/port/snprintf.c implementation and so not compatible with the platform's sscanf(). This appears to be the explanation f

[COMMITTERS] pgsql: Fix recovery_min_apply_delay test

2016-03-31 Thread Alvaro Herrera
Fix recovery_min_apply_delay test Previously this test was relying too much on WAL replay to occur in the exact configured interval, which was unreliable on slow or overly busy servers. Use a custom loop instead of poll_query_until, which is hopefully more reliable. Per continued failures on bui

[COMMITTERS] pgsql: Support using index-only scans with partial indexes in more case

2016-03-31 Thread Tom Lane
Support using index-only scans with partial indexes in more cases. Previously, the planner would reject an index-only scan if any restriction clause for its table used a column not available from the index, even if that restriction clause would later be dropped from the plan entirely because it's

[COMMITTERS] pgsql: Add missing checks to some of pageinspect's BRIN functions

2016-03-31 Thread Alvaro Herrera
Add missing checks to some of pageinspect's BRIN functions brin_page_type() and brin_metapage_info() did not enforce being called by superuser, like other pageinspect functions that take bytea do. Since they don't verify the passed page thoroughly, it is possible to use them to read the server mem

[COMMITTERS] pgsql: Reset plan->row_security_env and planUserId

2016-03-31 Thread Stephen Frost
Reset plan->row_security_env and planUserId In the plancache, we check if the environment we planned the query under has changed in a way which requires us to re-plan, such as when the user for whom the plan was prepared changes and RLS is being used (and, therefore, there may be different policie

[COMMITTERS] pgsql: Last-minute updates for release notes.

2016-03-31 Thread Tom Lane
Last-minute updates for release notes. Security: CVE-2016-2193, CVE-2016-3065 Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/4c46f83386a7e3556856d1e4c9f0c294d16b0dcc Modified Files -- doc/src/sgml/release-9.5.sgml | 43 ++

[COMMITTERS] pgsql: Reset plan->row_security_env and planUserId

2016-03-31 Thread Stephen Frost
Reset plan->row_security_env and planUserId In the plancache, we check if the environment we planned the query under has changed in a way which requires us to re-plan, such as when the user for whom the plan was prepared changes and RLS is being used (and, therefore, there may be different policie

[COMMITTERS] pgsql: Add missing checks to some of pageinspect's BRIN functions

2016-03-31 Thread Alvaro Herrera
Add missing checks to some of pageinspect's BRIN functions brin_page_type() and brin_metapage_info() did not enforce being called by superuser, like other pageinspect functions that take bytea do. Since they don't verify the passed page thoroughly, it is possible to use them to read the server mem

[COMMITTERS] pgsql: Last-minute updates for release notes.

2016-03-31 Thread Tom Lane
Last-minute updates for release notes. Security: CVE-2016-2193, CVE-2016-3065 Branch -- REL9_5_STABLE Details --- http://git.postgresql.org/pg/commitdiff/b56f7b1f0c5e41e85828774debf8b911a203e012 Modified Files -- doc/src/sgml/release-9.5.sgml | 43 +++