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

[PostGIS]

#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
 geometric
 >column...

 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
 topology-schema.
 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.