I try to reproject a layer in PosGIS using statement:
UPDATE <table> SET geom=ST_Transform(geom, 3857);
leading to error message:
ERROR: transform: couldn't project point (574415 6.22508e+006 0): latitude or longitude exceeded limits (-14)
SQL state: XX000
I thought the first number in the error message corresponds with the id (line number) in the table, but when I retrieve ST_X and ST_Y from that point then the coordinates do not correspond to the second and third number in the error message.
The projection so far is 4326 and a visual control in ArcMap doesn't show any unexpected points.
Can you tell me on how to read the error message and to overcome the issue?