Re: MD5 aggregate - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: MD5 aggregate
Date
Msg-id 51CB533A.6070603@gmx.net
Whole thread Raw
In response to Re: MD5 aggregate  (Dean Rasheed <dean.a.rasheed@gmail.com>)
Responses Re: MD5 aggregate
List pgsql-hackers
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.

> So I think that there is a case for having md5_agg()
> in core as an alternative to such hacks, while having more
> sophisticated crypto functions available as extensions.

Well, in general, I'd rather see the sophisticated stuff in core and the
hacks in extensions.



pgsql-hackers by date:

Previous
From: Jeff Janes
Date:
Subject: Re: A better way than tweaking NTUP_PER_BUCKET
Next
From: Szymon Guz
Date:
Subject: Re: [PATCH] Fix conversion for Decimal arguments in plpython functions