You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hawq.apache.org by yj...@apache.org on 2018/02/08 08:04:07 UTC
[1/2] incubator-hawq git commit: HAWQ-1586. Update version from
2.2.0.0 to 2.3.0.0
Repository: incubator-hawq
Updated Branches:
refs/heads/master 060ca66d2 -> a05faa2aa
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/a05faa2a/tools/bin/gppylib/data/2.3.json
----------------------------------------------------------------------
diff --git a/tools/bin/gppylib/data/2.3.json b/tools/bin/gppylib/data/2.3.json
new file mode 100644
index 0000000..e62b59d
--- /dev/null
+++ b/tools/bin/gppylib/data/2.3.json
@@ -0,0 +1,10458 @@
+{
+ "__comment" : "Generated by tidycat.pl version 34 on Mon Mar 27 14:07:18 2017 CATALOG_VERSION_NO=201507221",
+ "__info" : {
+ "CATALOG_VERSION_NO" : "201507221"
+ },
+ "gp_configuration" : {
+ "CamelCaseRelationId" : "GpConfigurationRelationId",
+ "colh" : {
+ "content" : "int2",
+ "datadir" : "text",
+ "dbid" : "int2",
+ "definedprimary" : "bool",
+ "hostname" : "NameData",
+ "isprimary" : "bool",
+ "port" : "int4",
+ "valid" : "bool"
+ },
+ "cols" : [
+ {
+ "colname" : "content",
+ "ctype" : "int2",
+ "precomment" : "\n**TK_BLANK_LINE**",
+ "sqltype" : "smallint"
+ },
+ {
+ "colname" : "definedprimary",
+ "ctype" : "bool",
+ "sqltype" : "boolean"
+ },
+ {
+ "colname" : "dbid",
+ "ctype" : "int2",
+ "sqltype" : "smallint"
+ },
+ {
+ "colname" : "isprimary",
+ "ctype" : "bool",
+ "sqltype" : "boolean"
+ },
+ {
+ "colname" : "valid",
+ "ctype" : "bool",
+ "sqltype" : "boolean"
+ },
+ {
+ "colname" : "hostname",
+ "ctype" : "NameData",
+ "sqltype" : "name"
+ },
+ {
+ "colname" : "port",
+ "ctype" : "int4",
+ "sqltype" : "integer"
+ },
+ {
+ "colname" : "datadir",
+ "ctype" : "text",
+ "sqltype" : "text"
+ }
+ ],
+ "filename" : "gp_configuration.h",
+ "indexes" : [
+ {
+ "CamelCaseIndexId" : "GpConfigurationContentDefinedprimaryIndexId",
+ "cols" : [
+ [
+ "content",
+ "int2_ops"
+ ],
+ [
+ "definedprimary",
+ "bool_ops"
+ ]
+ ],
+ "indexid" : "6101",
+ "unique" : "1",
+ "with" : {
+ "indexid" : "6101"
+ }
+ },
+ {
+ "CamelCaseIndexId" : "GpConfigurationDbidIndexId",
+ "cols" : [
+ [
+ "dbid",
+ "int2_ops"
+ ]
+ ],
+ "indexid" : "6102",
+ "unique" : "1",
+ "with" : {
+ "indexid" : "6102"
+ }
+ }
+ ],
+ "relid_comment_tag" : "/* relation id: 5000 - gp_configuration */\n",
+ "tabdef_text" : "\n CREATE TABLE gp_configuration\n with (shared=true, oid=false, relid=5000, content=MASTER_ONLY)\n (\n content smallint,\n definedprimary boolean,\n dbid smallint,\n isprimary boolean,\n valid boolean,\n hostname name,\n port integer,\n datadir text\n )",
+ "with" : {
+ "bootstrap" : 0,
+ "camelcase" : "GpConfiguration",
+ "content" : "MASTER_ONLY",
+ "oid" : "",
+ "relid" : "5000",
+ "shared" : "1",
+ "text" : "with (shared=true, oid=false, relid=5000, content=MASTER_ONLY)"
+ }
+ },
+ "gp_configuration_history" : {
+ "CamelCaseRelationId" : "GpConfigHistoryRelationId",
+ "UppercaseReltypeOid" : "GP_CONFIGURATION_HISTORY_RELTYPE_OID",
+ "colh" : {
+ "description" : "text",
+ "hostname" : "text",
+ "registration_order" : "int4",
+ "time" : "timestamptz"
+ },
+ "cols" : [
+ {
+ "colname" : "time",
+ "ctype" : "timestamptz",
+ "precomment" : "\n**TK_BLANK_LINE**",
+ "sqltype" : "timestamp_with_time_zone"
+ },
+ {
+ "colname" : "registration_order",
+ "ctype" : "int4",
+ "sqltype" : "integer"
+ },
+ {
+ "colname" : "hostname",
+ "ctype" : "text",
+ "sqltype" : "text"
+ },
+ {
+ "colname" : "description",
+ "ctype" : "text",
+ "sqltype" : "text"
+ }
+ ],
+ "filename" : "gp_configuration.h",
+ "relid_comment_tag" : "/* relation id: 5006 - gp_configuration_history */\n",
+ "tabdef_text" : "\n CREATE TABLE gp_configuration_history\n with (camelcase=GpConfigHistory, shared=true, oid=false, relid=5006, reltype_oid=6434, content=MASTER_ONLY)\n (\n time timestamp with time zone,\n registration_order integer,\n hostname text,\n description text\n )",
+ "tzhack" : "\"time\"",
+ "with" : {
+ "bootstrap" : 0,
+ "camelcase" : "GpConfigHistory",
+ "content" : "MASTER_ONLY",
+ "oid" : "",
+ "relid" : "5006",
+ "reltype_oid" : "6434",
+ "shared" : "1",
+ "text" : "with (camelcase=GpConfigHistory, shared=true, oid=false, relid=5006, reltype_oid=6434, content=MASTER_ONLY)"
+ }
+ },
+ "gp_db_interfaces" : {
+ "CamelCaseRelationId" : "GpDbInterfacesRelationId",
+ "UppercaseReltypeOid" : "GP_DB_INTERFACES_RELTYPE_OID",
+ "colh" : {
+ "dbid" : "int2",
+ "interfaceid" : "int2",
+ "priority" : "int2"
+ },
+ "cols" : [
+ {
+ "colname" : "dbid",
+ "ctype" : "int2",
+ "precomment" : "\n**TK_BLANK_LINE**",
+ "sqltype" : "smallint"
+ },
+ {
+ "colname" : "interfaceid",
+ "ctype" : "int2",
+ "sqltype" : "smallint"
+ },
+ {
+ "colname" : "priority",
+ "ctype" : "int2",
+ "sqltype" : "smallint"
+ }
+ ],
+ "filename" : "gp_configuration.h",
+ "indexes" : [
+ {
+ "CamelCaseIndexId" : "GpDbInterfacesDbidIndexId",
+ "cols" : [
+ [
+ "dbid",
+ "int2_ops"
+ ]
+ ],
+ "indexid" : "6108",
+ "unique" : "",
+ "with" : {
+ "indexid" : "6108"
+ }
+ }
+ ],
+ "relid_comment_tag" : "/* relation id: 5029 - gp_db_interfaces */\n",
+ "tabdef_text" : "\n CREATE TABLE gp_db_interfaces\n with (camelcase=GpDbInterfaces, shared=true, oid=false, relid=5029, reltype_oid=6436, content=MASTER_ONLY)\n (\n dbid smallint,\n interfaceid smallint,\n priority smallint\n )",
+ "with" : {
+ "bootstrap" : 0,
+ "camelcase" : "GpDbInterfaces",
+ "content" : "MASTER_ONLY",
+ "oid" : "",
+ "relid" : "5029",
+ "reltype_oid" : "6436",
+ "shared" : "1",
+ "text" : "with (camelcase=GpDbInterfaces, shared=true, oid=false, relid=5029, reltype_oid=6436, content=MASTER_ONLY)"
+ }
+ },
+ "gp_distribution_policy" : {
+ "CamelCaseRelationId" : "GpPolicyRelationId",
+ "colh" : {
+ "attrnums" : "int2[1]",
+ "bucketnum" : "int4",
+ "localoid" : "Oid"
+ },
+ "cols" : [
+ {
+ "colname" : "localoid",
+ "ctype" : "Oid",
+ "precomment" : "\n**TK_BLANK_LINE**",
+ "sqltype" : "oid"
+ },
+ {
+ "colname" : "bucketnum",
+ "ctype" : "int4",
+ "sqltype" : "integer"
+ },
+ {
+ "colname" : "attrnums",
+ "ctype" : "int2[1]",
+ "sqltype" : "smallint[]"
+ }
+ ],
+ "filename" : "gp_policy.h",
+ "fk_list" : [
+ {
+ "fkcols" : [
+ "localoid"
+ ],
+ "pkcols" : [
+ "oid"
+ ],
+ "pktable" : "pg_class",
+ "type" : "scalar"
+ }
+ ],
+ "foreign_keys" : [
+ [
+ [
+ "localoid"
+ ],
+ "pg_class",
+ [
+ "oid"
+ ]
+ ]
+ ],
+ "indexes" : [
+ {
+ "CamelCaseIndexId" : "GpPolicyLocalOidIndexId",
+ "cols" : [
+ [
+ "localoid",
+ "oid_ops"
+ ]
+ ],
+ "indexid" : "6103",
+ "unique" : "1",
+ "with" : {
+ "camelcase" : "GpPolicyLocalOid",
+ "indexid" : "6103"
+ }
+ }
+ ],
+ "relid_comment_tag" : "/* relation id: 5002 - gp_distribution_policy */\n",
+ "tabdef_text" : "\n CREATE TABLE gp_distribution_policy\n with (camelcase=GpPolicy, oid=false, relid=5002, content=MASTER_ONLY)\n (\n localoid oid,\n bucketnum integer,\n attrnums smallint[]\n )",
+ "with" : {
+ "bootstrap" : 0,
+ "camelcase" : "GpPolicy",
+ "content" : "MASTER_ONLY",
+ "oid" : "",
+ "relid" : "5002",
+ "shared" : 0,
+ "text" : "with (camelcase=GpPolicy, oid=false, relid=5002, content=MASTER_ONLY)"
+ }
+ },
+ "gp_global_sequence" : {
+ "CamelCaseRelationId" : "GpGlobalSequenceRelationId",
+ "UppercaseReltypeOid" : "GP_GLOBAL_SEQUENCE_RELTYPE_OID",
+ "colh" : {
+ "sequence_num" : "bigint"
+ },
+ "cols" : [
+ {
+ "colname" : "sequence_num",
+ "ctype" : "bigint",
+ "precomment" : "\n**TK_BLANK_LINE**",
+ "sqltype" : "bigint"
+ }
+ ],
+ "filename" : "gp_global_sequence.h",
+ "relid_comment_tag" : "/* relation id: 5096 - gp_global_sequence */\n",
+ "tabdef_text" : "\n CREATE TABLE gp_global_sequence\n with (camelcase=GpGlobalSequence, oid=false, relid=5096, reltype_oid=6995, content=PERSISTENT)\n (\n sequence_num bigint\n )",
+ "with" : {
+ "bootstrap" : 0,
+ "camelcase" : "GpGlobalSequence",
+ "content" : "PERSISTENT",
+ "oid" : "",
+ "relid" : "5096",
+ "reltype_oid" : "6995",
+ "shared" : 0,
+ "text" : "with (camelcase=GpGlobalSequence, oid=false, relid=5096, reltype_oid=6995, content=PERSISTENT)"
+ }
+ },
+ "gp_interfaces" : {
+ "CamelCaseRelationId" : "GpInterfacesRelationId",
+ "UppercaseReltypeOid" : "GP_INTERFACES_RELTYPE_OID",
+ "colh" : {
+ "address" : "NameData",
+ "interfaceid" : "int2",
+ "status" : "int2"
+ },
+ "cols" : [
+ {
+ "colname" : "interfaceid",
+ "ctype" : "int2",
+ "precomment" : "\n**TK_BLANK_LINE**",
+ "sqltype" : "smallint"
+ },
+ {
+ "colname" : "address",
+ "ctype" : "NameData",
+ "sqltype" : "name"
+ },
+ {
+ "colname" : "status",
+ "ctype" : "int2",
+ "sqltype" : "smallint"
+ }
+ ],
+ "filename" : "gp_configuration.h",
+ "indexes" : [
+ {
+ "CamelCaseIndexId" : "GpInterfacesInterfaceidIndexId",
+ "cols" : [
+ [
+ "interfaceid",
+ "int2_ops"
+ ]
+ ],
+ "indexid" : "6109",
+ "indexname" : "gp_interfaces_interface_index",
+ "unique" : "1",
+ "with" : {
+ "indexid" : "6109",
+ "indexname" : "gp_interfaces_interface_index"
+ }
+ }
+ ],
+ "relid_comment_tag" : "/* relation id: 5030 - gp_interfaces */\n",
+ "tabdef_text" : "\n CREATE TABLE gp_interfaces\n with (shared=true, oid=false, relid=5030, reltype_oid=6433, content=MASTER_ONLY)\n (\n interfaceid smallint,\n address name,\n status smallint \n )",
+ "with" : {
+ "bootstrap" : 0,
+ "camelcase" : "GpInterfaces",
+ "content" : "MASTER_ONLY",
+ "oid" : "",
+ "relid" : "5030",
+ "reltype_oid" : "6433",
+ "shared" : "1",
+ "text" : "with (shared=true, oid=false, relid=5030, reltype_oid=6433, content=MASTER_ONLY)"
+ }
+ },
+ "gp_master_mirroring" : {
+ "CamelCaseRelationId" : "GpMasterMirroringRelationId",
+ "colh" : {
+ "detail_state" : "text",
+ "error_message" : "text",
+ "log_time" : "timestamptz",
+ "summary_state" : "text"
+ },
+ "cols" : [
+ {
+ "colname" : "summary_state",
+ "ctype" : "text",
+ "precomment" : "\n**TK_BLANK_LINE**",
+ "sqltype" : "text"
+ },
+ {
+ "colname" : "detail_state",
+ "ctype" : "text",
+ "sqltype" : "text"
+ },
+ {
+ "colname" : "log_time",
+ "ctype" : "timestamptz",
+ "sqltype" : "timestamp_with_time_zone"
+ },
+ {
+ "colname" : "error_message",
+ "ctype" : "text",
+ "sqltype" : "text"
+ }
+ ],
+ "filename" : "gp_master_mirroring.h",
+ "relid_comment_tag" : "/* relation id: 5008 - gp_master_mirroring */\n",
+ "tabdef_text" : "\n CREATE TABLE gp_master_mirroring\n with (camelcase=GpMasterMirroring, shared=true, oid=false, relid=5008, content=MASTER_ONLY)\n (\n summary_state text,\n detail_state text,\n log_time timestamp with time zone,\n error_message text\n )",
+ "tzhack" : "\"log_time\"",
+ "with" : {
+ "bootstrap" : 0,
+ "camelcase" : "GpMasterMirroring",
+ "content" : "MASTER_ONLY",
+ "oid" : "",
+ "relid" : "5008",
+ "shared" : "1",
+ "text" : "with (camelcase=GpMasterMirroring, shared=true, oid=false, relid=5008, content=MASTER_ONLY)"
+ }
+ },
+ "gp_persistent_filespace_node" : {
+ "CamelCaseRelationId" : "GpPersistent_filespace_nodeRelationId",
+ "UppercaseReltypeOid" : "GP_PERSISTENT_FILESPACE_NODE_RELTYPE_OID",
+ "colh" : {
+ "db_id" : "int2",
+ "filespace_oid" : "Oid",
+ "location" : "text",
+ "parent_xid" : "int4",
+ "persistent_serial_num" : "bigint",
+ "persistent_state" : "int2",
+ "previous_free_tid" : "tid",
+ "reserved" : "int4"
+ },
+ "cols" : [
+ {
+ "colname" : "filespace_oid",
+ "ctype" : "Oid",
+ "precomment" : "\n**TK_BLANK_LINE**",
+ "sqltype" : "oid"
+ },
+ {
+ "colname" : "db_id",
+ "ctype" : "int2",
+ "sqltype" : "smallint"
+ },
+ {
+ "colname" : "location",
+ "ctype" : "text",
+ "sqltype" : "text"
+ },
+ {
+ "colname" : "persistent_state",
+ "ctype" : "int2",
+ "sqltype" : "smallint"
+ },
+ {
+ "colname" : "reserved",
+ "ctype" : "int4",
+ "sqltype" : "integer"
+ },
+ {
+ "colname" : "parent_xid",
+ "ctype" : "int4",
+ "sqltype" : "integer"
+ },
+ {
+ "colname" : "persistent_serial_num",
+ "ctype" : "bigint",
+ "sqltype" : "bigint"
+ },
+ {
+ "colname" : "previous_free_tid",
+ "ctype" : "tid",
+ "sqltype" : "tid"
+ }
+ ],
+ "filename" : "gp_persistent.h",
+ "relid_comment_tag" : "/* relation id: 5093 - gp_persistent_filespace_node */\n",
+ "tabdef_text" : "\n CREATE TABLE gp_persistent_filespace_node\n with (shared=true, oid=false, relid=5093, reltype_oid=6993, content=PERSISTENT)\n (\n filespace_oid oid ,\n db_id smallint ,\n location text ,\n persistent_state smallint ,\n reserved integer ,\n parent_xid integer ,\n persistent_serial_num bigint ,\n previous_free_tid tid ,\n )",
+ "with" : {
+ "bootstrap" : 0,
+ "camelcase" : "GpPersistent_filespace_node",
+ "content" : "PERSISTENT",
+ "oid" : "",
+ "relid" : "5093",
+ "reltype_oid" : "6993",
+ "shared" : "1",
+ "text" : "with (shared=true, oid=false, relid=5093, reltype_oid=6993, content=PERSISTENT)"
+ }
+ },
+ "gp_persistent_relation_node" : {
+ "CamelCaseRelationId" : "GpPersistent_relation_nodeRelationId",
+ "UppercaseReltypeOid" : "GP_PERSISTENT_RELATION_NODE_RELTYPE_OID",
+ "colh" : {
+ "database_oid" : "Oid",
+ "parent_xid" : "int4",
+ "persistent_serial_num" : "bigint",
+ "persistent_state" : "int2",
+ "previous_free_tid" : "tid",
+ "relfilenode_oid" : "Oid",
+ "reserved" : "int4",
+ "tablespace_oid" : "Oid"
+ },
+ "cols" : [
+ {
+ "colname" : "tablespace_oid",
+ "ctype" : "Oid",
+ "precomment" : "\n**TK_BLANK_LINE**",
+ "sqltype" : "oid"
+ },
+ {
+ "colname" : "database_oid",
+ "ctype" : "Oid",
+ "sqltype" : "oid"
+ },
+ {
+ "colname" : "relfilenode_oid",
+ "ctype" : "Oid",
+ "sqltype" : "oid"
+ },
+ {
+ "colname" : "persistent_state",
+ "ctype" : "int2",
+ "sqltype" : "smallint"
+ },
+ {
+ "colname" : "reserved",
+ "ctype" : "int4",
+ "sqltype" : "integer"
+ },
+ {
+ "colname" : "parent_xid",
+ "ctype" : "int4",
+ "sqltype" : "integer"
+ },
+ {
+ "colname" : "persistent_serial_num",
+ "ctype" : "bigint",
+ "sqltype" : "bigint"
+ },
+ {
+ "colname" : "previous_free_tid",
+ "ctype" : "tid",
+ "sqltype" : "tid"
+ }
+ ],
+ "filename" : "gp_persistent.h",
+ "relid_comment_tag" : "/* relation id: 5090 - gp_persistent_relation_node */\n",
+ "tabdef_text" : "\n CREATE TABLE gp_persistent_relation_node\n with (shared=true, oid=false, relid=5090, reltype_oid=6990, content=PERSISTENT)\n (\n tablespace_oid\t\t\t\t\t\t\t\t\toid\t\t\t,\n database_oid\t\t\t\t\t\t\t\t\t\toid\t\t\t,\n relfilenode_oid\t\t\t\t\t\t\t\t\toid\t\t\t,\n persistent_state\t\t\t\t\t\t\t\t\tsmallint\t\t,\n reserved\t\t\t\t\t\t\t\t\t\t\tinteger\t\t,\n parent_xid\t\t\t\t\t\t\t\t\t\tinteger\t\t,\n persistent_serial_num\t\t\t\t\t\t\t\tbigint\t\t,\n previous_free_tid\t\t\t\t\t\t\t\t\ttid\t\t\t,\n )",
+ "with" : {
+ "bootstrap" : 0,
+ "camelcase" : "GpPersistent_relation_node",
+ "content" : "PERSISTENT",
+ "oid" : "",
+ "relid" : "5090",
+ "reltype_oid" : "6990",
+ "shared" : "1",
+ "text" : "with (shared=true, oid=false, relid=5090, reltype_oid=6990, content=PERSISTENT)"
+ }
+ },
+ "gp_persistent_relfile_node" : {
+ "CamelCaseRelationId" : "GpPersistent_relfile_nodeRelationId",
+ "UppercaseReltypeOid" : "GP_PERSISTENT_RELFILE_NODE_RELTYPE_OID",
+ "colh" : {
+ "database_oid" : "Oid",
+ "parent_xid" : "int4",
+ "persistent_serial_num" : "bigint",
+ "persistent_state" : "int2",
+ "previous_free_tid" : "tid",
+ "relation_bufpool_kind" : "int4",
+ "relation_storage_manager" : "int2",
+ "relfilenode_oid" : "Oid",
+ "segment_file_num" : "int4",
+ "tablespace_oid" : "Oid"
+ },
+ "cols" : [
+ {
+ "colname" : "tablespace_oid",
+ "ctype" : "Oid",
+ "precomment" : "\n**TK_BLANK_LINE**",
+ "sqltype" : "oid"
+ },
+ {
+ "colname" : "database_oid",
+ "ctype" : "Oid",
+ "sqltype" : "oid"
+ },
+ {
+ "colname" : "relfilenode_oid",
+ "ctype" : "Oid",
+ "sqltype" : "oid"
+ },
+ {
+ "colname" : "segment_file_num",
+ "ctype" : "int4",
+ "sqltype" : "integer"
+ },
+ {
+ "colname" : "relation_storage_manager",
+ "ctype" : "int2",
+ "sqltype" : "smallint"
+ },
+ {
+ "colname" : "persistent_state",
+ "ctype" : "int2",
+ "sqltype" : "smallint"
+ },
+ {
+ "colname" : "relation_bufpool_kind",
+ "ctype" : "int4",
+ "sqltype" : "integer"
+ },
+ {
+ "colname" : "parent_xid",
+ "ctype" : "int4",
+ "sqltype" : "integer"
+ },
+ {
+ "colname" : "persistent_serial_num",
+ "ctype" : "bigint",
+ "sqltype" : "bigint"
+ },
+ {
+ "colname" : "previous_free_tid",
+ "ctype" : "tid",
+ "sqltype" : "tid"
+ }
+ ],
+ "filename" : "gp_persistent.h",
+ "relid_comment_tag" : "/* relation id: 5089 - gp_persistent_relfile_node */\n",
+ "tabdef_text" : "\n CREATE TABLE gp_persistent_relfile_node\n with (shared=true, oid=false, relid=5089, reltype_oid=6989, content=PERSISTENT)\n (\n tablespace_oid oid ,\n database_oid oid ,\n relfilenode_oid oid ,\n segment_file_num integer ,\n relation_storage_manager smallint ,\n persistent_state smallint ,\n relation_bufpool_kind integer ,\n parent_xid integer ,\n persistent_serial_num bigint ,\n previous_free_tid tid ,\n )",
+ "with" : {
+ "bootstrap" : 0,
+ "camelcase" : "GpPersistent_relfile_node",
+ "content" : "PERSISTENT",
+ "oid" : "",
+ "relid" : "5089",
+ "reltype_oid" : "6989",
+ "shared" : "1",
+ "text" : "with (shared=true, oid=false, relid=5089, reltype_oid=6989, content=PERSISTENT)"
+ }
+ },
+ "gp_persistent_tablespace_node" : {
+ "CamelCaseRelationId" : "GpPersistent_tablespace_nodeRelationId",
+ "UppercaseReltypeOid" : "GP_PERSISTENT_TABLESPACE_NODE_RELTYPE_OID",
+ "colh" : {
+ "filespace_oid" : "Oid",
+ "parent_xid" : "int4",
+ "persistent_serial_num" : "bigint",
+ "persistent_state" : "int2",
+ "previous_free_tid" : "tid",
+ "reserved" : "int4",
+ "tablespace_oid" : "Oid"
+ },
+ "cols" : [
+ {
+ "colname" : "filespace_oid",
+ "ctype" : "Oid",
+ "precomment" : "\n**TK_BLANK_LINE**",
+ "sqltype" : "oid"
+ },
+ {
+ "colname" : "tablespace_oid",
+ "ctype" : "Oid",
+ "sqltype" : "oid"
+ },
+ {
+ "colname" : "persistent_state",
+ "ctype" : "int2",
+ "sqltype" : "smallint"
+ },
+ {
+ "colname" : "reserved",
+ "ctype" : "int4",
+ "sqltype" : "integer"
+ },
+ {
+ "colname" : "parent_xid",
+ "ctype" : "int4",
+ "sqltype" : "integer"
+ },
+ {
+ "colname" : "persistent_serial_num",
+ "ctype" : "bigint",
+ "sqltype" : "bigint"
+ },
+ {
+ "colname" : "previous_free_tid",
+ "ctype" : "tid",
+ "sqltype" : "tid"
+ }
+ ],
+ "filename" : "gp_persistent.h",
+ "relid_comment_tag" : "/* relation id: 5092 - gp_persistent_tablespace_node */\n",
+ "tabdef_text" : "\n CREATE TABLE gp_persistent_tablespace_node\n with (shared=true, oid=false, relid=5092, reltype_oid=6992, content=PERSISTENT)\n (\n filespace_oid oid ,\n tablespace_oid oid ,\n persistent_state smallint ,\n reserved integer ,\n parent_xid integer ,\n persistent_serial_num bigint ,\n previous_free_tid tid ,\n )",
+ "with" : {
+ "bootstrap" : 0,
+ "camelcase" : "GpPersistent_tablespace_node",
+ "content" : "PERSISTENT",
+ "oid" : "",
+ "relid" : "5092",
+ "reltype_oid" : "6992",
+ "shared" : "1",
+ "text" : "with (shared=true, oid=false, relid=5092, reltype_oid=6992, content=PERSISTENT)"
+ }
+ },
+ "gp_relfile_node" : {
+ "CamelCaseRelationId" : "GpRelfile_nodeRelationId",
+ "UppercaseReltypeOid" : "GP_RELFILE_NODE_RELTYPE_OID",
+ "colh" : {
+ "persistent_serial_num" : "bigint",
+ "persistent_tid" : "tid",
+ "relfilenode_oid" : "Oid",
+ "segment_file_num" : "int4"
+ },
+ "cols" : [
+ {
+ "colname" : "relfilenode_oid",
+ "ctype" : "Oid",
+ "precomment" : "\n**TK_BLANK_LINE**",
+ "sqltype" : "oid"
+ },
+ {
+ "colname" : "segment_file_num",
+ "ctype" : "int4",
+ "sqltype" : "integer"
+ },
+ {
+ "colname" : "persistent_tid",
+ "ctype" : "tid",
+ "sqltype" : "tid"
+ },
+ {
+ "colname" : "persistent_serial_num",
+ "ctype" : "bigint",
+ "sqltype" : "bigint"
+ }
+ ],
+ "filename" : "gp_persistent.h",
+ "fk_list" : [
+ {
+ "fkcols" : [
+ "relfilenode_oid"
+ ],
+ "pkcols" : [
+ "oid"
+ ],
+ "pktable" : "pg_class",
+ "type" : "scalar"
+ }
+ ],
+ "foreign_keys" : [
+ [
+ [
+ "relfilenode_oid"
+ ],
+ "pg_class",
+ [
+ "oid"
+ ]
+ ]
+ ],
+ "relid_comment_tag" : "/* relation id: 5094 - gp_relfile_node */\n",
+ "tabdef_text" : "\n CREATE TABLE gp_relfile_node\n with (shared=false, oid=false, relid=5094, reltype_oid=6994, content=PERSISTENT)\n (\n relfilenode_oid oid ,\n segment_file_num integer ,\n persistent_tid tid ,\n persistent_serial_num bigint \n )",
+ "with" : {
+ "bootstrap" : 0,
+ "camelcase" : "GpRelfile_node",
+ "content" : "PERSISTENT",
+ "oid" : "",
+ "relid" : "5094",
+ "reltype_oid" : "6994",
+ "shared" : "",
+ "text" : "with (shared=false, oid=false, relid=5094, reltype_oid=6994, content=PERSISTENT)"
+ }
+ },
+ "gp_san_configuration" : {
+ "CamelCaseRelationId" : "GpSanConfigRelationId",
+ "UppercaseReltypeOid" : "GP_SAN_CONFIGURATION_RELTYPE_OID",
+ "colh" : {
+ "active_host" : "char",
+ "mirror_device" : "text",
+ "mirror_host" : "text",
+ "mirror_mountpoint" : "text",
+ "mountid" : "int2",
+ "primary_device" : "text",
+ "primary_host" : "text",
+ "primary_mountpoint" : "text",
+ "san_type" : "char"
+ },
+ "cols" : [
+ {
+ "colname" : "mountid",
+ "ctype" : "int2",
+ "precomment" : "\n**TK_BLANK_LINE**",
+ "sqltype" : "smallint"
+ },
+ {
+ "colname" : "active_host",
+ "ctype" : "char",
+ "sqltype" : "quoted_char"
+ },
+ {
+ "colname" : "san_type",
+ "ctype" : "char",
+ "sqltype" : "quoted_char"
+ },
+ {
+ "colname" : "primary_host",
+ "ctype" : "text",
+ "sqltype" : "text"
+ },
+ {
+ "colname" : "primary_mountpoint",
+ "ctype" : "text",
+ "sqltype" : "text"
+ },
+ {
+ "colname" : "primary_device",
+ "ctype" : "text",
+ "sqltype" : "text"
+ },
+ {
+ "colname" : "mirror_host",
+ "ctype" : "text",
+ "sqltype" : "text"
+ },
+ {
+ "colname" : "mirror_mountpoint",
+ "ctype" : "text",
+ "sqltype" : "text"
+ },
+ {
+ "colname" : "mirror_device",
+ "ctype" : "text",
+ "sqltype" : "text"
+ }
+ ],
+ "filename" : "gp_san_config.h",
+ "indexes" : [
+ {
+ "CamelCaseIndexId" : "GpSanConfigMountidIndexId",
+ "cols" : [
+ [
+ "mountid",
+ "int2_ops"
+ ]
+ ],
+ "indexid" : "6111",
+ "indexname" : "gp_san_config_mountid_index",
+ "unique" : "1",
+ "with" : {
+ "indexid" : "6111",
+ "indexname" : "gp_san_config_mountid_index"
+ }
+ }
+ ],
+ "relid_comment_tag" : "/* relation id: 5035 - gp_san_configuration */\n",
+ "tabdef_text" : "\n CREATE TABLE gp_san_configuration\n with (camelcase=GpSanConfig, shared=true, oid=false, relid=5035, reltype_oid=6444, content=MASTER_ONLY)\n (\n mountid smallint ,\n active_host \"char\" ,\n san_type \"char\" ,\n primary_host text ,\n primary_mountpoint text ,\n primary_device text ,\n mirror_host text ,\n mirror_mountpoint text ,\n mirror_device text \n )",
+ "with" : {
+ "bootstrap" : 0,
+ "camelcase" : "GpSanConfig",
+ "content" : "MASTER_ONLY",
+ "oid" : "",
+ "relid" : "5035",
+ "reltype_oid" : "6444",
+ "shared" : "1",
+ "text" : "with (camelcase=GpSanConfig, shared=true, oid=false, relid=5035, reltype_oid=6444, content=MASTER_ONLY)"
+ }
+ },
+ "gp_segment_configuration" : {
+ "CamelCaseRelationId" : "GpSegmentConfigRelationId",
+ "CamelCaseToastInd" : "GpSegmentConfigToastIndex",
+ "CamelCaseToastTab" : "GpSegmentConfigToastTable",
+ "UppercaseReltypeOid" : "GP_SEGMENT_CONFIGURATION_RELTYPE_OID",
+ "UppercaseToastReltypeOid" : "GP_SEGMENT_CONFIGURATION_TOAST_RELTYPE_OID",
+ "colh" : {
+ "address" : "text",
+ "description" : "text",
+ "hostname" : "text",
+ "port" : "int4",
+ "registration_order" : "int4",
+ "role" : "char",
+ "status" : "char"
+ },
+ "cols" : [
+ {
+ "colname" : "registration_order",
+ "ctype" : "int4",
+ "precomment" : "\n**TK_BLANK_LINE**",
+ "sqltype" : "integer"
+ },
+ {
+ "colname" : "role",
+ "ctype" : "char",
+ "sqltype" : "quoted_char"
+ },
+ {
+ "colname" : "status",
+ "ctype" : "char",
+ "sqltype" : "quoted_char"
+ },
+ {
+ "colname" : "port",
+ "ctype" : "int4",
+ "sqltype" : "integer"
+ },
+ {
+ "colname" : "hostname",
+ "ctype" : "text",
+ "sqltype" : "text"
+ },
+ {
+ "colname" : "address",
+ "ctype" : "text",
+ "sqltype" : "text"
+ },
+ {
+ "colname" : "description",
+ "ctype" : "text",
+ "sqltype" : "text"
+ }
+ ],
+ "filename" : "gp_segment_config.h",
+ "indexes" : [
+ {
+ "CamelCaseIndexId" : "GpSegmentConfigRegistration_orderIndexId",
+ "cols" : [
+ [
+ "registration_order",
+ "int4_ops"
+ ]
+ ],
+ "indexid" : "6106",
+ "indexname" : "gp_segment_config_registration_order_index",
+ "unique" : "1",
+ "with" : {
+ "indexid" : "6106",
+ "indexname" : "gp_segment_config_registration_order_index"
+ }
+ },
+ {
+ "CamelCaseIndexId" : "GpSegmentConfigRoleIndexId",
+ "cols" : [
+ [
+ "role",
+ "char_ops"
+ ]
+ ],
+ "indexid" : "6107",
+ "indexname" : "gp_segment_config_role_index",
+ "unique" : "",
+ "with" : {
+ "indexid" : "6107",
+ "indexname" : "gp_segment_config_role_index"
+ }
+ }
+ ],
+ "relid_comment_tag" : "/* relation id: 5036 - gp_segment_configuration */\n",
+ "tabdef_text" : "\n CREATE TABLE gp_segment_configuration\n with (camelcase=GpSegmentConfig, shared=true, oid=false, relid=5036, reltype_oid=6442, toast_oid=2900, toast_index=2901, toast_reltype=2906, content=MASTER_ONLY)\n (\n registration_order integer ,\n role \"char\" ,\n status \"char\" ,\n port integer ,\n hostname text ,\n address text ,\n description text\n )",
+ "with" : {
+ "bootstrap" : 0,
+ "camelcase" : "GpSegmentConfig",
+ "content" : "MASTER_ONLY",
+ "oid" : "",
+ "relid" : "5036",
+ "reltype_oid" : "6442",
+ "shared" : "1",
+ "text" : "with (camelcase=GpSegmentConfig, shared=true, oid=false, relid=5036, reltype_oid=6442, toast_oid=2900, toast_index=2901, toast_reltype=2906, content=MASTER_ONLY)",
+ "toast_index" : "2901",
+ "toast_oid" : "2900",
+ "toast_reltype" : "2906"
+ }
+ },
+ "gp_verification_history" : {
+ "CamelCaseRelationId" : "GpVerificationHistoryRelationId",
+ "UppercaseReltypeOid" : "GP_VERIFICATION_HISTORY_RELTYPE_OID",
+ "colh" : {
+ "vercontent" : "int2",
+ "verdone" : "bool",
+ "verendtime" : "timestamptz",
+ "vermismatch" : "bool",
+ "verstarttime" : "timestamptz",
+ "verstate" : "int2",
+ "vertoken" : "NameData",
+ "vertype" : "int2"
+ },
+ "cols" : [
+ {
+ "colname" : "vertoken",
+ "ctype" : "NameData",
+ "postcomment" : "-- token of the verification request, 63 characters or less",
+ "precomment" : "\n**TK_BLANK_LINE**\n**TK_BLANK_LINE**",
+ "sqltype" : "name"
+ },
+ {
+ "colname" : "vertype",
+ "ctype" : "int2",
+ "postcomment" : "-- 0=FULL (i.e. all files and directories), 1=FILE, 2=DIRECTORY",
+ "sqltype" : "smallint"
+ },
+ {
+ "colname" : "vercontent",
+ "ctype" : "int2",
+ "postcomment" : "-- -1= all primary mirror pairs, >=0 specific primary/mirror pair",
+ "sqltype" : "smallint"
+ },
+ {
+ "colname" : "verstarttime",
+ "ctype" : "timestamptz",
+ "postcomment" : "--time the request is started",
+ "precomment" : "\n**TK_BLANK_LINE**",
+ "sqltype" : "timestamp_with_time_zone"
+ },
+ {
+ "colname" : "verstate",
+ "ctype" : "int2",
+ "postcomment" : "-- 0=Started, 1=Suspended, 2=Aborted, 3=Failed, 4=Succeeded",
+ "sqltype" : "smallint"
+ },
+ {
+ "colname" : "verdone",
+ "ctype" : "bool",
+ "postcomment" : "--0 if started or suspeneded, 1 if aborted or failed or successful completion",
+ "precomment" : "\n ",
+ "sqltype" : "boolean"
+ },
+ {
+ "colname" : "verendtime",
+ "ctype" : "timestamptz",
+ "postcomment" : "--time the request is completely done processing, only valid id verdone is true, latest end time for this token on any primary/mirror pair",
+ "sqltype" : "timestamp_with_time_zone"
+ },
+ {
+ "colname" : "vermismatch",
+ "ctype" : "bool",
+ "postcomment" : "--were mismatches found on any primary/mirror pair for this token",
+ "precomment" : "\n**TK_BLANK_LINE**",
+ "sqltype" : "boolean"
+ }
+ ],
+ "filename" : "gp_verification_history.h",
+ "indexes" : [
+ {
+ "CamelCaseIndexId" : "GpVerificationHistoryVertokenIndexId",
+ "cols" : [
+ [
+ "vertoken",
+ "name_ops"
+ ]
+ ],
+ "indexid" : "6431",
+ "unique" : "1",
+ "with" : {
+ "indexid" : "6431"
+ }
+ }
+ ],
+ "relid_comment_tag" : "/* relation id: 6429 - gp_verification_history */\n",
+ "tabdef_text" : "\n CREATE TABLE gp_verification_history\n with (camelcase=GpVerificationHistory, shared=true, oid=false, relid=6429, reltype_oid=6430, content=MASTER_ONLY)\n (\n\n vertoken name , -- token of the verification request, 63 characters or less\n vertype smallint , -- 0=FULL (i.e. all files and directories), 1=FILE, 2=DIRECTORY\n vercontent smallint , -- -1= all primary mirror pairs, >=0 specific primary/mirror pair\n\n verstarttime timestamp with time zone, --time the request is started\n verstate smallint , -- 0=Started, 1=Suspended, 2=Aborted, 3=Failed, 4=Succeeded\n \n verdone boolean , --0 if started or suspeneded, 1 if aborted or failed or successful completion\n verendtime timestamp with time zone, --time the request is completely done processing, only valid id verdone is true, latest end time for this token on any primary/mirr
or pair\n\n vermismatch boolean --were mismatches found on any primary/mirror pair for this token\n \n )",
+ "tzhack" : "\"verstarttime\" et al",
+ "with" : {
+ "bootstrap" : 0,
+ "camelcase" : "GpVerificationHistory",
+ "content" : "MASTER_ONLY",
+ "oid" : "",
+ "relid" : "6429",
+ "reltype_oid" : "6430",
+ "shared" : "1",
+ "text" : "with (camelcase=GpVerificationHistory, shared=true, oid=false, relid=6429, reltype_oid=6430, content=MASTER_ONLY)"
+ }
+ },
+ "gp_version_at_initdb" : {
+ "CamelCaseRelationId" : "GpVersion_at_initdbRelationId",
+ "colh" : {
+ "productversion" : "text",
+ "schemaversion" : "int2"
+ },
+ "cols" : [
+ {
+ "colname" : "schemaversion",
+ "ctype" : "int2",
+ "precomment" : "\n**TK_BLANK_LINE**",
+ "sqltype" : "smallint"
+ },
+ {
+ "colname" : "productversion",
+ "ctype" : "text",
+ "sqltype" : "text"
+ }
+ ],
+ "filename" : "gp_version.h",
+ "relid_comment_tag" : "/* relation id: 5003 - gp_version_at_initdb */\n",
+ "tabdef_text" : "\n CREATE TABLE gp_version_at_initdb\n with (shared=true, oid=false, relid=5003)\n (\n schemaversion smallint ,\n\tproductversion text \n )",
+ "with" : {
+ "bootstrap" : 0,
+ "camelcase" : "GpVersion_at_initdb",
+ "oid" : "",
+ "relid" : "5003",
+ "shared" : "1",
+ "text" : "with (shared=true, oid=false, relid=5003)"
+ }
+ },
+ "pg_aggregate" : {
+ "CamelCaseRelationId" : "AggregateRelationId",
+ "colh" : {
+ "aggfinalfn" : "regproc",
+ "aggfnoid" : "regproc",
+ "agginitval" : "text",
+ "agginvprelimfn" : "regproc",
+ "agginvtransfn" : "regproc",
+ "aggordered" : "bool",
+ "aggprelimfn" : "regproc",
+ "aggsortop" : "Oid",
+ "aggtransfn" : "regproc",
+ "aggtranstype" : "Oid"
+ },
+ "cols" : [
+ {
+ "colname" : "aggfnoid",
+ "ctype" : "regproc",
+ "precomment" : "\n**TK_BLANK_LINE**",
+ "sqltype" : "regproc"
+ },
+ {
+ "colname" : "aggtransfn",
+ "ctype" : "regproc",
+ "sqltype" : "regproc"
+ },
+ {
+ "colname" : "agginvtransfn",
+ "ctype" : "regproc",
+ "postcomment" : "-- MPP windowing",
+ "sqltype" : "regproc"
+ },
+ {
+ "colname" : "aggprelimfn",
+ "ctype" : "regproc",
+ "postcomment" : "-- MPP 2-phase agg",
+ "sqltype" : "regproc"
+ },
+ {
+ "colname" : "agginvprelimfn",
+ "ctype" : "regproc",
+ "postcomment" : "-- MPP windowing",
+ "sqltype" : "regproc"
+ },
+ {
+ "colname" : "aggfinalfn",
+ "ctype" : "regproc",
+ "sqltype" : "regproc"
+ },
+ {
+ "colname" : "aggsortop",
+ "ctype" : "Oid",
+ "sqltype" : "oid"
+ },
+ {
+ "colname" : "aggtranstype",
+ "ctype" : "Oid",
+ "sqltype" : "oid"
+ },
+ {
+ "colname" : "agginitval",
+ "ctype" : "text",
+ "postcomment" : "-- VARIABLE LENGTH FIELD",
+ "sqltype" : "text"
+ },
+ {
+ "colname" : "aggordered",
+ "ctype" : "bool",
+ "postcomment" : "-- MPP ordered aggregates",
+ "sqltype" : "bool"
+ }
+ ],
+ "filename" : "pg_aggregate.h",
+ "fk_list" : [
+ {
+ "fkcols" : [
+ "aggfnoid"
+ ],
+ "pkcols" : [
+ "oid"
+ ],
+ "pktable" : "pg_proc",
+ "type" : "scalar"
+ },
+ {
+ "fkcols" : [
+ "aggtransfn"
+ ],
+ "pkcols" : [
+ "oid"
+ ],
+ "pktable" : "pg_proc",
+ "type" : "scalar"
+ },
+ {
+ "fkcols" : [
+ "agginvtransfn"
+ ],
+ "pkcols" : [
+ "oid"
+ ],
+ "pktable" : "pg_proc",
+ "type" : "scalar"
+ },
+ {
+ "fkcols" : [
+ "aggprelimfn"
+ ],
+ "pkcols" : [
+ "oid"
+ ],
+ "pktable" : "pg_proc",
+ "type" : "scalar"
+ },
+ {
+ "fkcols" : [
+ "agginvprelimfn"
+ ],
+ "pkcols" : [
+ "oid"
+ ],
+ "pktable" : "pg_proc",
+ "type" : "scalar"
+ },
+ {
+ "fkcols" : [
+ "aggfinalfn"
+ ],
+ "pkcols" : [
+ "oid"
+ ],
+ "pktable" : "pg_proc",
+ "type" : "scalar"
+ },
+ {
+ "fkcols" : [
+ "aggsortop"
+ ],
+ "pkcols" : [
+ "oid"
+ ],
+ "pktable" : "pg_operator",
+ "type" : "scalar"
+ },
+ {
+ "fkcols" : [
+ "aggtranstype"
+ ],
+ "pkcols" : [
+ "oid"
+ ],
+ "pktable" : "pg_type",
+ "type" : "scalar"
+ }
+ ],
+ "foreign_keys" : [
+ [
+ [
+ "aggfnoid"
+ ],
+ "pg_proc",
+ [
+ "oid"
+ ]
+ ],
+ [
+ [
+ "aggtransfn"
+ ],
+ "pg_proc",
+ [
+ "oid"
+ ]
+ ],
+ [
+ [
+ "agginvtransfn"
+ ],
+ "pg_proc",
+ [
+ "oid"
+ ]
+ ],
+ [
+ [
+ "aggprelimfn"
+ ],
+ "pg_proc",
+ [
+ "oid"
+ ]
+ ],
+ [
+ [
+ "agginvprelimfn"
+ ],
+ "pg_proc",
+ [
+ "oid"
+ ]
+ ],
+ [
+ [
+ "aggfinalfn"
+ ],
+ "pg_proc",
+ [
+ "oid"
+ ]
+ ],
+ [
+ [
+ "aggsortop"
+ ],
+ "pg_operator",
+ [
+ "oid"
+ ]
+ ],
+ [
+ [
+ "aggtranstype"
+ ],
+ "pg_type",
+ [
+ "oid"
+ ]
+ ]
+ ],
+ "indexes" : [
+ {
+ "CamelCaseIndexId" : "AggregateAggfnoidIndexId",
+ "cols" : [
+ [
+ "aggfnoid",
+ "oid_ops"
+ ]
+ ],
+ "indexid" : "2650",
+ "indexname" : "pg_aggregate_fnoid_index",
+ "unique" : "1",
+ "with" : {
+ "indexid" : "2650",
+ "indexname" : "pg_aggregate_fnoid_index",
+ "syscache_nbuckets" : "32",
+ "syscacheid" : "AGGFNOID"
+ }
+ }
+ ],
+ "relid_comment_tag" : "/* relation id: 2600 - pg_aggregate */\n",
+ "tabdef_text" : "\n CREATE TABLE pg_aggregate\n with (oid=false, relid=2600)\n (\n aggfnoid regproc, \n aggtransfn regproc, \n agginvtransfn regproc, -- MPP windowing\n aggprelimfn regproc, -- MPP 2-phase agg\n agginvprelimfn regproc, -- MPP windowing\n aggfinalfn regproc, \n aggsortop oid, \n aggtranstype oid, \n agginitval text, -- VARIABLE LENGTH FIELD\n aggordered bool -- MPP ordered aggregates\n )",
+ "with" : {
+ "bootstrap" : 0,
+ "camelcase" : "Aggregate",
+ "oid" : "",
+ "relid" : "2600",
+ "shared" : 0,
+ "text" : "with (oid=false, relid=2600)"
+ }
+ },
+ "pg_am" : {
+ "CamelCaseRelationId" : "AccessMethodRelationId",
+ "colh" : {
+ "ambeginscan" : "regproc",
+ "ambuild" : "regproc",
+ "ambulkdelete" : "regproc",
+ "amcanmulticol" : "bool",
+ "amcanshrink" : "bool",
+ "amcanunique" : "bool",
+ "amclusterable" : "bool",
+ "amcostestimate" : "regproc",
+ "amendscan" : "regproc",
+ "amgetmulti" : "regproc",
+ "amgettuple" : "regproc",
+ "amindexnulls" : "bool",
+ "aminsert" : "regproc",
+ "ammarkpos" : "regproc",
+ "amname" : "NameData",
+ "amoptionalkey" : "bool",
+ "amoptions" : "regproc",
+ "amorderstrategy" : "int2",
+ "amrescan" : "regproc",
+ "amrestrpos" : "regproc",
+ "amstorage" : "bool",
+ "amstrategies" : "int2",
+ "amsupport" : "int2",
+ "amvacuumcleanup" : "regproc",
+ "oid" : "Oid"
+ },
+ "cols" : [
+ {
+ "colname" : "amname",
+ "ctype" : "NameData",
+ "precomment" : "\n**TK_BLANK_LINE**",
+ "sqltype" : "name"
+ },
+ {
+ "colname" : "amstrategies",
+ "ctype" : "int2",
+ "sqltype" : "smallint"
+ },
+ {
+ "colname" : "amsupport",
+ "ctype" : "int2",
+ "sqltype" : "smallint"
+ },
+ {
+ "colname" : "amorderstrategy",
+ "ctype" : "int2",
+ "sqltype" : "smallint"
+ },
+ {
+ "colname" : "amcanunique",
+ "ctype" : "bool",
+ "sqltype" : "boolean"
+ },
+ {
+ "colname" : "amcanmulticol",
+ "ctype" : "bool",
+ "sqltype" : "boolean"
+ },
+ {
+ "colname" : "amoptionalkey",
+ "ctype" : "bool",
+ "sqltype" : "boolean"
+ },
+ {
+ "colname" : "amindexnulls",
+ "ctype" : "bool",
+ "sqltype" : "boolean"
+ },
+ {
+ "colname" : "amstorage",
+ "ctype" : "bool",
+ "sqltype" : "boolean"
+ },
+ {
+ "colname" : "amclusterable",
+ "ctype" : "bool",
+ "sqltype" : "boolean"
+ },
+ {
+ "colname" : "amcanshrink",
+ "ctype" : "bool",
+ "sqltype" : "boolean"
+ },
+ {
+ "colname" : "aminsert",
+ "ctype" : "regproc",
+ "sqltype" : "regproc"
+ },
+ {
+ "colname" : "ambeginscan",
+ "ctype" : "regproc",
+ "sqltype" : "regproc"
+ },
+ {
+ "colname" : "amgettuple",
+ "ctype" : "regproc",
+ "sqltype" : "regproc"
+ },
+ {
+ "colname" : "amgetmulti",
+ "ctype" : "regproc",
+ "sqltype" : "regproc"
+ },
+ {
+ "colname" : "amrescan",
+ "ctype" : "regproc",
+ "sqltype" : "regproc"
+ },
+ {
+ "colname" : "amendscan",
+ "ctype" : "regproc",
+ "sqltype" : "regproc"
+ },
+ {
+ "colname" : "ammarkpos",
+ "ctype" : "regproc",
+ "sqltype" : "regproc"
+ },
+ {
+ "colname" : "amrestrpos",
+ "ctype" : "regproc",
+ "sqltype" : "regproc"
+ },
+ {
+ "colname" : "ambuild",
+ "ctype" : "regproc",
+ "sqltype" : "regproc"
+ },
+ {
+ "colname" : "ambulkdelete",
+ "ctype" : "regproc",
+ "sqltype" : "regproc"
+ },
+ {
+ "colname" : "amvacuumcleanup",
+ "ctype" : "regproc",
+ "sqltype" : "regproc"
+ },
+ {
+ "colname" : "amcostestimate",
+ "ctype" : "regproc",
+ "sqltype" : "regproc"
+ },
+ {
+ "colname" : "amoptions",
+ "ctype" : "regproc",
+ "sqltype" : "regproc"
+ }
+ ],
+ "filename" : "pg_am.h",
+ "fk_list" : [
+ {
+ "fkcols" : [
+ "aminsert"
+ ],
+ "pkcols" : [
+ "oid"
+ ],
+ "pktable" : "pg_proc",
+ "type" : "scalar"
+ },
+ {
+ "fkcols" : [
+ "ambeginscan"
+ ],
+ "pkcols" : [
+ "oid"
+ ],
+ "pktable" : "pg_proc",
+ "type" : "scalar"
+ },
+ {
+ "fkcols" : [
+ "amgettuple"
+ ],
+ "pkcols" : [
+ "oid"
+ ],
+ "pktable" : "pg_proc",
+ "type" : "scalar"
+ },
+ {
+ "fkcols" : [
+ "amgetmulti"
+ ],
+ "pkcols" : [
+ "oid"
+ ],
+ "pktable" : "pg_proc",
+ "type" : "scalar"
+ },
+ {
+ "fkcols" : [
+ "amrescan"
+ ],
+ "pkcols" : [
+ "oid"
+ ],
+ "pktable" : "pg_proc",
+ "type" : "scalar"
+ },
+ {
+ "fkcols" : [
+ "amendscan"
+ ],
+ "pkcols" : [
+ "oid"
+ ],
+ "pktable" : "pg_proc",
+ "type" : "scalar"
+ },
+ {
+ "fkcols" : [
+ "ammarkpos"
+ ],
+ "pkcols" : [
+ "oid"
+ ],
+ "pktable" : "pg_proc",
+ "type" : "scalar"
+ },
+ {
+ "fkcols" : [
+ "amrestrpos"
+ ],
+ "pkcols" : [
+ "oid"
+ ],
+ "pktable" : "pg_proc",
+ "type" : "scalar"
+ },
+ {
+ "fkcols" : [
+ "ambuild"
+ ],
+ "pkcols" : [
+ "oid"
+ ],
+ "pktable" : "pg_proc",
+ "type" : "scalar"
+ },
+ {
+ "fkcols" : [
+ "ambulkdelete"
+ ],
+ "pkcols" : [
+ "oid"
+ ],
+ "pktable" : "pg_proc",
+ "type" : "scalar"
+ },
+ {
+ "fkcols" : [
+ "amvacuumcleanup"
+ ],
+ "pkcols" : [
+ "oid"
+ ],
+ "pktable" : "pg_proc",
+ "type" : "scalar"
+ },
+ {
+ "fkcols" : [
+ "amcostestimate"
+ ],
+ "pkcols" : [
+ "oid"
+ ],
+ "pktable" : "pg_proc",
+ "type" : "scalar"
+ },
+ {
+ "fkcols" : [
+ "amoptions"
+ ],
+ "pkcols" : [
+ "oid"
+ ],
+ "pktable" : "pg_proc",
+ "type" : "scalar"
+ }
+ ],
+ "foreign_keys" : [
+ [
+ [
+ "aminsert"
+ ],
+ "pg_proc",
+ [
+ "oid"
+ ]
+ ],
+ [
+ [
+ "ambeginscan"
+ ],
+ "pg_proc",
+ [
+ "oid"
+ ]
+ ],
+ [
+ [
+ "amgettuple"
+ ],
+ "pg_proc",
+ [
+ "oid"
+ ]
+ ],
+ [
+ [
+ "amgetmulti"
+ ],
+ "pg_proc",
+ [
+ "oid"
+ ]
+ ],
+ [
+ [
+ "amrescan"
+ ],
+ "pg_proc",
+ [
+ "oid"
+ ]
+ ],
+ [
+ [
+ "amendscan"
+ ],
+ "pg_proc",
+ [
+ "oid"
+ ]
+ ],
+ [
+ [
+ "ammarkpos"
+ ],
+ "pg_proc",
+ [
+ "oid"
+ ]
+ ],
+ [
+ [
+ "amrestrpos"
+ ],
+ "pg_proc",
+ [
+ "oid"
+ ]
+ ],
+ [
+ [
+ "ambuild"
+ ],
+ "pg_proc",
+ [
+ "oid"
+ ]
+ ],
+ [
+ [
+ "ambulkdelete"
+ ],
+ "pg_proc",
+ [
+ "oid"
+ ]
+ ],
+ [
+ [
+ "amvacuumcleanup"
+ ],
+ "pg_proc",
+ [
+ "oid"
+ ]
+ ],
+ [
+ [
+ "amcostestimate"
+ ],
+ "pg_proc",
+ [
+ "oid"
+ ]
+ ],
+ [
+ [
+ "amoptions"
+ ],
+ "pg_proc",
+ [
+ "oid"
+ ]
+ ]
+ ],
+ "indexes" : [
+ {
+ "CamelCaseIndexId" : "AmNameIndexId",
+ "cols" : [
+ [
+ "amname",
+ "name_ops"
+ ]
+ ],
+ "indexid" : "2651",
+ "unique" : "1",
+ "with" : {
+ "camelcase" : "AmName",
+ "indexid" : "2651",
+ "syscache_nbuckets" : "4",
+ "syscacheid" : "AMNAME"
+ }
+ },
+ {
+ "CamelCaseIndexId" : "AmOidIndexId",
+ "cols" : [
+ [
+ "oid",
+ "oid_ops"
+ ]
+ ],
+ "indexid" : "2652",
+ "unique" : "1",
+ "with" : {
+ "camelcase" : "AmOid",
+ "indexid" : "2652",
+ "syscache_nbuckets" : "4",
+ "syscacheid" : "AMOID"
+ }
+ }
+ ],
+ "relid_comment_tag" : "/* relation id: 2601 - pg_am */\n",
+ "tabdef_text" : "\n CREATE TABLE pg_am\n with (camelcase=AccessMethod, relid=2601)\n (\n amname name, \n amstrategies smallint, \n amsupport smallint, \n amorderstrategy smallint, \n amcanunique boolean, \n amcanmulticol boolean, \n amoptionalkey boolean, \n amindexnulls boolean, \n amstorage boolean, \n amclusterable boolean, \n amcanshrink boolean, \n aminsert regproc, \n ambeginscan regproc, \n amgettuple regproc, \n amgetmulti regproc, \n amrescan regproc, \n amendscan regproc, \n ammarkpos regproc, \n amrestrpos regproc, \n ambuild regproc, \n ambulkdelete regproc, \n amvacuumcleanup regproc, \n amcostestimate regproc, \n amoptions regproc\n )",
+ "with" : {
+ "bootstrap" : 0,
+ "camelcase" : "AccessMethod",
+ "oid" : 1,
+ "relid" : "2601",
+ "shared" : 0,
+ "text" : "with (camelcase=AccessMethod, relid=2601)"
+ }
+ },
+ "pg_amop" : {
+ "CamelCaseRelationId" : "AccessMethodOperatorRelationId",
+ "colh" : {
+ "amopclaid" : "Oid",
+ "amopopr" : "Oid",
+ "amopreqcheck" : "bool",
+ "amopstrategy" : "int2",
+ "amopsubtype" : "Oid"
+ },
+ "cols" : [
+ {
+ "colname" : "amopclaid",
+ "ctype" : "Oid",
+ "precomment" : "\n**TK_BLANK_LINE**",
+ "sqltype" : "oid"
+ },
+ {
+ "colname" : "amopsubtype",
+ "ctype" : "Oid",
+ "sqltype" : "oid"
+ },
+ {
+ "colname" : "amopstrategy",
+ "ctype" : "int2",
+ "sqltype" : "smallint"
+ },
+ {
+ "colname" : "amopreqcheck",
+ "ctype" : "bool",
+ "sqltype" : "boolean"
+ },
+ {
+ "colname" : "amopopr",
+ "ctype" : "Oid",
+ "sqltype" : "oid"
+ }
+ ],
+ "filename" : "pg_amop.h",
+ "fk_list" : [
+ {
+ "fkcols" : [
+ "amopclaid"
+ ],
+ "pkcols" : [
+ "oid"
+ ],
+ "pktable" : "pg_opclass",
+ "type" : "scalar"
+ },
+ {
+ "fkcols" : [
+ "amopsubtype"
+ ],
+ "pkcols" : [
+ "oid"
+ ],
+ "pktable" : "pg_type",
+ "type" : "scalar"
+ },
+ {
+ "fkcols" : [
+ "amopopr"
+ ],
+ "pkcols" : [
+ "oid"
+ ],
+ "pktable" : "pg_operator",
+ "type" : "scalar"
+ }
+ ],
+ "foreign_keys" : [
+ [
+ [
+ "amopclaid"
+ ],
+ "pg_opclass",
+ [
+ "oid"
+ ]
+ ],
+ [
+ [
+ "amopsubtype"
+ ],
+ "pg_type",
+ [
+ "oid"
+ ]
+ ],
+ [
+ [
+ "amopopr"
+ ],
+ "pg_operator",
+ [
+ "oid"
+ ]
+ ]
+ ],
+ "indexes" : [
+ {
+ "CamelCaseIndexId" : "AccessMethodStrategyIndexId",
+ "cols" : [
+ [
+ "amopclaid",
+ "oid_ops"
+ ],
+ [
+ "amopsubtype",
+ "oid_ops"
+ ],
+ [
+ "amopstrategy",
+ "int2_ops"
+ ]
+ ],
+ "indexid" : "2653",
+ "unique" : "1",
+ "with" : {
+ "camelcase" : "AccessMethodStrategy",
+ "indexid" : "2653",
+ "syscache_nbuckets" : "64",
+ "syscacheid" : "AMOPSTRATEGY"
+ }
+ },
+ {
+ "CamelCaseIndexId" : "AccessMethodOperatorIndexId",
+ "cols" : [
+ [
+ "amopopr",
+ "oid_ops"
+ ],
+ [
+ "amopclaid",
+ "oid_ops"
+ ]
+ ],
+ "indexid" : "2654",
+ "unique" : "1",
+ "with" : {
+ "camelcase" : "AccessMethodOperator",
+ "indexid" : "2654",
+ "syscache_nbuckets" : "64",
+ "syscacheid" : "AMOPOPID"
+ }
+ }
+ ],
+ "relid_comment_tag" : "/* relation id: 2602 - pg_amop */\n",
+ "tabdef_text" : "\n CREATE TABLE pg_amop\n with (camelcase=AccessMethodOperator, oid=false, relid=2602)\n (\n amopclaid oid, \n amopsubtype oid, \n amopstrategy smallint, \n amopreqcheck boolean, \n amopopr oid\n )",
+ "with" : {
+ "bootstrap" : 0,
+ "camelcase" : "AccessMethodOperator",
+ "oid" : "",
+ "relid" : "2602",
+ "shared" : 0,
+ "text" : "with (camelcase=AccessMethodOperator, oid=false, relid=2602)"
+ }
+ },
+ "pg_amproc" : {
+ "CamelCaseRelationId" : "AccessMethodProcedureRelationId",
+ "colh" : {
+ "amopclaid" : "Oid",
+ "amproc" : "regproc",
+ "amprocnum" : "int2",
+ "amprocsubtype" : "Oid"
+ },
+ "cols" : [
+ {
+ "colname" : "amopclaid",
+ "ctype" : "Oid",
+ "precomment" : "\n**TK_BLANK_LINE**",
+ "sqltype" : "oid"
+ },
+ {
+ "colname" : "amprocsubtype",
+ "ctype" : "Oid",
+ "sqltype" : "oid"
+ },
+ {
+ "colname" : "amprocnum",
+ "ctype" : "int2",
+ "sqltype" : "smallint"
+ },
+ {
+ "colname" : "amproc",
+ "ctype" : "regproc",
+ "sqltype" : "regproc"
+ }
+ ],
+ "filename" : "pg_amproc.h",
+ "fk_list" : [
+ {
+ "fkcols" : [
+ "amopclaid"
+ ],
+ "pkcols" : [
+ "oid"
+ ],
+ "pktable" : "pg_opclass",
+ "type" : "scalar"
+ },
+ {
+ "fkcols" : [
+ "amprocsubtype"
+ ],
+ "pkcols" : [
+ "oid"
+ ],
+ "pktable" : "pg_type",
+ "type" : "scalar"
+ },
+ {
+ "fkcols" : [
+ "amproc"
+ ],
+ "pkcols" : [
+ "oid"
+ ],
+ "pktable" : "pg_proc",
+ "type" : "scalar"
+ }
+ ],
+ "foreign_keys" : [
+ [
+ [
+ "amopclaid"
+ ],
+ "pg_opclass",
+ [
+ "oid"
+ ]
+ ],
+ [
+ [
+ "amprocsubtype"
+ ],
+ "pg_type",
+ [
+ "oid"
+ ]
+ ],
+ [
+ [
+ "amproc"
+ ],
+ "pg_proc",
+ [
+ "oid"
+ ]
+ ]
+ ],
+ "indexes" : [
+ {
+ "CamelCaseIndexId" : "AccessMethodProcedureIndexId",
+ "cols" : [
+ [
+ "amopclaid",
+ "oid_ops"
+ ],
+ [
+ "amprocsubtype",
+ "oid_ops"
+ ],
+ [
+ "amprocnum",
+ "int2_ops"
+ ]
+ ],
+ "indexid" : "2655",
+ "unique" : "1",
+ "with" : {
+ "camelcase" : "AccessMethodProcedure",
+ "indexid" : "2655",
+ "syscache_nbuckets" : "64",
+ "syscacheid" : "AMPROCNUM"
+ }
+ }
+ ],
+ "relid_comment_tag" : "/* relation id: 2603 - pg_amproc */\n",
+ "tabdef_text" : "\n CREATE TABLE pg_amproc\n with (camelcase=AccessMethodProcedure, oid=false, relid=2603)\n (\n amopclaid oid, \n amprocsubtype oid, \n amprocnum smallint, \n amproc regproc\n )",
+ "with" : {
+ "bootstrap" : 0,
+ "camelcase" : "AccessMethodProcedure",
+ "oid" : "",
+ "relid" : "2603",
+ "shared" : 0,
+ "text" : "with (camelcase=AccessMethodProcedure, oid=false, relid=2603)"
+ }
+ },
+ "pg_appendonly" : {
+ "CamelCaseRelationId" : "AppendOnlyRelationId",
+ "colh" : {
+ "blkdiridxid" : "Oid",
+ "blkdirrelid" : "Oid",
+ "blocksize" : "int4",
+ "checksum" : "bool",
+ "columnstore" : "bool",
+ "compresslevel" : "int2",
+ "compresstype" : "text",
+ "majorversion" : "int2",
+ "minorversion" : "int2",
+ "pagesize" : "int4",
+ "relid" : "Oid",
+ "safefswritesize" : "int4",
+ "segidxid" : "Oid",
+ "segrelid" : "Oid",
+ "splitsize" : "int4",
+ "version" : "int4"
+ },
+ "cols" : [
+ {
+ "colname" : "relid",
+ "ctype" : "Oid",
+ "precomment" : "\n**TK_BLANK_LINE**",
+ "sqltype" : "oid"
+ },
+ {
+ "colname" : "blocksize",
+ "ctype" : "int4",
+ "sqltype" : "integer"
+ },
+ {
+ "colname" : "safefswritesize",
+ "ctype" : "int4",
+ "sqltype" : "integer"
+ },
+ {
+ "colname" : "compresslevel",
+ "ctype" : "int2",
+ "sqltype" : "smallint"
+ },
+ {
+ "colname" : "majorversion",
+ "ctype" : "int2",
+ "sqltype" : "smallint"
+ },
+ {
+ "colname" : "minorversion",
+ "ctype" : "int2",
+ "sqltype" : "smallint"
+ },
+ {
+ "colname" : "checksum",
+ "ctype" : "bool",
+ "sqltype" : "boolean"
+ },
+ {
+ "colname" : "compresstype",
+ "ctype" : "text",
+ "sqltype" : "text"
+ },
+ {
+ "colname" : "columnstore",
+ "ctype" : "bool",
+ "sqltype" : "boolean"
+ },
+ {
+ "colname" : "segrelid",
+ "ctype" : "Oid",
+ "sqltype" : "oid"
+ },
+ {
+ "colname" : "segidxid",
+ "ctype" : "Oid",
+ "sqltype" : "oid"
+ },
+ {
+ "colname" : "blkdirrelid",
+ "ctype" : "Oid",
+ "sqltype" : "oid"
+ },
+ {
+ "colname" : "blkdiridxid",
+ "ctype" : "Oid",
+ "sqltype" : "oid"
+ },
+ {
+ "colname" : "version",
+ "ctype" : "int4",
+ "sqltype" : "integer"
+ },
+ {
+ "colname" : "pagesize",
+ "ctype" : "int4",
+ "sqltype" : "integer"
+ },
+ {
+ "colname" : "splitsize",
+ "ctype" : "int4",
+ "sqltype" : "integer"
+ }
+ ],
+ "filename" : "pg_appendonly.h",
+ "fk_list" : [
+ {
+ "fkcols" : [
+ "relid"
+ ],
+ "pkcols" : [
+ "oid"
+ ],
+ "pktable" : "pg_class",
+ "type" : "scalar"
+ }
+ ],
+ "foreign_keys" : [
+ [
+ [
+ "relid"
+ ],
+ "pg_class",
+ [
+ "oid"
+ ]
+ ]
+ ],
+ "indexes" : [
+ {
+ "CamelCaseIndexId" : "AppendOnlyRelidIndexId",
+ "cols" : [
+ [
+ "relid",
+ "oid_ops"
+ ]
+ ],
+ "indexid" : "5007",
+ "unique" : "1",
+ "with" : {
+ "camelcase" : "AppendOnlyRelid",
+ "indexid" : "5007"
+ }
+ }
+ ],
+ "relid_comment_tag" : "/* relation id: 6105 - pg_appendonly */\n",
+ "tabdef_text" : "\n CREATE TABLE pg_appendonly\n with (camelcase=AppendOnly, oid=false, relid=6105)\n (\n relid oid, \n blocksize integer, \n safefswritesize integer, \n compresslevel smallint, \n majorversion smallint, \n minorversion smallint, \n checksum boolean, \n compresstype text, \n columnstore boolean,\n segrelid oid, \n segidxid oid, \n blkdirrelid oid, \n blkdiridxid oid, \n version integer,\n pagesize\t\t\tinteger,\n splitsize integer\n )",
+ "with" : {
+ "bootstrap" : 0,
+ "camelcase" : "AppendOnly",
+ "oid" : "",
+ "relid" : "6105",
+ "shared" : 0,
+ "text" : "with (camelcase=AppendOnly, oid=false, relid=6105)"
+ }
+ },
+ "pg_appendonly_alter_column" : {
+ "CamelCaseRelationId" : "AppendOnlyAlterColumnRelationId",
+ "UppercaseReltypeOid" : "PG_APPENDONLY_ALTER_COLUMN_RELTYPE_OID",
+ "colh" : {
+ "changenum" : "int4",
+ "highwaterrownums" : "bytea",
+ "relid" : "Oid",
+ "segfilenums" : "int4[1]"
+ },
+ "cols" : [
+ {
+ "colname" : "relid",
+ "ctype" : "Oid",
+ "precomment" : "\n**TK_BLANK_LINE**",
+ "sqltype" : "oid"
+ },
+ {
+ "colname" : "changenum",
+ "ctype" : "int4",
+ "sqltype" : "integer"
+ },
+ {
+ "colname" : "segfilenums",
+ "ctype" : "int4[1]",
+ "sqltype" : "integer[]"
+ },
+ {
+ "colname" : "highwaterrownums",
+ "ctype" : "bytea",
+ "sqltype" : "bytea"
+ }
+ ],
+ "filename" : "pg_appendonly_alter_column.h",
+ "fk_list" : [
+ {
+ "fkcols" : [
+ "relid"
+ ],
+ "pkcols" : [
+ "oid"
+ ],
+ "pktable" : "pg_class",
+ "type" : "scalar"
+ }
+ ],
+ "foreign_keys" : [
+ [
+ [
+ "relid"
+ ],
+ "pg_class",
+ [
+ "oid"
+ ]
+ ]
+ ],
+ "indexes" : [
+ {
+ "CamelCaseIndexId" : "AppendOnlyAlterColumnRelidIndexId",
+ "cols" : [
+ [
+ "relid",
+ "oid_ops"
+ ],
+ [
+ "changenum",
+ "int4_ops"
+ ]
+ ],
+ "indexid" : "5031",
+ "unique" : "1",
+ "with" : {
+ "camelcase" : "AppendOnlyAlterColumnRelid",
+ "indexid" : "5031"
+ }
+ }
+ ],
+ "relid_comment_tag" : "/* relation id: 6110 - pg_appendonly_alter_column */\n",
+ "tabdef_text" : "\n CREATE TABLE pg_appendonly_alter_column\n with (camelcase=AppendOnlyAlterColumn, oid=false, relid=6110, reltype_oid=6437)\n (\n relid oid, \n changenum integer, \n segfilenums integer[], \n highwaterrownums bytea\n )",
+ "with" : {
+ "bootstrap" : 0,
+ "camelcase" : "AppendOnlyAlterColumn",
+ "oid" : "",
+ "relid" : "6110",
+ "reltype_oid" : "6437",
+ "shared" : 0,
+ "text" : "with (camelcase=AppendOnlyAlterColumn, oid=false, relid=6110, reltype_oid=6437)"
+ }
+ },
+ "pg_attrdef" : {
+ "CamelCaseRelationId" : "AttrDefaultRelationId",
+ "CamelCaseToastInd" : "PgAttrDefaultToastIndex",
+ "CamelCaseToastTab" : "PgAttrDefaultToastTable",
+ "colh" : {
+ "adbin" : "text",
+ "adnum" : "int2",
+ "adrelid" : "Oid",
+ "adsrc" : "text",
+ "oid" : "Oid"
+ },
+ "cols" : [
+ {
+ "colname" : "adrelid",
+ "ctype" : "Oid",
+ "precomment" : "\n**TK_BLANK_LINE**",
+ "sqltype" : "oid"
+ },
+ {
+ "colname" : "adnum",
+ "ctype" : "int2",
+ "sqltype" : "smallint"
+ },
+ {
+ "colname" : "adbin",
+ "ctype" : "text",
+ "sqltype" : "text"
+ },
+ {
+ "colname" : "adsrc",
+ "ctype" : "text",
+ "sqltype" : "text"
+ }
+ ],
+ "filename" : "pg_attrdef.h",
+ "fk_list" : [
+ {
+ "fkcols" : [
+ "adrelid"
+ ],
+ "pkcols" : [
+ "attrelid"
+ ],
+ "pktable" : "pg_attribute",
+ "type" : "scalar"
+ }
+ ],
+ "foreign_keys" : [
+ [
+ [
+ "adrelid"
+ ],
+ "pg_attribute",
+ [
+ "attrelid"
+ ]
+ ]
+ ],
+ "indexes" : [
+ {
+ "CamelCaseIndexId" : "AttrDefaultIndexId",
+ "cols" : [
+ [
+ "adrelid",
+ "oid_ops"
+ ],
+ [
+ "adnum",
+ "int2_ops"
+ ]
+ ],
+ "indexid" : "2656",
+ "unique" : "1",
+ "with" : {
+ "camelcase" : "AttrDefault",
+ "indexid" : "2656"
+ }
+ },
+ {
+ "CamelCaseIndexId" : "AttrDefaultOidIndexId",
+ "cols" : [
+ [
+ "oid",
+ "oid_ops"
+ ]
+ ],
+ "indexid" : "2657",
+ "unique" : "1",
+ "with" : {
+ "camelcase" : "AttrDefaultOid",
+ "indexid" : "2657"
+ }
+ }
+ ],
+ "relid_comment_tag" : "/* relation id: 2604 - pg_attrdef */\n",
+ "tabdef_text" : "\n CREATE TABLE pg_attrdef\n with (camelcase=AttrDefault, relid=2604, toast_oid=2830, toast_index=2831)\n (\n adrelid oid, \n adnum smallint, \n adbin text, \n adsrc text\n )",
+ "with" : {
+ "bootstrap" : 0,
+ "camelcase" : "AttrDefault",
+ "oid" : 1,
+ "relid" : "2604",
+ "shared" : 0,
+ "text" : "with (camelcase=AttrDefault, relid=2604, toast_oid=2830, toast_index=2831)",
+ "toast_index" : "2831",
+ "toast_oid" : "2830"
+ }
+ },
+ "pg_attribute" : {
+ "CamelCaseRelationId" : "AttributeRelationId",
+ "colh" : {
+ "attalign" : "char",
+ "attbyval" : "bool",
+ "attcacheoff" : "int4",
+ "atthasdef" : "bool",
+ "attinhcount" : "int4",
+ "attisdropped" : "bool",
+ "attislocal" : "bool",
+ "attlen" : "int2",
+ "attname" : "NameData",
+ "attndims" : "int4",
+ "attnotnull" : "bool",
+ "attnum" : "int2",
+ "attrelid" : "Oid",
+ "attstattarget" : "int4",
+ "attstorage" : "char",
+ "atttypid" : "Oid",
+ "atttypmod" : "int4",
+ "oid" : "Oid"
+ },
+ "cols" : [
+ {
+ "colname" : "attrelid",
+ "ctype" : "Oid",
+ "precomment" : "\n**TK_BLANK_LINE**",
+ "sqltype" : "oid"
+ },
+ {
+ "colname" : "attname",
+ "ctype" : "NameData",
+ "sqltype" : "name"
+ },
+ {
+ "colname" : "atttypid",
+ "ctype" : "Oid",
+ "sqltype" : "oid"
+ },
+ {
+ "colname" : "attstattarget",
+ "ctype" : "int4",
+ "sqltype" : "integer"
+ },
+ {
+ "colname" : "attlen",
+ "ctype" : "int2",
+ "sqltype" : "smallint"
+ },
+ {
+ "colname" : "attnum",
+ "ctype" : "int2",
+ "sqltype" : "smallint"
+ },
+ {
+ "colname" : "attndims",
+ "ctype" : "int4",
+ "sqltype" : "integer"
+ },
+ {
+ "colname" : "attcacheoff",
+ "ctype" : "int4",
+ "sqltype" : "integer"
+ },
+ {
+ "colname" : "atttypmod",
+ "ctype" : "int4",
+ "sqltype" : "integer"
+ },
+ {
+ "colname" : "attbyval",
+ "ctype" : "bool",
+ "sqltype" : "boolean"
+ },
+ {
+ "colname" : "attstorage",
+ "ctype" : "char",
+ "sqltype" : "quoted_char"
+ },
+ {
+ "colname" : "attalign",
+ "ctype" : "char",
+ "sqltype" : "quoted_char"
+ },
+ {
+ "colname" : "attnotnull",
+ "ctype" : "bool",
+ "sqltype" : "boolean"
+ },
+ {
+ "colname" : "atthasdef",
+ "ctype" : "bool",
+ "sqltype" : "boolean"
+ },
+ {
+ "colname" : "attisdropped",
+ "ctype" : "bool",
+ "sqltype" : "boolean"
+ },
+ {
+ "colname" : "attislocal",
+ "ctype" : "bool",
+ "sqltype" : "boolean"
+ },
+ {
+ "colname" : "attinhcount",
+ "ctype" : "int4",
+ "sqltype" : "integer"
+ }
+ ],
+ "filename" : "pg_attribute.h",
+ "fk_list" : [
+ {
+ "fkcols" : [
+ "attrelid"
+ ],
+ "pkcols" : [
+ "oid"
+ ],
+ "pktable" : "pg_class",
+ "type" : "scalar"
+ },
+ {
+ "fkcols" : [
+ "atttypid"
+ ],
+ "pkcols" : [
+ "oid"
+ ],
+ "pktable" : "pg_type",
+ "type" : "scalar"
+ }
+ ],
+ "foreign_keys" : [
+ [
+ [
+ "attrelid"
+ ],
+ "pg_class",
+ [
+ "oid"
+ ]
+ ],
+ [
+ [
+ "atttypid"
+ ],
+ "pg_type",
+ [
+ "oid"
+ ]
+ ]
+ ],
+ "indexes" : [
+ {
+ "CamelCaseIndexId" : "AttributeRelidNameIndexId",
+ "cols" : [
+ [
+ "attrelid",
+ "oid_ops"
+ ],
+ [
+ "attname",
+ "name_ops"
+ ]
+ ],
+ "indexid" : "2658",
+ "unique" : "1",
+ "with" : {
+ "camelcase" : "AttributeRelidName",
+ "indexid" : "2658",
+ "syscache_nbuckets" : "2048",
+ "syscacheid" : "ATTNAME"
+ }
+ },
+ {
+ "CamelCaseIndexId" : "AttributeRelidNumIndexId",
+ "cols" : [
+ [
+ "attrelid",
+ "oid_ops"
+ ],
+ [
+ "attnum",
+ "int2_ops"
+ ]
+ ],
+ "indexid" : "2659",
+ "unique" : "1",
+ "with" : {
+ "camelcase" : "AttributeRelidNum",
+ "indexid" : "2659",
+ "syscache_nbuckets" : "2048",
+ "syscacheid" : "ATTNUM"
+ }
+ }
+ ],
+ "relid_comment_tag" : "/* relation id: 1249 - pg_attribute */\n",
+ "tabdef_text" : "\n CREATE TABLE pg_attribute\n with (camelcase=Attribute, relid=1249)\n (\n attrelid oid, \n attname name, \n atttypid oid, \n attstattarget integer, \n attlen smallint, \n attnum smallint, \n attndims integer, \n attcacheoff integer, \n atttypmod integer, \n attbyval boolean, \n attstorage \"char\", \n attalign \"char\", \n attnotnull boolean, \n atthasdef boolean, \n attisdropped boolean, \n attislocal boolean, \n attinhcount integer\n )",
+ "with" : {
+ "bootstrap" : 0,
+ "camelcase" : "Attribute",
+ "oid" : 1,
+ "relid" : "1249",
+ "shared" : 0,
+ "text" : "with (camelcase=Attribute, relid=1249)"
+ }
+ },
+ "pg_attribute_encoding" : {
+ "CamelCaseRelationId" : "AttributeEncodingRelationId",
+ "CamelCaseToastInd" : "PgAttributeEncodingToastIndex",
+ "CamelCaseToastTab" : "PgAttributeEncodingToastTable",
+ "UppercaseReltypeOid" : "PG_ATTRIBUTE_ENCODING_RELTYPE_OID",
+ "UppercaseToastReltypeOid" : "PG_ATTRIBUTE_ENCODING_TOAST_RELTYPE_OID",
+ "colh" : {
+ "attnum" : "int2",
+ "attoptions" : "text[1]",
+ "attrelid" : "Oid"
+ },
+ "cols" : [
+ {
+ "colname" : "attrelid",
+ "ctype" : "Oid",
+ "precomment" : "\n**TK_BLANK_LINE**",
+ "sqltype" : "oid"
+ },
+ {
+ "colname" : "attnum",
+ "ctype" : "int2",
+ "sqltype" : "smallint"
+ },
+ {
+ "colname" : "attoptions",
+ "ctype" : "text[1]",
+ "sqltype" : "text[]"
+ }
+ ],
+ "filename" : "pg_attribute_encoding.h",
+ "fk_list" : [
+ {
+ "fkcols" : [
+ "attrelid"
+ ],
+ "pkcols" : [
+ "attrelid"
+ ],
+ "pktable" : "pg_attribute",
+ "type" : "scalar"
+ }
+ ],
+ "foreign_keys" : [
+ [
+ [
+ "attrelid"
+ ],
+ "pg_attribute",
+ [
+ "attrelid"
+ ]
+ ]
+ ],
+ "indexes" : [
+ {
+ "CamelCaseIndexId" : "AttributeEncodingAttrelidIndexId",
+ "cols" : [
+ [
+ "attrelid",
+ "oid_ops"
+ ]
+ ],
+ "indexid" : "3236",
+ "unique" : "",
+ "with" : {
+ "camelcase" : "AttributeEncodingAttrelid",
+ "indexid" : "3236"
+ }
+ },
+ {
+ "CamelCaseIndexId" : "AttributeEncodingAttrelidAttnumIndexId",
+ "cols" : [
+ [
+ "attrelid",
+ "oid_ops"
+ ],
+ [
+ "attnum",
+ "int2_ops"
+ ]
+ ],
+ "indexid" : "3237",
+ "unique" : "1",
+ "with" : {
+ "camelcase" : "AttributeEncodingAttrelidAttnum",
+ "indexid" : "3237"
+ }
+ }
+ ],
+ "relid_comment_tag" : "/* relation id: 3231 - pg_attribute_encoding */\n",
+ "tabdef_text" : "\n CREATE TABLE pg_attribute_encoding\n with (relid=3231, reltype_oid=3232, toast_oid=3233, toast_index=3234, toast_reltype=3235, CamelCase=AttributeEncoding, oid=false)\n (\n attrelid oid, \n attnum\t\tsmallint, \n attoptions text[]\n )",
+ "with" : {
+ "bootstrap" : 0,
+ "camelcase" : "AttributeEncoding",
+ "oid" : "",
+ "relid" : "3231",
+ "reltype_oid" : "3232",
+ "shared" : 0,
+ "text" : "with (relid=3231, reltype_oid=3232, toast_oid=3233, toast_index=3234, toast_reltype=3235, CamelCase=AttributeEncoding, oid=false)",
+ "toast_index" : "3234",
+ "toast_oid" : "3233",
+ "toast_reltype" : "3235"
+ }
+ },
+ "pg_auth_members" : {
+ "CamelCaseRelationId" : "AuthMemRelationId",
+ "colh" : {
+ "admin_option" : "bool",
+ "grantor" : "Oid",
+ "member" : "Oid",
+ "roleid" : "Oid"
+ },
+ "cols" : [
+ {
+ "colname" : "roleid",
+ "ctype" : "Oid",
+ "precomment" : "\n**TK_BLANK_LINE**",
+ "sqltype" : "oid"
+ },
+ {
+ "colname" : "member",
+ "ctype" : "Oid",
+ "sqltype" : "oid"
+ },
+ {
+ "colname" : "grantor",
+ "ctype" : "Oid",
+ "sqltype" : "oid"
+ },
+ {
+ "colname" : "admin_option",
+ "ctype" : "bool",
+ "sqltype" : "boolean"
+ }
+ ],
+ "filename" : "pg_auth_members.h",
+ "fk_list" : [
+ {
+ "fkcols" : [
+ "roleid"
+ ],
+ "pkcols" : [
+ "oid"
+ ],
+ "pktable" : "pg_authid",
+ "type" : "scalar"
+ },
+ {
+ "fkcols" : [
+ "member"
+ ],
+ "pkcols" : [
+ "oid"
+ ],
+ "pktable" : "pg_authid",
+ "type" : "scalar"
+ }
+ ],
+ "foreign_keys" : [
+ [
+ [
+ "roleid"
+ ],
+ "pg_authid",
+ [
+ "oid"
+ ]
+ ],
+ [
+ [
+ "member"
+ ],
+ "pg_authid",
+ [
+ "oid"
+ ]
+ ]
+ ],
+ "indexes" : [
+ {
+ "CamelCaseIndexId" : "AuthMemRoleMemIndexId",
+ "cols" : [
+ [
+ "roleid",
+ "oid_ops"
+ ],
+ [
+ "member",
+ "oid_ops"
+ ]
+ ],
+ "indexid" : "2694",
+ "unique" : "1",
+ "with" : {
+ "camelcase" : "AuthMemRoleMem",
+ "indexid" : "2694",
+ "syscache_nbuckets" : "128",
+ "syscacheid" : "AUTHMEMROLEMEM"
+ }
+ },
+ {
+ "CamelCaseIndexId" : "AuthMemMemRoleIndexId",
+ "cols" : [
+ [
+ "member",
+ "oid_ops"
+ ],
+ [
+ "roleid",
+ "oid_ops"
+ ]
+ ],
+ "indexid" : "2695",
+ "unique" : "1",
+ "with" : {
+ "camelcase" : "AuthMemMemRole",
+ "indexid" : "2695",
+ "syscache_nbuckets" : "128",
+ "syscacheid" : "AUTHMEMMEMROLE"
+ }
+ }
+ ],
+ "relid_comment_tag" : "/* relation id: 1261 - pg_auth_members */\n",
+ "tabdef_text" : "\n CREATE TABLE pg_auth_members\n with (camelcase=AuthMem, shared=true, oid=false, relid=1261)\n (\n roleid oid, \n member oid, \n grantor oid, \n admin_option boolean\n )",
+ "with" : {
+ "bootstrap" : 0,
+ "camelcase" : "AuthMem",
+ "oid" : "",
+ "relid" : "1261",
+ "shared" : "1",
+ "text" : "with (camelcase=AuthMem, shared=true,
<TRUNCATED>
[2/2] incubator-hawq git commit: HAWQ-1586. Update version from
2.2.0.0 to 2.3.0.0
Posted by yj...@apache.org.
HAWQ-1586. Update version from 2.2.0.0 to 2.3.0.0
Project: http://git-wip-us.apache.org/repos/asf/incubator-hawq/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-hawq/commit/a05faa2a
Tree: http://git-wip-us.apache.org/repos/asf/incubator-hawq/tree/a05faa2a
Diff: http://git-wip-us.apache.org/repos/asf/incubator-hawq/diff/a05faa2a
Branch: refs/heads/master
Commit: a05faa2aa11413003f2a71b63c3fbb97e82998ea
Parents: 060ca66
Author: Yi <yj...@apache.org>
Authored: Thu Feb 8 19:03:55 2018 +1100
Committer: Yi <yj...@apache.org>
Committed: Thu Feb 8 19:03:55 2018 +1100
----------------------------------------------------------------------
contrib/hawq-ambari-plugin/build.properties | 2 +-
contrib/hawq-ambari-plugin/pom.xml | 2 +-
getversion | 2 +-
ranger-plugin/admin-plugin/pom.xml | 2 +-
ranger-plugin/integration/admin/pom.xml | 2 +-
ranger-plugin/integration/pom.xml | 2 +-
ranger-plugin/integration/service/pom.xml | 2 +-
ranger-plugin/pom.xml | 2 +-
ranger-plugin/service/pom.xml | 2 +-
tools/bin/gppylib/data/2.3.json | 10458 +++++++++++++++++++++
10 files changed, 10467 insertions(+), 9 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/a05faa2a/contrib/hawq-ambari-plugin/build.properties
----------------------------------------------------------------------
diff --git a/contrib/hawq-ambari-plugin/build.properties b/contrib/hawq-ambari-plugin/build.properties
index 1cd6645..6df37f7 100644
--- a/contrib/hawq-ambari-plugin/build.properties
+++ b/contrib/hawq-ambari-plugin/build.properties
@@ -4,5 +4,5 @@ pxf.release.version=3.2.1
pxf.common.services.version=3.0.0
hawq.repo.prefix=hawq
hawq.addons.repo.prefix=hawq-add-ons
-repository.version=2.2.0.0
+repository.version=2.3.0.0
default.stack=HDP-2.5
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/a05faa2a/contrib/hawq-ambari-plugin/pom.xml
----------------------------------------------------------------------
diff --git a/contrib/hawq-ambari-plugin/pom.xml b/contrib/hawq-ambari-plugin/pom.xml
index ad55e84..94dd440 100644
--- a/contrib/hawq-ambari-plugin/pom.xml
+++ b/contrib/hawq-ambari-plugin/pom.xml
@@ -21,7 +21,7 @@
<modelVersion>4.0.0</modelVersion>
<groupId>org.apache.hawq</groupId>
<artifactId>hawq-ambari-plugin</artifactId>
- <version>2.2.0.0</version>
+ <version>2.3.0.0</version>
<name>hawq-ambari-plugin</name>
<url>http://maven.apache.org</url>
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/a05faa2a/getversion
----------------------------------------------------------------------
diff --git a/getversion b/getversion
index 8527657..081299c 100755
--- a/getversion
+++ b/getversion
@@ -18,7 +18,7 @@
# under the License.
#
-GP_VERSION="2.2.0.0-incubating"
+GP_VERSION="2.3.0.0-incubating"
GP_BUILDNUMBER=dev
if [ -f BUILD_NUMBER ] ; then
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/a05faa2a/ranger-plugin/admin-plugin/pom.xml
----------------------------------------------------------------------
diff --git a/ranger-plugin/admin-plugin/pom.xml b/ranger-plugin/admin-plugin/pom.xml
index e4460e1..19a10ec 100644
--- a/ranger-plugin/admin-plugin/pom.xml
+++ b/ranger-plugin/admin-plugin/pom.xml
@@ -27,7 +27,7 @@
<parent>
<groupId>org.apache.hawq</groupId>
<artifactId>ranger-plugin</artifactId>
- <version>2.2.0.0</version>
+ <version>2.3.0.0</version>
<relativePath>..</relativePath>
</parent>
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/a05faa2a/ranger-plugin/integration/admin/pom.xml
----------------------------------------------------------------------
diff --git a/ranger-plugin/integration/admin/pom.xml b/ranger-plugin/integration/admin/pom.xml
index 3544c6f..152e4da 100644
--- a/ranger-plugin/integration/admin/pom.xml
+++ b/ranger-plugin/integration/admin/pom.xml
@@ -29,7 +29,7 @@
<parent>
<groupId>org.apache.hawq</groupId>
<artifactId>ranger-plugin-integration</artifactId>
- <version>2.2.0.0</version>
+ <version>2.3.0.0</version>
<relativePath>..</relativePath>
</parent>
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/a05faa2a/ranger-plugin/integration/pom.xml
----------------------------------------------------------------------
diff --git a/ranger-plugin/integration/pom.xml b/ranger-plugin/integration/pom.xml
index c2f144f..fb5eff3 100644
--- a/ranger-plugin/integration/pom.xml
+++ b/ranger-plugin/integration/pom.xml
@@ -29,7 +29,7 @@
<parent>
<groupId>org.apache.hawq</groupId>
<artifactId>ranger-plugin</artifactId>
- <version>2.2.0.0</version>
+ <version>2.3.0.0</version>
<relativePath>..</relativePath>
</parent>
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/a05faa2a/ranger-plugin/integration/service/pom.xml
----------------------------------------------------------------------
diff --git a/ranger-plugin/integration/service/pom.xml b/ranger-plugin/integration/service/pom.xml
index aac8027..6616a29 100644
--- a/ranger-plugin/integration/service/pom.xml
+++ b/ranger-plugin/integration/service/pom.xml
@@ -29,7 +29,7 @@
<parent>
<groupId>org.apache.hawq</groupId>
<artifactId>ranger-plugin-integration</artifactId>
- <version>2.2.0.0</version>
+ <version>2.3.0.0</version>
<relativePath>..</relativePath>
</parent>
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/a05faa2a/ranger-plugin/pom.xml
----------------------------------------------------------------------
diff --git a/ranger-plugin/pom.xml b/ranger-plugin/pom.xml
index 80e09fe..ccc8f82 100644
--- a/ranger-plugin/pom.xml
+++ b/ranger-plugin/pom.xml
@@ -22,7 +22,7 @@
<modelVersion>4.0.0</modelVersion>
<groupId>org.apache.hawq</groupId>
<artifactId>ranger-plugin</artifactId>
- <version>2.2.0.0</version>
+ <version>2.3.0.0</version>
<packaging>pom</packaging>
<name>HAWQ Ranger Plugin</name>
<description>HAWQ Ranger Plugin</description>
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/a05faa2a/ranger-plugin/service/pom.xml
----------------------------------------------------------------------
diff --git a/ranger-plugin/service/pom.xml b/ranger-plugin/service/pom.xml
index be61934..b79aa2d 100644
--- a/ranger-plugin/service/pom.xml
+++ b/ranger-plugin/service/pom.xml
@@ -27,7 +27,7 @@
<parent>
<groupId>org.apache.hawq</groupId>
<artifactId>ranger-plugin</artifactId>
- <version>2.2.0.0</version>
+ <version>2.3.0.0</version>
<relativePath>..</relativePath>
</parent>
<build>