Re: Segmentation fault using digest from pg_crypto
| От | Manuel Sugawara |
|---|---|
| Тема | Re: Segmentation fault using digest from pg_crypto |
| Дата | |
| Msg-id | m3zm0gykf1.fsf@conexa.fciencias.unam.mx обсуждение исходный текст |
| Ответ на | Re: Segmentation fault using digest from pg_crypto ("Marko Kreen" <markokr@gmail.com>) |
| Ответы |
Re: Segmentation fault using digest from pg_crypto
|
| Список | pgsql-hackers |
"Marko Kreen" <markokr@gmail.com> writes: > On 8/24/07, Manuel Sugawara <masm@fciencias.unam.mx> wrote: >> Manuel Sugawara <masm@fciencias.unam.mx> writes: >> > I have a simple query that uses digest(data, 'sha1') and consistently >> > crashes the backend >> >> The problem is with null arguments: >> >> ciencias=# select digest(null, 'sha1'); > > In 8.0 the pgcrypto functions were non-strict and checked for NULLs. > > In 8.1 they were made STRICT. > > In 8.2 the NULL check were removed from code. Not an smart move IMHO, I didn't create the function, it was created as part of my upgrade process. May I suggest to put back the check?. Regards, Manuel.
В списке pgsql-hackers по дате отправления: