Eliminate overlaps and gaps between polygons in a layer (with QGis and Postgis)

For those unfamiliar with the joys of working with the French cadastre, you should know that if you have the opportunity to work with cadastral data corresponding to “Lieux-dits” (a subdivision of communes) you’ll find that…