I was getting this same error when using ST_INTERSECTION, turns out the datasets had a different spatial reference. Both datasets had the same coordinate system according to ArcCatalog, but when queried with ST_SRID I was getting different numbers. ST_INTERSECTS did not have a problem with the discrepancy, but ST_INTERSECTION did. Adding ST_TRANSFORM to get the numbers matching seems to have solved the problem. Hope this helps somebody in the future.
... View more