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