On 11/29/07, Stefan Niantschur <[EMAIL PROTECTED]> wrote:
> SELECT
> pgp_pub_decrypt(dearmor(armor(pgp_pub_encrypt(armor(pgp_sym_encrypt('geheim'::text,'test'::text)),dearmor((SELECT
> ens_pubkey FROM ens_user WHERE ens_userid =
> 10112)::text,dearmor((SELECT ens_privkey FROM ens_user WHERE
> e
Am Montag, 3. Dezember 2007 schrieben Sie:
> On 12/3/07, Stefan Niantschur <[EMAIL PROTECTED]> wrote:
> > I finally made it. I created a brand-new key, reworked the query and
> > voila.
> >
> > It seems that the GnuPG key has to be created with
> > paramter --cipher-algo=blowfish before it can be u
On 12/3/07, Stefan Niantschur <[EMAIL PROTECTED]> wrote:
> I finally made it. I created a brand-new key, reworked the query and voila.
>
> It seems that the GnuPG key has to be created with
> paramter --cipher-algo=blowfish before it can be used together with pgcrypto.
> The generated key with the
Am Montag, 3. Dezember 2007 schrieb Marko Kreen:
Hi Marko,
I finally made it. I created a brand-new key, reworked the query and voila.
It seems that the GnuPG key has to be created with
paramter --cipher-algo=blowfish before it can be used together with pgcrypto.
The generated key with the def
On 12/3/07, Stefan Niantschur <[EMAIL PROTECTED]> wrote:
> > Or at least send key parameters (gpg --list-keys output).
>
> pub 1024D/0476AD06 2007-11-27 [verfällt: 2008-11-26]
> uid Test User (Probebenutzer) <[EMAIL PROTECTED]>
> sub 2048g/879D6C41 2007-11-27 [verfällt: 2008-11-26]
Elgamal 2048 wo
Am Fri, 30 Nov 2007 12:06:37 +0200
schrieb "Marko Kreen" <[EMAIL PROTECTED]>:
Hi Marko,
first of all, thank you for your help.
Please find my answers below:
> On 11/29/07, Stefan Niantschur <[EMAIL PROTECTED]> wrote:
> > I have a table with userids and public keys. I want to write a
> > functio
On 11/29/07, Stefan Niantschur <[EMAIL PROTECTED]> wrote:
> I have a table with userids and public keys. I want to write a function
> which does a select and returns the result pgp encrypted.
>
> However, I have some problems:
Could you send the keys you have problems with? If actual keys
then of
Hi,
I have a table with userids and public keys. I want to write a function
which does a select and returns the result pgp encrypted.
However, I have some problems:
SELECT encode(decode((SELECT ens_pubkey FROM
ens_user)::text,'escape'),'escape'::text)::text;
-> returns the public key, => ok
SELE
