pg_tde_delete_key_provider is not working for 2nd/3rd time

Description

pg_tde_delete_key_provider('provider_name') is not working for 2nd/3rd time.
Steps to reproduce the issue.


db1=# create extension pg_tde ; CREATE EXTENSION db1=# SELECT pg_tde_add_key_provider_file('db1-provider1','/tmp/pg_tde_test_db11.per'); pg_tde_add_key_provider_file ------------------------------ 1 (1 row) db1=# SELECT pg_tde_delete_key_provider('db1-provider1'); pg_tde_delete_key_provider ---------------------------- (1 row) db1=# SELECT * FROM pg_tde_list_all_key_providers(); id | provider_name | provider_type | options ----+---------------+---------------+--------- (0 rows) db1=# SELECT pg_tde_add_key_provider_file('db1-provider2','/tmp/pg_tde_test_db12.per'); pg_tde_add_key_provider_file ------------------------------ 2 (1 row) db1=# SELECT pg_tde_delete_key_provider('db1-provider2'); pg_tde_delete_key_provider ---------------------------- (1 row) db1=# SELECT * FROM pg_tde_list_all_key_providers(); id | provider_name | provider_type | options ----+---------------+---------------+--------------------------------------------------------- 2 | db1-provider2 | file | {"type" : "file", "path" : "/tmp/pg_tde_test_db12.per"}

Environment

None

Activity

Show:

shahidullah.khan 2 days ago

This issue is fixed now. Verified with Commit ID: c72b4c361867bf6a52fd2834eb2a105311a66079

Done

Details

Assignee

Reporter

Needs QA

Yes

Story Points

Components

Fix versions

Priority

Smart Checklist

Created last week
Updated 2 days ago
Resolved 2 days ago

Flag notifications