The following bug has been logged on the website:
Bug reference: 10870
Logged by: Ramesh
Email address: rameshparnanditech@gmail.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..