Could it be that integrating the oid into the view would make a difference?
Christine
Am 04.02.2021 um 06:55 schrieb Michael Steigemann via Geoserver-users:
Good Morning!
From the documentation
https://docs.geoserver.org/stable/en/user/data/database/sqlview.html
it is obvious that a layer based on a SQL-View is read only.
Therefore I created an editable view directly in Postgres and
registered it as a normal layer in Geoserver. Unfortunately I still
get the following error message:
2021-02-04 06:43:50,104 ERROR [geoserver.ows] -
org.geoserver.wfs.WFSTransactionException:
{mist}update_my_media_objects is read-only
at org.geoserver.wfs.Transaction.execute(Transaction.java:241)
at org.geoserver.wfs.Transaction.transaction(Transaction.java:93)
at
org.geoserver.wfs.DefaultWebFeatureService.transaction(DefaultWebFeatureService.java:147)
Is there any workaround? I want to achieve that a user can only edit
his own records in GeoServer. Therefore I filter in the view for the
logged in user:
create or replace view update_my_media_objects as select * from
media_objects where owner_uid = current_setting('current.user', TRUE);
Thanks and all the best,
Michael
_______________________________________________
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
--
Christine Andrae
Schopenhauerstraße 9
59174 Kamen
c.andrae.ka...@gmail.com
_______________________________________________
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
