5
select pgp_key_id(dearmor(pubkey)) from keytbl where id=1;
11
select pgp_key_id(dearmor(pubkey)) from keytbl where id=2;
17
select pgp_key_id(dearmor(pubkey)) from keytbl where id=3;
23
select pgp_key_id(dearmor(pubkey)) from keytbl where id=4; -- should fail
24
ERROR: No encryption key found
25
select pgp_key_id(dearmor(pubkey)) from keytbl where id=5;
31
select pgp_key_id(dearmor(pubkey)) from keytbl where id=6;
37
select pgp_key_id(dearmor(seckey)) from keytbl where id=1;
43
select pgp_key_id(dearmor(seckey)) from keytbl where id=2;
49
select pgp_key_id(dearmor(seckey)) from keytbl where id=3;
55
select pgp_key_id(dearmor(seckey)) from keytbl where id=4; -- should fail
56
ERROR: No encryption key found
57
select pgp_key_id(dearmor(seckey)) from keytbl where id=5;
63
select pgp_key_id(dearmor(seckey)) from keytbl where id=6;
69
select pgp_key_id(dearmor(data)) as data_key_id
70
from encdata order by id;