On Wed, Sep 23, 2015 at 8:46 AM, Ramesh T <[email protected]>
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
