| 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: | Whole Thread | Raw Message | 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 |