I have a postgis table that is edited from different sources.
The points added from Source 1 are in SRID 23030.
The points added from Soruce 2 are in SRID 4230.
I want all the points in the table to be stored in SRID 23030.
I can create a trigger and st_transform(the_geom,23030) all NEW.the_geom but i was wondering is this is the easiest way to achieve this.
Maybe i can create a CONSTRAINT or something that reprojects (st_transforms) every point if SRID it's not in 23030 or something like that?