[BUGS] about pgcrypto, not support "des"

Поиск
Список
Период
Сортировка
От pengchong
Тема [BUGS] about pgcrypto, not support "des"
Дата
Msg-id tencent_3591DC466BBBB4D66F26AC11@qq.com
обсуждение исходный текст
Ответы Re: [BUGS] about pgcrypto, not support "des"  (Lou Picciano <LouPicciano@comcast.net>)
Список pgsql-bugs
hello,everybody:

psql.bin (9.5.9)
Type "help" for help.

dafc=> \dx pgcrypto 
             List of installed extensions
   Name   | Version | Schema |       Description       
----------+---------+--------+-------------------------
 pgcrypto | 1.2     | public | cryptographic functions
(1 row)


dafc=> select digest('test','des');
ERROR:  Cannot use "des": No such hash algorithm

uname -a
Linux ic-test.hadoop 2.6.32-131.0.15.el6.x86_64 #1 SMP Tue May 10 15:42:40 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux

openssl version
OpenSSL 1.1.0e  16 Feb 2017

pg_config 
BINDIR = /opt/PostgreSQL/9.5/bin
DOCDIR = /opt/PostgreSQL/9.5/doc/postgresql
HTMLDIR = /opt/PostgreSQL/9.5/doc/postgresql
INCLUDEDIR = /opt/PostgreSQL/9.5/include
PKGINCLUDEDIR = /opt/PostgreSQL/9.5/include/postgresql
INCLUDEDIR-SERVER = /opt/PostgreSQL/9.5/include/postgresql/server
LIBDIR = /opt/PostgreSQL/9.5/lib
PKGLIBDIR = /opt/PostgreSQL/9.5/lib/postgresql
LOCALEDIR = /opt/PostgreSQL/9.5/share/locale
MANDIR = /opt/PostgreSQL/9.5/share/man
SHAREDIR = /opt/PostgreSQL/9.5/share/postgresql
SYSCONFDIR = /opt/PostgreSQL/9.5/etc/postgresql
PGXS = /opt/PostgreSQL/9.5/lib/postgresql/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--enable-debug' '--with-libs=/opt/local/Current/lib' '--with-includes=/opt/local/Current/include/libxml2:/opt/local/Current/include' '--prefix=/mnt/hgfs/pginstaller.auto/server/staging/linux-x64.build' '--with-ldap' '--with-openssl' '--with-perl' '--with-python' '--with-tcl' '--with-tclconfig=/opt/local/EnterpriseDB/LanguagePack/9.5/Tcl-8.5/lib' '--with-pam' '--enable-thread-safety' '--with-libxml' '--with-ossp-uuid' '--docdir=/mnt/hgfs/pginstaller.auto/server/staging/linux-x64.build/doc/postgresql' '--with-libxslt' '--with-libedit-preferred' '--with-gssapi' 'LD_LIBRARY_PATH=/opt/local/Current/lib' 'CFLAGS=-O2 -DMAP_HUGETLB=0x40000'
CC = gcc
CPPFLAGS = -D_GNU_SOURCE -I/opt/local/Current/include/libxml2 -I/opt/local/Current/include
CFLAGS = -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -g -O2 -DMAP_HUGETLB=0x40000
CFLAGS_SL = -fPIC
LDFLAGS = -L../../../src/common -L/opt/local/Current/lib -Wl,--as-needed -Wl,-rpath,'/mnt/hgfs/pginstaller.auto/server/staging/linux-x64.build/lib',--enable-new-dtags
LDFLAGS_EX = 
LDFLAGS_SL = 
LIBS = -lpgcommon -lpgport -lxslt -lxml2 -lpam -lssl -lcrypto -lgssapi_krb5 -lz -ledit -lrt -lcrypt -ldl -lm 
VERSION = PostgreSQL 9.5.9



------------------

彭冲

天津通卡智能网络科技股份有限公司/国际事业部

天津


声明:本邮件及其附件所包含的信息属天津通卡智能网络科技股份有限公司、或者与天津通卡智能网络科技股份有限公司往来客户的商业秘密,仅限于发给上面的人或群组。在未经许可的情况下,其他人请不要以任何方式使用。如果您错收了本邮件,烦请立即告知发件人,并永久性删除本邮件以及附件的所有原始文件、复制件和输出件,请勿保存、复制、利用和泄露本邮件及附件的任何内容,以确保您无需为此承担法律责任。

 

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [BUGS] BUG #14813: pg_get_serial_sequence does not return seqence name for IDENTITY columns
Следующее
От: pfcovello@gmail.com
Дата:
Сообщение: [BUGS] BUG #14814: Documentation errors for OpenBSD