Re: Hosting without pgcrypto functions. There are other solutions?
От
Merlin Moncure
Тема
Re: Hosting without pgcrypto functions. There are other
solutions?
Дата
Msg-id
AANLkTil5XV0Ys4b-umVogzO4MnMi5r1bGz0sTs7VUDJF@mail.gmail.com
Ответ на
Список
Дерево обсуждения
Hosting without pgcrypto functions. There are other solutions? Andre Lopes <lopes80andre@gmail.com>
Re: Hosting without pgcrypto functions. There are other
solutions? Merlin Moncure <mmoncure@gmail.com>
Re: Hosting without pgcrypto functions. There are other solutions? John Gage <jsmgage@numericable.fr>
On Sun, Jun 13, 2010 at 4:37 PM, Andre Lopes wrote:
> Hi,
>
> I have an account in A2Hosting.com, and I'm developing some functions that
> deal with encryption.
>
> A2Hosting.com don't have available the function "digest()"
>
> [code]
> ERROR: function digest(unknown, unknown) does not exist
> LINE 1: select digest('ffff', 'sha1')
I bet the crypto library is built/installed -- you just need to
install the functions. Try this:
CREATE OR REPLACE FUNCTION digest(text, text)
AS '$libdir/pgcrypto', 'pg_digest'
If that fails then start thinking about plan 'B'.
merlin
В списке pgsql-general по дате отправления
От: Greg Smith
Дата: