]> granicus.if.org Git - postgresql/commit
Add regression tests for INSERT/UPDATE+RETURNING
authorStephen Frost <sfrost@snowman.net>
Mon, 5 Oct 2015 14:14:51 +0000 (10:14 -0400)
committerStephen Frost <sfrost@snowman.net>
Mon, 5 Oct 2015 14:14:51 +0000 (10:14 -0400)
commitf9bb9c0a8a736efb567a676ad678d05a8dc35780
treec30ad5d08bd3ab31583f33fde5bebc2961d76ef9
parent7bed97d486bda5761ba7e7982e4133aeded6b852
Add regression tests for INSERT/UPDATE+RETURNING

This adds regressions tests which are specific to INSERT+RETURNING and
UPDATE+RETURNING to ensure that the SELECT policies are added as
WithCheckOptions (and should therefore throw an error when the policy is
violated).

Per suggestion from Andres.

Back-patch to 9.5 as the prior commit was.
src/test/regress/expected/rowsecurity.out
src/test/regress/sql/rowsecurity.sql