On 6/16/08, Mario Weilguni <mweilguni(at)sime(dot)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