pgsql-v9.2-fix-regtest-select-views-cleanup.patch
application/octet-stream
Filename: pgsql-v9.2-fix-regtest-select-views-cleanup.patch
Type: application/octet-stream
Part: 0
Message:
Re: [v9.2] Fix Leaky View Problem
Patch
Same data as JSON:
GET /api/v1/attachments/:id/patch
the parsed metadata as JSON — format, series position, per-file stats; never the diff bytes.
API reference →
Format: unified
Series: patch v9
| File | + | − |
|---|---|---|
| src/test/regress/expected/select_views_1.out | 18 | 0 |
| src/test/regress/expected/select_views.out | 18 | 0 |
| src/test/regress/sql/select_views.sql | 10 | 0 |
src/test/regress/expected/select_views.out | 18 ++++++++++++++++++ src/test/regress/expected/select_views_1.out | 18 ++++++++++++++++++ src/test/regress/sql/select_views.sql | 10 ++++++++++ 3 files changed, 46 insertions(+), 0 deletions(-) diff --git a/src/test/regress/expected/select_views.out b/src/test/regress/expected/select_views.out index 89dfcb1..3185a29 100644 --- a/src/test/regress/expected/select_views.out +++ b/src/test/regress/expected/select_views.out @@ -1502,3 +1502,21 @@ NOTICE: f_leak => hamburger 101 | alice | +81-12-3456-7890 | passwd123 (1 row) +-- +-- Cleanups +-- +RESET SESSION AUTHORIZATION; +DROP USER alice; +DROP TABLE customer CASCADE; +NOTICE: drop cascades to 8 other objects +DETAIL: drop cascades to constraint credit_card_cid_fkey on table credit_card +drop cascades to constraint credit_usage_cid_fkey on table credit_usage +drop cascades to view my_property_normal +drop cascades to view my_property_secure +drop cascades to view my_credit_card_normal +drop cascades to view my_credit_card_secure +drop cascades to view my_credit_card_usage_normal +drop cascades to view my_credit_card_usage_secure +DROP TABLE credit_card CASCADE; +DROP TABLE credit_usage CASCADE; +DROP FUNCTION f_leak (text) CASCADE; diff --git a/src/test/regress/expected/select_views_1.out b/src/test/regress/expected/select_views_1.out index c6f75af..149c864 100644 --- a/src/test/regress/expected/select_views_1.out +++ b/src/test/regress/expected/select_views_1.out @@ -1502,3 +1502,21 @@ NOTICE: f_leak => hamburger 101 | alice | +81-12-3456-7890 | passwd123 (1 row) +-- +-- Cleanups +-- +RESET SESSION AUTHORIZATION; +DROP USER alice; +DROP TABLE customer CASCADE; +NOTICE: drop cascades to 8 other objects +DETAIL: drop cascades to constraint credit_card_cid_fkey on table credit_card +drop cascades to constraint credit_usage_cid_fkey on table credit_usage +drop cascades to view my_property_normal +drop cascades to view my_property_secure +drop cascades to view my_credit_card_normal +drop cascades to view my_credit_card_secure +drop cascades to view my_credit_card_usage_normal +drop cascades to view my_credit_card_usage_secure +DROP TABLE credit_card CASCADE; +DROP TABLE credit_usage CASCADE; +DROP FUNCTION f_leak (text) CASCADE; diff --git a/src/test/regress/sql/select_views.sql b/src/test/regress/sql/select_views.sql index 4b2dac9..586043e 100644 --- a/src/test/regress/sql/select_views.sql +++ b/src/test/regress/sql/select_views.sql @@ -134,3 +134,13 @@ ALTER VIEW my_property_secure SET (security_barrier=false); SET SESSION AUTHORIZATION alice; EXECUTE p1; -- To be perform as a view with security-barrier EXECUTE p2; -- To be perform as a view without security-barrier + +-- +-- Cleanups +-- +RESET SESSION AUTHORIZATION; +DROP USER alice; +DROP TABLE customer CASCADE; +DROP TABLE credit_card CASCADE; +DROP TABLE credit_usage CASCADE; +DROP FUNCTION f_leak (text) CASCADE;