[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