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/
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 |