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