On Wed, 2011-04-13 at 14:42 -0400, Tom Lane wrote:
> Simon Riggs <simon@2ndQuadrant.com> writes:
> > 2011/4/13 Tom Lane <tgl@sss.pgh.pa.us>:
> >> Short answer is to test the case you have in mind and see.
>
> > That's the long answer, not least because the absence of a failure in
> > a test is not conclusive proof that it won't fail at some point in the
> > future while in production.
>
> Not really. Every known source of incompatibility (endianness,
> alignment, float format, etc) is checked at postmaster startup via
> entries in pg_control.
I seem to remember that Mac and Linux have a different notion of what
en_US collation means (I couldn't find any standard anywhere to say that
one was right and the other was wrong). So, that risks index corruption.
Regards,
Jeff Davis