[COMMITTERS] pgsql: Fix bug around assignment expressions containing indirections.

2015-07-24 Thread Andres Freund
Fix bug around assignment expressions containing indirections. Handling of assigned-to expressions with indirection (e.g. set f1[1] = 3) was broken for ON CONFLICT DO UPDATE. The problem was that ParseState was consulted to determine if an INSERT-appropriate or UPDATE-appropriate behavior should

[COMMITTERS] pgsql: Fix bug around assignment expressions containing indirections.

2015-07-24 Thread Andres Freund
Fix bug around assignment expressions containing indirections. Handling of assigned-to expressions with indirection (e.g. set f1[1] = 3) was broken for ON CONFLICT DO UPDATE. The problem was that ParseState was consulted to determine if an INSERT-appropriate or UPDATE-appropriate behavior should

[COMMITTERS] pgsql: Fix treatment of nulls in jsonb_agg and jsonb_object_agg

2015-07-24 Thread Andrew Dunstan
Fix treatment of nulls in jsonb_agg and jsonb_object_agg The wrong is_null flag was being passed to datum_to_json. Also, null object key values are not permitted, and this was not being checked for. Add regression tests covering these cases, and also add those tests to the json set, even though it

[COMMITTERS] pgsql: Fix treatment of nulls in jsonb_agg and jsonb_object_agg

2015-07-24 Thread Andrew Dunstan
Fix treatment of nulls in jsonb_agg and jsonb_object_agg The wrong is_null flag was being passed to datum_to_json. Also, null object key values are not permitted, and this was not being checked for. Add regression tests covering these cases, and also add those tests to the json set, even though it

[COMMITTERS] pgsql: Make RLS work with UPDATE ... WHERE CURRENT OF

2015-07-24 Thread Joe Conway
Make RLS work with UPDATE ... WHERE CURRENT OF UPDATE ... WHERE CURRENT OF would not work in conjunction with RLS. Arrange to allow the CURRENT OF expression to be pushed down. Issue noted by Peter Geoghegan. Patch by Dean Rasheed. Back patch to 9.5 where RLS was introduced. Branch -- master

[COMMITTERS] pgsql: Make RLS work with UPDATE ... WHERE CURRENT OF

2015-07-24 Thread Joe Conway
Make RLS work with UPDATE ... WHERE CURRENT OF UPDATE ... WHERE CURRENT OF would not work in conjunction with RLS. Arrange to allow the CURRENT OF expression to be pushed down. Issue noted by Peter Geoghegan. Patch by Dean Rasheed. Back patch to 9.5 where RLS was introduced. Branch -- REL9_5_