Create a check constraint across multiple schemas in PostGIS
You need a trigger that runs on UPDATE and INSERT (when a row would otherwise be modified). As a-horse-with-no-name said in a comment:


  Not possible. A check constraint can only validate column values of one row in one table.