Mario Weilguni 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.
I think the functions were made STRICT recently, and the NULL checks were removed, but people with the old definitions of the functions could see the crashes. Try removing pgcrypto and recompiling it from a fresh release. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers