You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The "center" column generated by the Draw Tool cannot be edited from the attribute table editor.
This is due to the format of the column in the database which is an array of float8.
Array type is not supported in the editor and should be implemented.
To reproduce, you must:
create a new polygon layer with the Draw Tool
add a new circle
import this new layer into the MapX database
open the attribute table editor
try to change the value of the "center" column
The text was updated successfully, but these errors were encountered:
In my local database, I have found about 27 occurrences of an 'ARRAY' type in columns in uploaded PostGIS layers.
SELECTt.table_name,
t.column_name,
t.data_type,
t.udt_name,
s.idAS layer_name
FROMinformation_schema.columns t
JOIN
mx_sources s
ONt.table_name=s.idWHEREt.udt_nameLIKE'%_array%'-- Filter for array typesORt.data_type='ARRAY'-- This checks for array types explicitlyORDER BYt.table_name,
t.column_name;
The proposed solution is to work upstream by checking each uploaded table and layer to see if any columns have been converted into PostgreSQL arrays. Then, we could write a post-process script to convert those columns into the JSONB type, which is supported by the table editor. Or just support the ARRAY type in the table editor. To be tested..
Another option would be to use a trigger on table creation, but that would affect all future tables, not only non-spatial mapx tables and PostGIS layers (mx_sources).
The "center" column generated by the Draw Tool cannot be edited from the attribute table editor.
This is due to the format of the column in the database which is an array of float8.
Array type is not supported in the editor and should be implemented.
To reproduce, you must:
The text was updated successfully, but these errors were encountered: