pgcrypto

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..??

Responses

Browse pgsql-general by date

  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