From: | Ramesh T <rameshparnanditech(at)gmail(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | pgcrypto |
Date: | 2015-09-23 15:46:33 |
Message-ID: | CAK8Zd=sn8C_w-xmU3qpOmODQg0zLNDsKBKKqaxzwPpA=Y10WLQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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;
it return error;
when i install pgcrypto using postgres user on qa,installed all pgcrypto
function placed in qa function it looks confused.
what should i do how to access the pgcrypto of public and we need to create
extension on each schema..??
From | Date | Subject | |
---|---|---|---|
Next Message | Daniel Begin | 2015-09-23 15:50:50 | PostgreSQL and Windows 10 upgrade |
Previous Message | Alvaro Herrera | 2015-09-23 15:26:06 | Re: The curious case of two inserts, a shrinking xmax, and a ShareLock on transaction |