I try to update a geometry point with data from another table (also a geometry point). Both are SRID 4326. The query is executing without errors, everything is updated but the geometry is just not updated.
Do I have to transform first to lat lng and then back again? Is it not possible to use a geometry type? I don't get it at the moment.
UPDATE location SET location_name = import_ogr.location_name, location_category_id = import_ogr.location_category_id::INTEGER, position_geo = import_ogr.wkb_geometry FROM importexport.import_ogr WHERE location.location_id = 23017;