pgsql: Add regression tests for INSERT/UPDATE+RETURNING

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add regression tests for INSERT/UPDATE+RETURNING
Date: 2015-10-05 14:15:00
Message-ID: E1Zj6Xc-0005lm-AG@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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.

Branch
------
REL9_5_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/f9bb9c0a8a736efb567a676ad678d05a8dc35780

Modified Files
--------------
src/test/regress/expected/rowsecurity.out | 69 +++++++++++++++++++++++++++++
src/test/regress/sql/rowsecurity.sql | 63 ++++++++++++++++++++++++++
2 files changed, 132 insertions(+)

Browse pgsql-committers by date

  From Date Subject
Next Message Andres Freund 2015-10-05 14:51:54 pgsql: Remove outdated comment about relation level autovacuum freeze l
Previous Message Noah Misch 2015-10-05 14:09:49 pgsql: Prevent stack overflow in json-related functions.