[postgis-tickets] [PostGIS] #3766: geometry_columns and raster_columns views do not list parent partitioned tables of PostgreSQL 10

PostGIS trac at osgeo.org
Sat May 27 09:04:06 PDT 2017


#3766: geometry_columns and raster_columns views do not list parent partitioned
tables of PostgreSQL 10
----------------------+---------------------------
  Reporter:  robe     |      Owner:  robe
      Type:  defect   |     Status:  assigned
  Priority:  blocker  |  Milestone:  PostGIS 2.4.0
 Component:  postgis  |    Version:  trunk
Resolution:           |   Keywords:  postgresql 10
----------------------+---------------------------

Comment (by robe):

 Okay it looks like our raster_columns and geometry_columns do a
 pg_class.relkind check while geography does not and partitioned tables are
 of relkind = 'p', a new kind of relkind beast.

 If I take the relkind check out, I get stuff that aren't tables like
 raster helper types and geometry helper types.  So we need the check and
 should probably have it for geography as well.  We just don't happen to
 have any geography helper types that contain geography as a subcomponent,
 but if we introduce ST_Dump for geography, that would change.

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3766#comment:3>
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