Schlüsselwort DEFAULTS in PostgreSQL

Die unter dem Konfigurationsschlüsselwort DEFAULTS zusammengefassten Einstellungen werden standardmäßig verwendet, wenn Sie Tabellen, Feature-Classes, Raster-Datasets und Indizes erstellen. Wenn Sie beim Erstellen von Daten in der Geodatabase kein anderes Schlüsselwort angeben, oder wenn Sie ein Schlüsselwort angeben, in dem einige erforderliche Parameter fehlen, werden die Werte aus dem Schlüsselwort DEFAULTS verwendet.

In der Datei "dbtune.sde" für PostgreSQL sind die meisten Parameter zweimal enthalten – einmal mit der Standardeinstellung und einmal als kommentierte Parameter, um die richtige Syntax für die Tablespace-Bezeichnung anzugeben. Dies wird so gehandhabt, da die Syntax für die Tablespace-Bezeichnung je nach erstelltem Objekttyp unterschiedlich ist.

Verwenden Sie nur eine Version des Parameters. Wenn Sie also einen anderen Tablespace für bestimmte Indizes angeben möchten, unkommentieren Sie die Zeile, und deaktivieren oder löschen Sie den Standardparameter.

##DEFAULTS
RASTER_STORAGE	    "BINARY"
GEOMETRY_STORAGE       "ST_GEOMETRY"
UI_TEXT	           "User Interface text for DEFAULTS"
A_INDEX_ROWID          "WITH (FILLFACTOR = 75)"
#A_INDEX_ROWID          "WITH (FILLFACTOR = 75) USING INDEX TABLESPACE <lower_case_name>"
A_INDEX_STATEID	     "WITH (FILLFACTOR = 75)"  
#A_INDEX_STATEID	"WITH (FILLFACTOR = 75) TABLESPACE <lower_case_name>" 
A_INDEX_USER           "WITH (FILLFACTOR = 75)"
#A_INDEX_USER           "WITH (FILLFACTOR = 75) TABLESPACE <lower_case_name>"
A_INDEX_XML            "WITH (FILLFACTOR = 75)"
#A_INDEX_XML            "WITH (FILLFACTOR = 75) TABLESPACE <lower_case_name>"
A_INDEX_RASTER         "WITH (FILLFACTOR = 75)"
#A_INDEX_RASTER         "WITH (FILLFACTOR = 75) TABLESPACE <lower_case_name>"
A_STORAGE              ""
#A_STORAGE              "TABLESPACE <lower_case_name>"
B_INDEX_ROWID          "WITH (FILLFACTOR = 75)"
#B_INDEX_ROWID          "WITH (FILLFACTOR = 75)TABLESPACE <lower_case_name>"
B_INDEX_USER           "WITH (FILLFACTOR = 75)"
#B_INDEX_USER           "WITH (FILLFACTOR = 75)TABLESPACE <lower_case_name>"
B_INDEX_XML            "WITH (FILLFACTOR = 75)"
#B_INDEX_XML            "WITH (FILLFACTOR = 75)TABLESPACE <lower_case_name>"
B_INDEX_RASTER         "WITH (FILLFACTOR = 75)"
#B_INDEX_RASTER         "WITH (FILLFACTOR = 75)TABLESPACE <lower_case_name>"
B_INDEX_TO_DATE        "WITH (FILLFACTOR = 75)"
#B_INDEX_TO_DATE        "WITH (FILLFACTOR = 75)TABLESPACE <lower_case_name>"
B_STORAGE              ""
#B_STORAGE              "TABLESPACE <lower_case_name>"
D_INDEX_ALL            "WITH (FILLFACTOR = 75)"
#D_INDEX_ALL            "WITH (FILLFACTOR = 75)USING INDEX TABLESPACE <lower_case_name>"
D_INDEX_DELETED_AT     "WITH (FILLFACTOR = 75)"
#D_INDEX_DELETED_AT     "WITH (FILLFACTOR = 75)TABLESPACE <lower_case_name>"
D_STORAGE              ""
#D_STORAGE              "TABLESPACE <lower_case_name>"
RAS_STORAGE            ""
#RAS_STORAGE            "TABLESPACE <lower_case_name>"
RAS_INDEX_ID           "WITH (FILLFACTOR = 90)"
#RAS_INDEX_ID           "WITH (FILLFACTOR = 90)USING INDEX TABLESPACE <lower_case_name>"
BND_STORAGE            ""
#BND_STORAGE            "TABLESPACE <lower_case_name>"
BND_INDEX_ID           "WITH (FILLFACTOR = 90)"
#BND_INDEX_ID           "WITH (FILLFACTOR = 90)USING INDEX TABLESPACE <lower_case_name>"
BND_INDEX_COMPOSITE    "WITH (FILLFACTOR = 90)"
#BND_INDEX_COMPOSITE    "WITH (FILLFACTOR = 90)USING INDEX TABLESPACE <lower_case_name>"
AUX_STORAGE            ""
#AUX_STORAGE            "TABLESPACE <lower_case_name>"
AUX_INDEX_COMPOSITE    "WITH (FILLFACTOR = 75)"
#AUX_INDEX_COMPOSITE    "WITH (FILLFACTOR = 90)USING INDEX TABLESPACE <lower_case_name>"
BLK_STORAGE            ""
#BLK_STORAGE            "TABLESPACE <lower_case_name>"
BLK_INDEX_COMPOSITE    "WITH (FILLFACTOR = 90)"
#BLK_INDEX_COMPOSITE    "WITH (FILLFACTOR = 90)USING INDEX TABLESPACE <lower_case_name>"
XML_DOC_INDEX          "WITH (FILLFACTOR = 75)"
#XML_DOC_INDEX          "WITH (FILLFACTOR = 75)USING INDEX TABLESPACE <lower_case_name>"
XML_DOC_STORAGE        ""
#XML_DOC_STORAGE        "TABLESPACE <lower_case_name>"
XML_DOC_UNCOMPRESSED_TYPE  "BINARY"
XML_IDX_INDEX_DOUBLE   "WITH (FILLFACTOR = 75)"
#XML_IDX_INDEX_DOUBLE   "WITH (FILLFACTOR = 75)TABLESPACE <lower_case_name>"
XML_IDX_INDEX_ID       "WITH (FILLFACTOR = 75)"
#XML_IDX_INDEX_ID       "WITH (FILLFACTOR = 75)TABLESPACE <lower_case_name>"
XML_IDX_INDEX_PK       "WITH (FILLFACTOR = 75)"
#XML_IDX_INDEX_PK       "WITH (FILLFACTOR = 75)USING INDEX TABLESPACE <lower_case_name>"
XML_IDX_INDEX_STRING   "WITH (FILLFACTOR = 75)"
#XML_IDX_INDEX_STRING   "WITH (FILLFACTOR = 75)TABLESPACE <lower_case_name>"
XML_IDX_INDEX_TAG      "WITH (FILLFACTOR = 75)"
#XML_IDX_INDEX_TAG      "WITH (FILLFACTOR = 75)TABLESPACE <lower_case_name>"
XML_IDX_STORAGE        ""
#XML_IDX_STORAGE        "TABLESPACE <lower_case_name>"
XML_IDX_FULLTEXT_UPDATE_METHOD "AUTOMATIC"
XMLCOLUMN_STORAGE			"SDE_XML"

END