[postgis-devel] [PostGIS] #862: Topology: the topology.DropTopology() drop any type of schemas

PostGIS trac at osgeo.org
Wed Apr 13 23:32:35 PDT 2011

#862: Topology: the topology.DropTopology() drop any type of schemas
 Reporter:  aperi2007  |       Owner:  strk         
     Type:  defect     |      Status:  new          
 Priority:  medium     |   Milestone:  PostGIS 2.0.0
Component:  topology   |     Version:  trunk        
 Keywords:             |  

Comment(by aperi2007):

 I understand your point of view.

 >This is pretty much like DropGeometryTable?, where the table is dropped
 even if it
 >isn't advertised in geometry_columns, and even if it doesn't contain any

 You are right.
 let me see is they have the same paradigm:
 -) Have a GeometryColumn is a property of the table.

 Is the same for Topology Schema ?

 -) To be a topology schema is a property of a schema ?

 I think you are right.

 Another question is the drop rights.

 leaving tha capability to drop always, perhaps (I don't know what security
 definer is used) but a user that cannot have the right to drop a schema
 using the postgres command could be drop a schema (public for example ? )
 using the
 DropTopology only because it could have the right to execute DropTopology

 Another question is how to know if a standard schema is instead a
 Actually the only method is to do a select on others table in another
 schema again. Not very simple to know for a standard user.

 There is a function to know if a table is a geometry table ?
 There is a function to know if a schema is a topology schema ?

 Perhaps is the missing of these two function the problem.

Ticket URL: <http://trac.osgeo.org/postgis/ticket/862#comment:2>
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-devel mailing list