PostgreSQL 15.2, PostGIS 3.3.2
I create a view which has geometry column composed of raw coordinates. I explicitly set the SRID. However, in geometry_columns view the SRID value is 0 for that view. How else can I force the SRID value?
CREATE VIEW a_view AS ( ... st_setsrid(st_makeline(ARRAY[st_makepoint(x1,y1), st_makepoint(x2,y2), st_makepoint(x3,y3)]), 3301) AS geometry ...
(Other views that reference geometries from tables get their SRID derived correctly.)