Can I refuse inserts/updates with timestamps without time-zone in postgresql?
Not sure if it is feasible in your case, but you could use functions for inserting data. Use a text parameter for the timestamp and throw an error if the string doesn't contain a + or -.