[COMMITTERS] pgsql: Add note about how to make the SRF detoasted arguments live accr

2015-02-25 Thread Fujii Masao
Add note about how to make the SRF detoasted arguments live accross calls. Andrew Gierth and Ali Akbar Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/a7920b872fff36668a2d33157609024b851b5c2e Modified Files -- doc/src/sgml/xfunc.sgml | 14 +

[COMMITTERS] pgsql: Free SQLSTATE and SQLERRM no earlier than other PL/pgSQL variabl

2015-02-25 Thread Noah Misch
Free SQLSTATE and SQLERRM no earlier than other PL/pgSQL variables. "RETURN SQLERRM" prompted plpgsql_exec_function() to read from freed memory. Back-patch to 9.0 (all supported versions). Little code ran between the premature free and the read, so non-assert builds are unlikely to witness user-

[COMMITTERS] pgsql: Free SQLSTATE and SQLERRM no earlier than other PL/pgSQL variabl

2015-02-25 Thread Noah Misch
Free SQLSTATE and SQLERRM no earlier than other PL/pgSQL variables. "RETURN SQLERRM" prompted plpgsql_exec_function() to read from freed memory. Back-patch to 9.0 (all supported versions). Little code ran between the premature free and the read, so non-assert builds are unlikely to witness user-

[COMMITTERS] pgsql: Free SQLSTATE and SQLERRM no earlier than other PL/pgSQL variabl

2015-02-25 Thread Noah Misch
Free SQLSTATE and SQLERRM no earlier than other PL/pgSQL variables. "RETURN SQLERRM" prompted plpgsql_exec_function() to read from freed memory. Back-patch to 9.0 (all supported versions). Little code ran between the premature free and the read, so non-assert builds are unlikely to witness user-

[COMMITTERS] pgsql: Free SQLSTATE and SQLERRM no earlier than other PL/pgSQL variabl

2015-02-25 Thread Noah Misch
Free SQLSTATE and SQLERRM no earlier than other PL/pgSQL variables. "RETURN SQLERRM" prompted plpgsql_exec_function() to read from freed memory. Back-patch to 9.0 (all supported versions). Little code ran between the premature free and the read, so non-assert builds are unlikely to witness user-

[COMMITTERS] pgsql: Free SQLSTATE and SQLERRM no earlier than other PL/pgSQL variabl

2015-02-25 Thread Noah Misch
Free SQLSTATE and SQLERRM no earlier than other PL/pgSQL variables. "RETURN SQLERRM" prompted plpgsql_exec_function() to read from freed memory. Back-patch to 9.0 (all supported versions). Little code ran between the premature free and the read, so non-assert builds are unlikely to witness user-

[COMMITTERS] pgsql: Free SQLSTATE and SQLERRM no earlier than other PL/pgSQL variabl

2015-02-25 Thread Noah Misch
Free SQLSTATE and SQLERRM no earlier than other PL/pgSQL variables. "RETURN SQLERRM" prompted plpgsql_exec_function() to read from freed memory. Back-patch to 9.0 (all supported versions). Little code ran between the premature free and the read, so non-assert builds are unlikely to witness user-

[COMMITTERS] pgsql: Add hasRowSecurity to copyfuncs/outfuncs

2015-02-25 Thread Stephen Frost
Add hasRowSecurity to copyfuncs/outfuncs The RLS patch added a hasRowSecurity field to PlannerGlobal and PlannedStmt but didn't update nodes/copyfuncs.c and nodes/outfuncs.c to reflect those additional fields. Correct that by adding entries to the appropriate functions for those fields. Pointed

[COMMITTERS] pgsql: Add locking clause for SB views for update/delete

