BUG #10870: digest crypto function

From: rameshparnanditech(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #10870: digest crypto function
Date: 2014-07-05 15:04:43
Message-ID: 20140705150443.2542.16295@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 10870
Logged by: Ramesh
Email address: rameshparnanditech(at)gmail(dot)com
PostgreSQL version: 9.3.3
Operating system: windows 7
Description:

HI,
I am new postgres,i have a problem with digest function.

i ran create extension pgcrypto; as super user

here ,logged in as super user
postgres=#select digest('hi','sha1');
digest
--------
3xc232ccc323

i created devl database and user ramesh other then super user..

when i try same statement with diffrent users i'm not able to run ..
its return error like this way
ramesh=# select digest('hi','sha1')
ramesh-# ;
ERROR: function digest(unknown, unknown) does not exist
LINE 1: select digest('hi','sha1')
^
HINT: No function matches the given name and argument types. You might need
to
add explicit type casts.

but super user its working correct..please let me know how to solve this
issue..

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Mahesh Narawade 2014-07-06 06:54:35 Postgresql database error in data retrive
Previous Message Tom Lane 2014-07-05 14:46:06 Re: BUG #10856: Delete trigger corrupts foreign key integrity