Fix migrations compatibility with new versions of postgresql

This is rebased version of !200 (closed) since a lot of people seem to be facing this issue, just to speed this up.

Thanks to Mark van Holsteijn for the fix! This MR just adds a NEWS entry on the top.

Fixes #266 (closed)