[postgis-tickets] [PostGIS] #5334: topology edge view doesn't need a rule to insert data
PostGIS
trac at osgeo.org
Mon Feb 6 17:33:27 PST 2023
#5334: topology edge view doesn't need a rule to insert data
----------------------+---------------------------
Reporter: robe | Owner: strk
Type: defect | Status: new
Priority: medium | Milestone: PostGIS 3.4.0
Component: topology | Version: master
Keywords: |
----------------------+---------------------------
I noticed that when I do this:
{{{
SELECT topology.CreateTopology('nyc_topo');
}}}
The nyc_topo.edge view has a INSERT rule. It doesn't even have an update
rule.
Views that draw from a single table where that table has a primary key,
are by default insertable and updatable. I think the change happened in
PostgreSQL 9.0. Anyway longer ago than any version we support.
I propose you just remove this insert rule. Not sure why you didn't have
an update rule to go along with it, unless there was a reason you didn't
want this table updated.
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5334>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.
More information about the postgis-tickets
mailing list