PostGIS : Update a POINT (geometry) with a POINT from another table with the same SRID

Question

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.

Example:

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;

Answer 1

I had a trigger that updated the geo column with:

position_geo = ST_SetSRID(ST_MakePoint(NEW.lng,NEW.lat), 4326)

when updating lat and lng. That's preventing from updating the column.