Re: pgcrypto

On Wed, Sep 23, 2015 at 8:46 AM, Ramesh T <rameshparnanditech(at)gmail(dot)com>
wrote:

> Hi,
> i created extension pgcrypto on public with postgres user.But
> while trying to use from my own schma suppose qa.
>
> when i run digest in function in my qa
>
> CREATE OR REPLACE FUNCTION sha1(bytea) returns text AS $$
> SELECT encode(digest($1, 'sha1'), 'hex')
> $$ LANGUAGE SQL STRICT IMMUTABLE;
>

If "public" is not in your search_path, then you need to schema-qualify the
name of the function when you use it:

CREATE OR REPLACE FUNCTION sha1(bytea) returns text AS $
SELECT encode(public.digest($1, 'sha1'), 'hex')
$ LANGUAGE SQL STRICT IMMUTABLE;

It is a good idea to do that anyway.

Cheers,

Jeff