BUG #10870: digest crypto function
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..
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
On Sat, Jul 5, 2014 at 5:04 PM, <rameshparnanditech@gmail.com> wrote:
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
Please note that you created it and used in database named "postgres".
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')
^
And you can't use it in another database, because you created it in
"postgres" and not "ramesh". Just like tables, views, indexes - functions
also belong to database.
Just connect to ramesh database as postgres user (superuser), create
extension pgcrypto, and you'll be set.
Also - this is not a bug in PostgreSQL - please post to pgsql-general or
pgsql-novice.
depesz