pg_tde_delete_key_provider is not working for 2nd/3rd time
General
Escalation
General
Escalation
Description
Environment
None
Activity
Show:
shahidullah.khan 2 days ago
This issue is fixed now. Verified with Commit ID: c72b4c361867bf6a52fd2834eb2a105311a66079
Done
Details
Details
Assignee
shahidullah.khan
shahidullah.khanReporter
shahidullah.khan
shahidullah.khanNeeds QA
Yes
Story Points
1
Components
Fix versions
Priority
Smart Checklist
Open Smart Checklist
Smart Checklist

Open Smart Checklist
Created last week
Updated 2 days ago
Resolved 2 days ago
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"}