/
githubmirror
/
postgres
Обзор
Документация
Войти
/
githubmirror
/
postgres
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
contrib/pgcrypto/sql/crypt-des.sql
27 строк
685 B
Daniel Gustafsson
pgcrypto: Make it possible to disable built-in crypto
24 янв 2025, 16:25
24 янв 2025, 16:25
035f99c
Код
Авторство
О чём код?
-- -- crypt() and gen_salt(): crypt-des -- SELECT crypt('', 'NB'); SELECT crypt('foox', 'NB'); -- We are supposed to pass in a 2-character salt. -- error since salt is too short: SELECT crypt('password', 'a'); CREATE TABLE ctest (data text, res text, salt text); INSERT INTO ctest VALUES ('password', '', ''); UPDATE ctest SET salt = gen_salt('des'); UPDATE ctest SET res = crypt(data, salt); SELECT res = crypt(data, res) AS "worked" FROM ctest; -- check disabling of built in crypto functions SET pgcrypto.builtin_crypto_enabled = off; UPDATE ctest SET salt = gen_salt('des'); UPDATE ctest SET res = crypt(data, salt); RESET pgcrypto.builtin_crypto_enabled; DROP TABLE ctest;