I am unable to update the layer configuration of a PostGIS geoserver layer.
1. I am adding a new column to the existing and published PostGIS table
in the first step.
2. However, the geoserver automatically doesn't reflect the changes made
to the layer. We need to manually do it through the geoserver admin
interface using the "Reload feature type" option (image below) or automate
it through the geoserver rest API.
[image: gs_question.png]
1. The Python code for updating layer configuration through rest-API is
given below.
```
session = requests.Session()
session.auth = (username, password)
layer_url_json =
f"{geoserver_url_dL}/workspaces/{workspace_dL}/datastores/{store}/featuretypes/{layer_name}.json"
response1 = session.get(layer_url_json)
layer_info = response1.json()#print(layer_info)
new_column = {
"name": "type12",
"type": "Boolean", # Set the data type for the new column
"nillable":True,
"minOccurs": 0, # Optional: Minimum occurrences
"maxOccurs": 1 # Optional: Maximum occurrences
}
layer_info['featureType']['attributes']['attribute'].append(new_column)
response2 = session.put(layer_url_json, headers={'Content-type':
'application/json'},
```
The above code was working perfectly in geoserver-2.20.0 and the changes to
layer configuration are being reflected.
However, I am getting a 500 error for response2 with the text "The CQL
source expression for attribute type12 refers to attributes unavailable in
the data source: [type12]" in later versions of geoserver like
geoserver-2.23, 2.24, 2.25-SNAPSHOT
I tried to verify the PostGIS table and the column is already added to the
table, and the rest-api interactions with geoserver 2.23-SNAPSHOT are
working fine as i was able to retrieve "layer_info" and also successfully
tested adding a new workspace using rest-api in this version.
Unfortunately, I can't fix this error. Is this my code error specific to
the version of the geoserver or is it a geoserver bug?
--
Thanks and Regards,
Sriharsha Yegireddi
_______________________________________________
Geoserver-users mailing list
Please make sure you read the following two resources before posting to this
list:
- Earning your support instead of buying it, but Ian Turton:
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html
If you want to request a feature or an improvement, also see this:
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
