The following bug has been logged on the website:
Bug reference: 8295
Logged by: Dek
Email address: dek.mauleon@gmail.com
PostgreSQL version: 9.2.4
Operating system: windows server 2008 R2 standard SP1 64 bit
Description:
crypt function fails with does not exist. This happens randomly and trying
the same command again works.
Verbose Error log:
2013-07-11 12:33:42 CDT LOCATION: pq_recvbuf,
src\backend\libpq\pqcomm.c:839
2013-07-11 12:35:14 CDT ERROR: 42888: function crypt(character varying,
character varying) does not exist at character 80
2013-07-11 12:35:14 CDT HINT: No function matches the given name and
argument types. You might need to add explicit type casts.
2013-07-11 12:35:14 CDT LOCATION: ParseFuncOrColumn,
src\backend\parser\parse_func.c:304
2013-07-11 12:35:14 CDT STATEMENT: select count(*) ct from root.sysuser
where user_id = 115 and (user_login_pwd = crypt('testpass'::character
varying, user_login_pwd)) = true
Running the same command again works:
brazil=# select count(*) ct from root.sysuser where user_id = 115 and
(user_login_pwd = crypt('testpass'::character varying, user_login_pwd)) =
true;
ct
----
0
(1 row)
extension pgcrypto is installed via create extension pgcrypto.
Thanks.