Composite keywords and geometry storage

The default composite configuration keywords in Oracle and PostgreSQL do not contain a GEOMETRY_STORAGE parameter. Since any necessary parameters that are missing from a specified keyword are read from the DEFAULTS keyword, the value for the GEOMETRY_STORAGE parameter is read from the DEFAULTS keyword. Therefore, if you are using an Oracle or PostgreSQL database and want to use a geometry storage type other than the one defined with the DEFAULTS keyword for your terrains, networks, or topologies, you need to create your own custom composite keywords for these that include the GEOMETRY_STORAGE parameter.

For example, if you are using ArcSDE for PostgreSQL and you leave your DEFAULTS GEOMETRY_STORAGE parameter set to ST_GEOMETRY but you want to occasionally store your topology tables using the PostGIS geometry storage type, you would create a set of topology composite keywords for the PG_GEOMETRY type. You would do this if you create some of your feature classes with the PG_GEOMETRY keyword and want to create a topology for these. Custom keywords for the topology might look something like the following:

##TOPOLOGY_PG_GEOMETRY
UI_TOPOLOGY_TEXT		"Topology setting for PG_GEOMETRY"
GEOMETRY_STORAGE	"PG_GEOMETRY"
A_STORAGE          "TABLESPACE pgtblspace"
B_STORAGE          "TABLESPACE pgtblspace"
D_STORAGE          "TABLESPACE pgtblspace"
END

##TOPOLOGY_PG_GEOMETRY::DIRTYAREAS
GEOMETRY_STORAGE	"PG_GEOMETRY"
A_STORAGE          "TABLESPACE pgtblspace"
B_STORAGE          "TABLESPACE pgtblspace"
D_STORAGE          "TABLESPACE pgtblspace"
END

In this example, the UI_TOPOLOGY_TEXT parameter is included to allow users to choose this keyword when creating topologies. The GEOMETRY_STORAGE parameter is set to PG_GEOMETRY so the dirtyarea and shape fields in the topology system tables will use PG_GEOMETRY for their data storage type. These custom keywords do not include the index parameters; that means the settings for those parameters will be read from the DEFAULTS keyword.

Caution:

Your configuration keyword name cannot exceed 32 characters total.

Tip:

In SQL Server databases, two additional sets of network, topology, and terrain composite keywords have already been added for you: one for the geometry storage type and one for the geography storage type.