On Wed, 2011-04-13 at 14:42 -0400, Tom Lane wrote: > Simon Riggs <simon@xxxxxxxxxxxxxxx> writes: > > 2011/4/13 Tom Lane <tgl@xxxxxxxxxxxxx>: > >> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin