howto use pgencrypto ?

From: David H <godave621(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: howto use pgencrypto ?
Date: 2003-12-05 05:10:49
Message-ID: 20031205051049.42647.qmail@web40509.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

I have installed pgencrypot so I think...
I ran make checkinstall I got:

============== installing PL/pgSQL
==============
============== running regression test queries
==============
test init ... ok
test md5 ... ok
test sha1 ... ok
test hmac-md5 ... ok
test hmac-sha1 ... ok
test blowfish ... ok
test rijndael ... ok
test crypt-des ... ok
test crypt-md5 ... ok
test crypt-blowfish ... ok
test crypt-xdes ... ok

======================
All 11 tests passed.
======================

But when I ran:

select encrypt
('srcip'::bytea,'pass'::bytea,'bf'::text)::bytea as
"test" from tbltcplog limit 3;

I got:

ERROR: Function encrypt(bytea, bytea, text) does not
exist
Unable to identify a function that satisfies
the given argument types
You may need to add explicit typecasts

Please help!!!!
Thanks,
Dave

__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Joe Conway 2003-12-05 06:23:50 Re: howto use pgencrypto ?
Previous Message Michael Grant 2003-12-05 04:34:46 Re: OT: Re: Environment variables SOLVED