check_postgres
check_postgres copied to clipboard
--same-schema check does not check indexes
ID: 54 Version: unspecified Date: 2010-11-19 05:11 EST Author: Aleksey Tsalolikhin ([email protected])
Hi. First of all, thanks for a great and most useful tool!
Secondly, we've just discovered that --same-schema check misses indexes.
We have some indexes that don't involve primary key constraints, and --same-schema check fails to report differences between tables if database A has a table with 1 index, and database B has that same table with 2 indexes. The 2nd index does not involve primary key constraints.
Thanks again for a great tool!
Yours truly, Aleksey