[postgis-users] Updating PostGIS views from Geoserver

Paragon Corporation lr at pcorp.us
Tue Feb 17 15:27:49 PST 2009

I'm not sure if this is the best list to try, but hoping someone may have a
solution to this and since I'm not on the geoserver list, figured I would
try this one first.

In one of the projects we have,  we have a PostgreSQL view with update,
insert, select rules on it.  I am told that geoserver sees this as a
read-only table since it can't see the indexes on it.

Is this a limitation of Geoserver and if so is there a workaround around

The main reason we need the view is that we are trying to retrieve
information and update a field in another table from data inserted/updated
in the view so need these virtual fields to be present.

I played around with the idea of creating a real table that mirrors the
structure of the view and putting an instead of select rule on the table,
but I guess this is not legal if a table has indexes which would seem to
defeat the purpose since it would make the table equally unattractive to


More information about the postgis-users mailing list