howto use pgencrypto ?
| От | David H |
|---|---|
| Тема | howto use pgencrypto ? |
| Дата | |
| Msg-id | 20031205051049.42647.qmail@web40509.mail.yahoo.com обсуждение исходный текст |
| Ответы |
Re: howto use pgencrypto ?
|
| Список | 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/
В списке pgsql-novice по дате отправления: