Re: MD5 aggregate - Mailing list pgsql-hackers

From Dean Rasheed
Subject Re: MD5 aggregate
Date
Msg-id CAEZATCUJKKw6jRz1iCOo3vOjs-y82G1Ew9amXTp4C-A-+bcjKA@mail.gmail.com
Whole thread Raw
In response to Re: MD5 aggregate  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: MD5 aggregate
List pgsql-hackers
On 26 June 2013 21:46, Peter Eisentraut <peter_e@gmx.net> wrote:
> On 6/26/13 4:04 PM, Dean Rasheed wrote:
>> A quick google search reveals several people asking for something like
>> this, and people recommending md5(string_agg(...)) or
>> md5(string_agg(md5(...))) based solutions, which are doomed to failure
>> on larger tables.
>
> The thread discussed several other options of checksumming tables that
> did not have the air of a crytographic offering, as Noah put it.
>

True but md5 has the advantage of being directly comparable with the
output of Unix md5sum, which would be useful if you loaded data from
external files and wanted to confirm that your import process didn't
mangle it.

Regards,
Dean



pgsql-hackers by date:

Previous
From: Dean Rasheed
Date:
Subject: Re: MD5 aggregate
Next
From: Hitoshi Harada
Date:
Subject: Re: in-catalog Extension Scripts and Control parameters (templates?)