I have a table of points, and I set some time ago a simple unique constraint as such :
ALTER TABLE points ADD CONSTRAINT points_geom_key UNIQUE (geom);
It generally worked fine, until now that I face a weird behaviour. I tried to directly copy/paste some points through QGIS with the copy/paste of entities, as I am generally doing, but got an error saying the constraint is not being respected. Long story short : I have two points that are nowher near each other, for which the geom field looks totally different.
I guess this is not the way to check for the unicity of the geom, so what would be the proper way?
I run PostgreSQL 9.4 and PostGIS 2.2