Re: Crash in pgCrypto?

Marko Kreen schrieb:
> On 6/16/08, Mario Weilguni <mweilguni(at)sime(dot)com> wrote:
>
>> Marko Kreen schrieb:
>>
>>> 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.
>>>
>>>
>> Yes, this is what I did, and it happened during update from 8.0 --> 8.2.
>> But that brings me to another problem, what is the best way to create
>> backups with pgdump so that stuff from contrib is not dumped, but recreated
>> from the newer version?
>>
>
> Good question... Seems the proper support for modules will not
> leave todo-list any time soon.
>
> Only way that works now is to add any module .sql to template0, so
> they would not be dumped out. So you are forced to recreate them
> properly on newer version. (By adding them to template0 again.)
>
>
Is this todo-list something I can find online?

Best regards
Mario Weilguni