2015-02-25 Thread Stephen Frost
Add locking clause for SB views for update/delete In expand_security_qual(), we were handling locking correctly when a PlanRowMark existed, but not when we were working with the target relation (which doesn't have any PlanRowMarks, but the subquery created for the security barrier quals still need

[COMMITTERS] pgsql: Add locking clause for SB views for update/delete

2015-02-25 Thread Stephen Frost
Add locking clause for SB views for update/delete In expand_security_qual(), we were handling locking correctly when a PlanRowMark existed, but not when we were working with the target relation (which doesn't have any PlanRowMarks, but the subquery created for the security barrier quals still need

[COMMITTERS] pgsql: Fix over-optimistic caching in fetch_array_arg_replace_nulls().

2015-02-25 Thread Tom Lane
Fix over-optimistic caching in fetch_array_arg_replace_nulls(). When I rewrote this in commit 56a79a869bedc4bf6c35853642694cc0b0594dd2, I forgot that it's possible for the input array type to change from one call to the next (this can happen when applying the function to pg_statistic columns, for

[COMMITTERS] pgsql: Fix dumping of views that are just VALUES(...) but have column a

2015-02-25 Thread Tom Lane
Fix dumping of views that are just VALUES(...) but have column aliases. The "simple" path for printing VALUES clauses doesn't work if we need to attach nondefault column aliases, because there's noplace to do that in the minimal VALUES() syntax. So modify get_simple_values_rte() to detect nondefa

[COMMITTERS] pgsql: Fix dumping of views that are just VALUES(...) but have column a

2015-02-25 Thread Tom Lane
Fix dumping of views that are just VALUES(...) but have column aliases. The "simple" path for printing VALUES clauses doesn't work if we need to attach nondefault column aliases, because there's noplace to do that in the minimal VALUES() syntax. So modify get_simple_values_rte() to detect nondefa

[COMMITTERS] pgsql: Fix dumping of views that are just VALUES(...) but have column a

2015-02-25 Thread Tom Lane
Fix dumping of views that are just VALUES(...) but have column aliases. The "simple" path for printing VALUES clauses doesn't work if we need to attach nondefault column aliases, because there's noplace to do that in the minimal VALUES() syntax. So modify get_simple_values_rte() to detect nondefa

[COMMITTERS] pgsql: Fix dumping of views that are just VALUES(...) but have column a

2015-02-25 Thread Tom Lane
Fix dumping of views that are just VALUES(...) but have column aliases. The "simple" path for printing VALUES clauses doesn't work if we need to attach nondefault column aliases, because there's noplace to do that in the minimal VALUES() syntax. So modify get_simple_values_rte() to detect nondefa

[COMMITTERS] pgsql: Fix dumping of views that are just VALUES(...) but have column a

2015-02-25 Thread Tom Lane
Fix dumping of views that are just VALUES(...) but have column aliases. The "simple" path for printing VALUES clauses doesn't work if we need to attach nondefault column aliases, because there's noplace to do that in the minimal VALUES() syntax. So modify get_simple_values_rte() to detect nondefa

[COMMITTERS] pgsql: Fix dumping of views that are just VALUES(...) but have column a

2015-02-25 Thread Tom Lane
Fix dumping of views that are just VALUES(...) but have column aliases. The "simple" path for printing VALUES clauses doesn't work if we need to attach nondefault column aliases, because there's noplace to do that in the minimal VALUES() syntax. So modify get_simple_values_rte() to detect nondefa

[COMMITTERS] pgsql: Remove null-pointer checks that are not needed.

2015-02-25 Thread Michael Meskes
Remove null-pointer checks that are not needed. If a pointer is guaranteed to carry information there is no need to check for NULL again. Patch by Michael Paquier. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/8794bf1ca164e1be1554197b46c9ffc62d162fb8 Modified File

Re: [COMMITTERS] pgsql: Support more commands in event triggers

2015-02-25 Thread Fabien COELHO
Hello Alvaro, I have submitted a small patch to improve tests on event triggers, including tests for GRANT/REVOKE/COMMENT: https://commitfest.postgresql.org/5/179/ -- Fabien. -- Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org) To make changes to your subscri