[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