On Thu, Jul 24, 2014 at 03:06:28PM +0100, m...@byrney.com wrote:
> > select md5(string_agg(md5(c::text), '' order by md5(c::text))) from
> > pg_class c;
> >
> > (of course you can do it on any table, not only pg_class).
> >
> > If you want to use the xor idea (which make sense), all you need is to
On Thu, Jul 24, 2014 at 01:43:29PM +0200, hubert depesz lubaczewski wrote:
> > 1. Should this be a contrib module which provides a function, or should it
> > be a built-in piece of functionality?
> > 2. Is MD5 too heavyweight for this? Would using a non-cryptographic
> > checksum be worth the spe
> On Thu, Jul 24, 2014 at 3:35 AM, wrote:
>
>> I have a suggestion for a table checksumming facility within PostgreSQL.
>> The applications are reasonably obvious - detecting changes to tables,
>> validating data migrations, unit testing etc. A possible algorithm is
>> as
>> follows:
>>
>> 1. For
On Thu, Jul 24, 2014 at 3:35 AM, wrote:
> I have a suggestion for a table checksumming facility within PostgreSQL.
> The applications are reasonably obvious - detecting changes to tables,
> validating data migrations, unit testing etc. A possible algorithm is as
> follows:
>
> 1. For each row of
I have a suggestion for a table checksumming facility within PostgreSQL.
The applications are reasonably obvious - detecting changes to tables,
validating data migrations, unit testing etc. A possible algorithm is as
follows:
1. For each row of the table, take the binary representations of the
v