BUG #10870: digest crypto function

Поиск
Список
Период
Сортировка
Искать
От
rameshparnanditech@gmail.com
Тема
BUG #10870: digest crypto function
Дата
Msg-id
20140705150443.2542.16295@wrigleys.postgresql.org
Список
Дерево обсуждения
BUG #10870: digest crypto function rameshparnanditech@gmail.com
Re: BUG #10870: digest crypto function hubert depesz lubaczewski <depesz@gmail.com>
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..
В списке pgsql-bugs по дате отправления
От: Tom Lane
Дата:
От: hubert depesz lubaczewski
Дата:
FAQ