PostgreSQL 中的 DEFAULTS 关键字

顾名思义,在创建表、要素类、栅格数据集以及索引时,默认情况下使用 DEFAULTS 配置关键字下的设置。如果在地理数据库中创建数据时未指定其他关键字,或者指定的关键字缺少某些必要参数,则将使用 DEFAULTS 关键字中的值。

大多数参数在 PostgreSQL dbtune.sde 文件中均会出现两次 - 一次按默认设置出现,另一次以作为注释的参数的形式出现,用以为表空间指派指定正确的语法。这么做的原因是表空间指派的语法会因所创建对象的类型而异。

仅使用参数的个版本。也就是说,如果想为特定索引指定不同的表空间,则请取消注释该行并注释掉或删除默认的参数。

##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

相关主题


3/7/2012