[postgis-devel] Topology allow more than one layer with same topocolumn-name

strk strk at keybit.net
Fri Jan 7 02:50:42 PST 2011


On Mon, Jan 03, 2011 at 01:56:41PM +0100, aperi2007 wrote:
> In the topology,
> actually is possible to do this:
> 
> SELECT topology.CreateTopology('ma_topo',4326, 0.00005);
> SELECT topology.AddTopoGeometryColumn('schema-of-topology', 
> 'schema-of-layer', 'linear_layer1', 'topo_name_column', 'LINE');
> SELECT topology.AddTopoGeometryColumn('schema-of-topology', 
> 'schema-of-layer', 'linear_layer2', 'topo_name_column', 'LINE');
> SELECT topology.AddTopoGeometryColumn('schema-of-topology', 
> 'schema-of-layer', 'poligonal_layer3', 'topo_name_column', 'POLYGON');
> 
> So I add three layer every one having the same topo-column name.
> I don't understand if this is a correct situation or not.
> 
> I believe three layers must have three distinct topocolumn names if use 
> the same topology
> 
> don't ?

Don't :)

Each layer is a table, you have 3 different tables and they can all have
a column with the same name. This is pretty much like 'the_geom' column
used by default for all non-topological layers...

--strk;

  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html



More information about the postgis-devel mailing list