Re: Crash in pgCrypto? - Mailing list pgsql-hackers

On 6/16/08, Mario Weilguni <mweilguni@sime.com> wrote:
> Could someone using the pgcrypto extension please verify this?
>
>  SELECT encode(digest(null, 'md5'::text), 'hex');
>  or
>  SELECT digest(null, 'md5');
>
>  Takes a few seconds, and then crashes the server with a Signal 11. My
> system is PostgreSQL 8.2.7. Seems to be an unchecked access to memory
> location 0.

Seems you loaded pgcrypto function signatures from dump (from 8.0).
http://marc.info/?l=postgresql-general&m=118794006505296&w=2

Recreate the functions with pgcrypto.sql.

-- 
marko