Skip to content

Instantly share code, notes, and snippets.

@steve-chavez

steve-chavez/schema_diff_output.json

Created March 13, 2021 01:29
Show Gist options
  • Save steve-chavez/e0f857cb223cfc8a539cd1feceb0f102 to your computer and use it in GitHub Desktop.
Save steve-chavez/e0f857cb223cfc8a539cd1feceb0f102 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
schema_diff_output.json
{
"success": 1,
"errormsg": "",
"info": "",
"result": null,
"data": [
{
"id": 326,
"type": "cast",
"label": "Casts",
"title": "money->bigint",
"oid": 1399676,
"status": "Source Only",
"source_ddl": "-- Cast: money -> bigint\n\n-- DROP CAST (money AS bigint);\n\nCREATE CAST (money AS bigint)\n\tWITHOUT FUNCTION\n\tAS IMPLICIT;\n\nCOMMENT ON CAST (money AS bigint) IS 'money -> bigint';",
"target_ddl": "",
"diff_ddl": "-- Cast: money -> bigint\n\n-- DROP CAST (money AS bigint);\n\nCREATE CAST (money AS bigint)\n\tWITHOUT FUNCTION\n\tAS IMPLICIT;\n\nCOMMENT ON CAST (money AS bigint) IS 'money -> bigint';",
"group_name": "Database Objects",
"dependencies": [],
"source_schema_name": null
},
{
"id": 327,
"type": "event_trigger",
"label": "Event Triggers",
"title": "evt_tri_src",
"oid": 1399678,
"status": "Source Only",
"source_ddl": "-- Event Trigger: evt_tri_src on database diff_source\n\n-- DROP EVENT TRIGGER IF EXISTS evt_tri_src;\n\nCREATE EVENT TRIGGER evt_tri_src ON DDL_COMMAND_START\n EXECUTE PROCEDURE public.evt_tri_fun();\n\nCOMMENT ON EVENT TRIGGER evt_tri_src\n IS 'Event Trigger Source';\n\nALTER EVENT TRIGGER evt_tri_src\n OWNER TO postgres;\n",
"target_ddl": "",
"diff_ddl": "-- Event Trigger: evt_tri_src on database diff_source\n\n-- DROP EVENT TRIGGER IF EXISTS evt_tri_src;\n\nCREATE EVENT TRIGGER evt_tri_src ON DDL_COMMAND_START\n EXECUTE PROCEDURE public.evt_tri_fun();\n\nCOMMENT ON EVENT TRIGGER evt_tri_src\n IS 'Event Trigger Source';\n\nALTER EVENT TRIGGER evt_tri_src\n OWNER TO postgres;\n",
"group_name": "Database Objects",
"dependencies": [
{
"type": "trigger_function",
"name": "public.evt_tri_fun",
"oid": 1399677
}
],
"source_schema_name": null
},
{
"id": 328,
"type": "event_trigger",
"label": "Event Triggers",
"title": "evt_tri_tar",
"oid": 1400593,
"status": "Target Only",
"source_ddl": "",
"target_ddl": "-- Event Trigger: evt_tri_tar on database diff_target\n\n-- DROP EVENT TRIGGER IF EXISTS evt_tri_tar;\n\nCREATE EVENT TRIGGER evt_tri_tar ON DDL_COMMAND_START\n EXECUTE PROCEDURE public.evt_tri_fun();\n\nCOMMENT ON EVENT TRIGGER evt_tri_tar\n IS 'Event Trigger Source';\n\nALTER EVENT TRIGGER evt_tri_tar\n OWNER TO postgres;\n",
"diff_ddl": "DROP EVENT TRIGGER IF EXISTS evt_tri_tar;\n",
"group_name": "Database Objects",
"dependencies": []
},
{
"id": 329,
"type": "event_trigger",
"label": "Event Triggers",
"title": "evt_tri_diff_event1",
"oid": 1399679,
"source_oid": 1399679,
"target_oid": 1400594,
"status": "Different",
"source_ddl": "-- Event Trigger: evt_tri_diff_event1 on database diff_source\n\n-- DROP EVENT TRIGGER IF EXISTS evt_tri_diff_event1;\n\nCREATE EVENT TRIGGER evt_tri_diff_event1 ON DDL_COMMAND_START\n EXECUTE PROCEDURE public.evt_tri_fun();\n\nALTER EVENT TRIGGER evt_tri_diff_event1\n OWNER TO postgres;\n",
"target_ddl": "-- Event Trigger: evt_tri_diff_event1 on database diff_target\n\n-- DROP EVENT TRIGGER IF EXISTS evt_tri_diff_event1;\n\nCREATE EVENT TRIGGER evt_tri_diff_event1 ON DDL_COMMAND_END\n EXECUTE PROCEDURE public.evt_tri_fun();\n\nALTER EVENT TRIGGER evt_tri_diff_event1\n OWNER TO postgres;\n",
"diff_ddl": "-- WARNING:\n-- We have found the difference in either of Trigger Function, Event or WHEN\n-- so we need to drop the existing event trigger first and re-create it.\nDROP EVENT TRIGGER IF EXISTS evt_tri_diff_event1;\n\nCREATE EVENT TRIGGER evt_tri_diff_event1 ON DDL_COMMAND_START\n EXECUTE PROCEDURE public.evt_tri_fun();",
"group_name": "Database Objects",
"dependencies": [
{
"type": "trigger_function",
"name": "public.evt_tri_fun",
"oid": 1399677
}
]
},
{
"id": 330,
"type": "event_trigger",
"label": "Event Triggers",
"title": "evt_tri_diff_event2",
"oid": 1399680,
"source_oid": 1399680,
"target_oid": 1400595,
"status": "Different",
"source_ddl": "-- Event Trigger: evt_tri_diff_event2 on database diff_source\n\n-- DROP EVENT TRIGGER IF EXISTS evt_tri_diff_event2;\n\nCREATE EVENT TRIGGER evt_tri_diff_event2 ON DDL_COMMAND_END\n EXECUTE PROCEDURE public.evt_tri_fun();\n\nALTER EVENT TRIGGER evt_tri_diff_event2\n OWNER TO postgres;\n",
"target_ddl": "-- Event Trigger: evt_tri_diff_event2 on database diff_target\n\n-- DROP EVENT TRIGGER IF EXISTS evt_tri_diff_event2;\n\nCREATE EVENT TRIGGER evt_tri_diff_event2 ON DDL_COMMAND_START\n EXECUTE PROCEDURE public.evt_tri_fun();\n\nALTER EVENT TRIGGER evt_tri_diff_event2\n OWNER TO postgres;\n",
"diff_ddl": "-- WARNING:\n-- We have found the difference in either of Trigger Function, Event or WHEN\n-- so we need to drop the existing event trigger first and re-create it.\nDROP EVENT TRIGGER IF EXISTS evt_tri_diff_event2;\n\nCREATE EVENT TRIGGER evt_tri_diff_event2 ON DDL_COMMAND_END\n EXECUTE PROCEDURE public.evt_tri_fun();",
"group_name": "Database Objects",
"dependencies": [
{
"type": "trigger_function",
"name": "public.evt_tri_fun",
"oid": 1399677
}
]
},
{
"id": 331,
"type": "event_trigger",
"label": "Event Triggers",
"title": "evt_tri_diff_event3",
"oid": 1399681,
"source_oid": 1399681,
"target_oid": 1400596,
"status": "Different",
"source_ddl": "-- Event Trigger: evt_tri_diff_event3 on database diff_source\n\n-- DROP EVENT TRIGGER IF EXISTS evt_tri_diff_event3;\n\nCREATE EVENT TRIGGER evt_tri_diff_event3 ON SQL_DROP\n EXECUTE PROCEDURE public.evt_tri_fun();\n\nALTER EVENT TRIGGER evt_tri_diff_event3\n OWNER TO postgres;\n",
"target_ddl": "-- Event Trigger: evt_tri_diff_event3 on database diff_target\n\n-- DROP EVENT TRIGGER IF EXISTS evt_tri_diff_event3;\n\nCREATE EVENT TRIGGER evt_tri_diff_event3 ON DDL_COMMAND_START\n EXECUTE PROCEDURE public.evt_tri_fun();\n\nALTER EVENT TRIGGER evt_tri_diff_event3\n OWNER TO postgres;\n",
"diff_ddl": "-- WARNING:\n-- We have found the difference in either of Trigger Function, Event or WHEN\n-- so we need to drop the existing event trigger first and re-create it.\nDROP EVENT TRIGGER IF EXISTS evt_tri_diff_event3;\n\nCREATE EVENT TRIGGER evt_tri_diff_event3 ON SQL_DROP\n EXECUTE PROCEDURE public.evt_tri_fun();",
"group_name": "Database Objects",
"dependencies": [
{
"type": "trigger_function",
"name": "public.evt_tri_fun",
"oid": 1399677
}
]
},
{
"id": 332,
"type": "event_trigger",
"label": "Event Triggers",
"title": "evt_tri_diff_enable_status3",
"oid": 1399684,
"source_oid": 1399684,
"target_oid": 1400599,
"status": "Different",
"source_ddl": "-- Event Trigger: evt_tri_diff_enable_status3 on database diff_source\n\n-- DROP EVENT TRIGGER IF EXISTS evt_tri_diff_enable_status3;\n\nCREATE EVENT TRIGGER evt_tri_diff_enable_status3 ON DDL_COMMAND_START\n EXECUTE PROCEDURE public.evt_tri_fun();\n\nALTER EVENT TRIGGER evt_tri_diff_enable_status3\n ENABLE ALWAYS;\n\nALTER EVENT TRIGGER evt_tri_diff_enable_status3\n OWNER TO postgres;\n",
"target_ddl": "-- Event Trigger: evt_tri_diff_enable_status3 on database diff_target\n\n-- DROP EVENT TRIGGER IF EXISTS evt_tri_diff_enable_status3;\n\nCREATE EVENT TRIGGER evt_tri_diff_enable_status3 ON DDL_COMMAND_START\n EXECUTE PROCEDURE public.evt_tri_fun();\n\nALTER EVENT TRIGGER evt_tri_diff_enable_status3\n OWNER TO postgres;\n",
"diff_ddl": "ALTER EVENT TRIGGER evt_tri_diff_enable_status3\n ENABLE ALWAYS;",
"group_name": "Database Objects",
"dependencies": [
{
"type": "trigger_function",
"name": "public.evt_tri_fun",
"oid": 1399677
}
]
},
{
"id": 333,
"type": "event_trigger",
"label": "Event Triggers",
"title": "evt_tri_diff_func",
"oid": 1399685,
"source_oid": 1399685,
"target_oid": 1400600,
"status": "Different",
"source_ddl": "-- Event Trigger: evt_tri_diff_func on database diff_source\n\n-- DROP EVENT TRIGGER IF EXISTS evt_tri_diff_func;\n\nCREATE EVENT TRIGGER evt_tri_diff_func ON DDL_COMMAND_START\n EXECUTE PROCEDURE public.evt_tri_fun();\n\nALTER EVENT TRIGGER evt_tri_diff_func\n OWNER TO postgres;\n",
"target_ddl": "-- Event Trigger: evt_tri_diff_func on database diff_target\n\n-- DROP EVENT TRIGGER IF EXISTS evt_tri_diff_func;\n\nCREATE EVENT TRIGGER evt_tri_diff_func ON DDL_COMMAND_START\n EXECUTE PROCEDURE public.evt_tri_fun2();\n\nALTER EVENT TRIGGER evt_tri_diff_func\n OWNER TO postgres;\n",
"diff_ddl": "-- WARNING:\n-- We have found the difference in either of Trigger Function, Event or WHEN\n-- so we need to drop the existing event trigger first and re-create it.\nDROP EVENT TRIGGER IF EXISTS evt_tri_diff_func;\n\nCREATE EVENT TRIGGER evt_tri_diff_func ON DDL_COMMAND_START\n EXECUTE PROCEDURE public.evt_tri_fun();",
"group_name": "Database Objects",
"dependencies": [
{
"type": "trigger_function",
"name": "public.evt_tri_fun",
"oid": 1399677
}
]
},
{
"id": 334,
"type": "event_trigger",
"label": "Event Triggers",
"title": "evt_tri_diff_enable_status2",
"oid": 1399683,
"source_oid": 1399683,
"target_oid": 1400598,
"status": "Different",
"source_ddl": "-- Event Trigger: evt_tri_diff_enable_status2 on database diff_source\n\n-- DROP EVENT TRIGGER IF EXISTS evt_tri_diff_enable_status2;\n\nCREATE EVENT TRIGGER evt_tri_diff_enable_status2 ON DDL_COMMAND_START\n EXECUTE PROCEDURE public.evt_tri_fun();\n\nALTER EVENT TRIGGER evt_tri_diff_enable_status2\n ENABLE REPLICA;\n\nALTER EVENT TRIGGER evt_tri_diff_enable_status2\n OWNER TO postgres;\n",
"target_ddl": "-- Event Trigger: evt_tri_diff_enable_status2 on database diff_target\n\n-- DROP EVENT TRIGGER IF EXISTS evt_tri_diff_enable_status2;\n\nCREATE EVENT TRIGGER evt_tri_diff_enable_status2 ON DDL_COMMAND_START\n EXECUTE PROCEDURE public.evt_tri_fun();\n\nALTER EVENT TRIGGER evt_tri_diff_enable_status2\n DISABLE;\n\nALTER EVENT TRIGGER evt_tri_diff_enable_status2\n OWNER TO postgres;\n",
"diff_ddl": "ALTER EVENT TRIGGER evt_tri_diff_enable_status2\n ENABLE REPLICA;",
"group_name": "Database Objects",
"dependencies": [
{
"type": "trigger_function",
"name": "public.evt_tri_fun",
"oid": 1399677
}
]
},
{
"id": 335,
"type": "event_trigger",
"label": "Event Triggers",
"title": "evt_tri_diff_enable_status1",
"oid": 1399682,
"source_oid": 1399682,
"target_oid": 1400597,
"status": "Different",
"source_ddl": "-- Event Trigger: evt_tri_diff_enable_status1 on database diff_source\n\n-- DROP EVENT TRIGGER IF EXISTS evt_tri_diff_enable_status1;\n\nCREATE EVENT TRIGGER evt_tri_diff_enable_status1 ON DDL_COMMAND_START\n EXECUTE PROCEDURE public.evt_tri_fun();\n\nALTER EVENT TRIGGER evt_tri_diff_enable_status1\n DISABLE;\n\nALTER EVENT TRIGGER evt_tri_diff_enable_status1\n OWNER TO postgres;\n",
"target_ddl": "-- Event Trigger: evt_tri_diff_enable_status1 on database diff_target\n\n-- DROP EVENT TRIGGER IF EXISTS evt_tri_diff_enable_status1;\n\nCREATE EVENT TRIGGER evt_tri_diff_enable_status1 ON DDL_COMMAND_START\n EXECUTE PROCEDURE public.evt_tri_fun();\n\nALTER EVENT TRIGGER evt_tri_diff_enable_status1\n OWNER TO postgres;\n",
"diff_ddl": "ALTER EVENT TRIGGER evt_tri_diff_enable_status1\n DISABLE;",
"group_name": "Database Objects",
"dependencies": [
{
"type": "trigger_function",
"name": "public.evt_tri_fun",
"oid": 1399677
}
]
},
{
"id": 336,
"type": "extension",
"label": "Extensions",
"title": "adminpack",
"oid": 1399686,
"source_oid": 1399686,
"target_oid": 1400601,
"status": "Different",
"source_ddl": "-- Extension: adminpack\n\n-- DROP EXTENSION adminpack;\n\nCREATE EXTENSION adminpack\n SCHEMA pg_catalog\n VERSION \"1.1\";\n",
"target_ddl": "-- Extension: adminpack\n\n-- DROP EXTENSION adminpack;\n\nCREATE EXTENSION adminpack\n SCHEMA pg_catalog\n VERSION \"1.0\";\n",
"diff_ddl": "ALTER EXTENSION adminpack\n UPDATE TO \"1.1\";\n",
"group_name": "Database Objects",
"dependencies": [
{
"type": "role",
"name": "steve-chavez",
"field": "Owner"
}
]
},
{
"id": 337,
"type": "extension",
"label": "Extensions",
"title": "btree_gist",
"oid": 1398829,
"source_oid": 1398829,
"target_oid": 1399735,
"status": "Identical",
"group_name": "Database Objects",
"dependencies": [],
"source_scid": 0,
"target_scid": 0
},
{
"id": 338,
"type": "extension",
"label": "Extensions",
"title": "plpgsql",
"oid": 14053,
"source_oid": 14053,
"target_oid": 14053,
"status": "Identical",
"group_name": "Database Objects",
"dependencies": [],
"source_scid": 0,
"target_scid": 0
},
{
"id": 339,
"type": "foreign_data_wrapper",
"label": "Foreign Data Wrappers",
"title": "fdw_src",
"oid": 1399701,
"status": "Source Only",
"source_ddl": "-- Foreign Data Wrapper: fdw_src\n\n-- DROP FOREIGN DATA WRAPPER fdw_src\n\nCREATE FOREIGN DATA WRAPPER fdw_src\n VALIDATOR pg_catalog.postgresql_fdw_validator;\n\nALTER FOREIGN DATA WRAPPER fdw_src\n OWNER TO postgres;\n\nCOMMENT ON FOREIGN DATA WRAPPER fdw_src\n IS 'Foreign Data Wrapper';",
"target_ddl": "",
"diff_ddl": "-- Foreign Data Wrapper: fdw_src\n\n-- DROP FOREIGN DATA WRAPPER fdw_src\n\nCREATE FOREIGN DATA WRAPPER fdw_src\n VALIDATOR pg_catalog.postgresql_fdw_validator;\n\nALTER FOREIGN DATA WRAPPER fdw_src\n OWNER TO postgres;\n\nCOMMENT ON FOREIGN DATA WRAPPER fdw_src\n IS 'Foreign Data Wrapper';",
"group_name": "Database Objects",
"dependencies": [],
"source_schema_name": null
},
{
"id": 340,
"type": "foreign_data_wrapper",
"label": "Foreign Data Wrappers",
"title": "fdw_tar",
"oid": 1400615,
"status": "Target Only",
"source_ddl": "",
"target_ddl": "-- Foreign Data Wrapper: fdw_tar\n\n-- DROP FOREIGN DATA WRAPPER fdw_tar\n\nCREATE FOREIGN DATA WRAPPER fdw_tar\n VALIDATOR pg_catalog.postgresql_fdw_validator;\n\nALTER FOREIGN DATA WRAPPER fdw_tar\n OWNER TO postgres;\n\nCOMMENT ON FOREIGN DATA WRAPPER fdw_tar\n IS 'Foreign Data Wrapper';",
"diff_ddl": "DROP FOREIGN DATA WRAPPER fdw_tar ;\n",
"group_name": "Database Objects",
"dependencies": []
},
{
"id": 341,
"type": "foreign_data_wrapper",
"label": "Foreign Data Wrappers",
"title": "fdw_diff_add_validator",
"oid": 1399704,
"source_oid": 1399704,
"target_oid": 1400618,
"status": "Different",
"source_ddl": "-- Foreign Data Wrapper: fdw_diff_add_validator\n\n-- DROP FOREIGN DATA WRAPPER fdw_diff_add_validator\n\nCREATE FOREIGN DATA WRAPPER fdw_diff_add_validator\n VALIDATOR pg_catalog.postgresql_fdw_validator;\n\nALTER FOREIGN DATA WRAPPER fdw_diff_add_validator\n OWNER TO postgres;",
"target_ddl": "-- Foreign Data Wrapper: fdw_diff_add_validator\n\n-- DROP FOREIGN DATA WRAPPER fdw_diff_add_validator\n\nCREATE FOREIGN DATA WRAPPER fdw_diff_add_validator;\n\nALTER FOREIGN DATA WRAPPER fdw_diff_add_validator\n OWNER TO postgres;",
"diff_ddl": "ALTER FOREIGN DATA WRAPPER fdw_diff_add_validator\n VALIDATOR pg_catalog.postgresql_fdw_validator;",
"group_name": "Database Objects",
"dependencies": []
},
{
"id": 342,
"type": "foreign_data_wrapper",
"label": "Foreign Data Wrappers",
"title": "fdw_diff_remove_options",
"oid": 1399707,
"source_oid": 1399707,
"target_oid": 1400621,
"status": "Different",
"source_ddl": "-- Foreign Data Wrapper: fdw_diff_remove_options\n\n-- DROP FOREIGN DATA WRAPPER fdw_diff_remove_options\n\nCREATE FOREIGN DATA WRAPPER fdw_diff_remove_options;\n\nALTER FOREIGN DATA WRAPPER fdw_diff_remove_options\n OWNER TO postgres;",
"target_ddl": "-- Foreign Data Wrapper: fdw_diff_remove_options\n\n-- DROP FOREIGN DATA WRAPPER fdw_diff_remove_options\n\nCREATE FOREIGN DATA WRAPPER fdw_diff_remove_options\n OPTIONS (debug 'true');\n\nALTER FOREIGN DATA WRAPPER fdw_diff_remove_options\n OWNER TO postgres;",
"diff_ddl": "ALTER FOREIGN DATA WRAPPER fdw_diff_remove_options\n OPTIONS (DROP debug);",
"group_name": "Database Objects",
"dependencies": []
},
{
"id": 343,
"type": "foreign_data_wrapper",
"label": "Foreign Data Wrappers",
"title": "fdw_diff_remove_validator",
"oid": 1399705,
"source_oid": 1399705,
"target_oid": 1400619,
"status": "Different",
"source_ddl": "-- Foreign Data Wrapper: fdw_diff_remove_validator\n\n-- DROP FOREIGN DATA WRAPPER fdw_diff_remove_validator\n\nCREATE FOREIGN DATA WRAPPER fdw_diff_remove_validator;\n\nALTER FOREIGN DATA WRAPPER fdw_diff_remove_validator\n OWNER TO postgres;",
"target_ddl": "-- Foreign Data Wrapper: fdw_diff_remove_validator\n\n-- DROP FOREIGN DATA WRAPPER fdw_diff_remove_validator\n\nCREATE FOREIGN DATA WRAPPER fdw_diff_remove_validator\n VALIDATOR pg_catalog.postgresql_fdw_validator;\n\nALTER FOREIGN DATA WRAPPER fdw_diff_remove_validator\n OWNER TO postgres;",
"diff_ddl": "ALTER FOREIGN DATA WRAPPER fdw_diff_remove_validator\n NO VALIDATOR;",
"group_name": "Database Objects",
"dependencies": []
},
{
"id": 344,
"type": "foreign_data_wrapper",
"label": "Foreign Data Wrappers",
"title": "fdw_diff_acl_add",
"oid": 1399702,
"source_oid": 1399702,
"target_oid": 1400616,
"status": "Different",
"source_ddl": "-- Foreign Data Wrapper: fdw_diff_acl_add\n\n-- DROP FOREIGN DATA WRAPPER fdw_diff_acl_add\n\nCREATE FOREIGN DATA WRAPPER fdw_diff_acl_add\n VALIDATOR pg_catalog.postgresql_fdw_validator;\n\nALTER FOREIGN DATA WRAPPER fdw_diff_acl_add\n OWNER TO postgres;\n\nGRANT USAGE ON FOREIGN DATA WRAPPER fdw_diff_acl_add TO PUBLIC;\nGRANT USAGE ON FOREIGN DATA WRAPPER fdw_diff_acl_add TO postgres WITH GRANT OPTION;",
"target_ddl": "-- Foreign Data Wrapper: fdw_diff_acl_add\n\n-- DROP FOREIGN DATA WRAPPER fdw_diff_acl_add\n\nCREATE FOREIGN DATA WRAPPER fdw_diff_acl_add\n VALIDATOR pg_catalog.postgresql_fdw_validator;\n\nALTER FOREIGN DATA WRAPPER fdw_diff_acl_add\n OWNER TO postgres;",
"diff_ddl": "GRANT USAGE ON FOREIGN DATA WRAPPER fdw_diff_acl_add TO PUBLIC;\nGRANT USAGE ON FOREIGN DATA WRAPPER fdw_diff_acl_add TO postgres WITH GRANT OPTION;",
"group_name": "Database Objects",
"dependencies": []
},
{
"id": 345,
"type": "foreign_data_wrapper",
"label": "Foreign Data Wrappers",
"title": "fdw_diff_acl_revoke",
"oid": 1399703,
"source_oid": 1399703,
"target_oid": 1400617,
"status": "Different",
"source_ddl": "-- Foreign Data Wrapper: fdw_diff_acl_revoke\n\n-- DROP FOREIGN DATA WRAPPER fdw_diff_acl_revoke\n\nCREATE FOREIGN DATA WRAPPER fdw_diff_acl_revoke\n VALIDATOR pg_catalog.postgresql_fdw_validator;\n\nALTER FOREIGN DATA WRAPPER fdw_diff_acl_revoke\n OWNER TO postgres;",
"target_ddl": "-- Foreign Data Wrapper: fdw_diff_acl_revoke\n\n-- DROP FOREIGN DATA WRAPPER fdw_diff_acl_revoke\n\nCREATE FOREIGN DATA WRAPPER fdw_diff_acl_revoke\n VALIDATOR pg_catalog.postgresql_fdw_validator;\n\nALTER FOREIGN DATA WRAPPER fdw_diff_acl_revoke\n OWNER TO postgres;\n\nGRANT USAGE ON FOREIGN DATA WRAPPER fdw_diff_acl_revoke TO PUBLIC;\nGRANT USAGE ON FOREIGN DATA WRAPPER fdw_diff_acl_revoke TO postgres WITH GRANT OPTION;",
"diff_ddl": "REVOKE ALL ON FOREIGN DATA WRAPPER fdw_diff_acl_revoke FROM PUBLIC;\nREVOKE ALL ON FOREIGN DATA WRAPPER fdw_diff_acl_revoke FROM postgres;",
"group_name": "Database Objects",
"dependencies": []
},
{
"id": 348,
"type": "foreign_data_wrapper",
"label": "Foreign Data Wrappers",
"title": "fdw_diff_options",
"oid": 1399708,
"source_oid": 1399708,
"target_oid": 1400622,
"status": "Different",
"source_ddl": "-- Foreign Data Wrapper: fdw_diff_options\n\n-- DROP FOREIGN DATA WRAPPER fdw_diff_options\n\nCREATE FOREIGN DATA WRAPPER fdw_diff_options\n OPTIONS (debug 'false');\n\nALTER FOREIGN DATA WRAPPER fdw_diff_options\n OWNER TO postgres;",
"target_ddl": "-- Foreign Data Wrapper: fdw_diff_options\n\n-- DROP FOREIGN DATA WRAPPER fdw_diff_options\n\nCREATE FOREIGN DATA WRAPPER fdw_diff_options\n OPTIONS (debug 'true');\n\nALTER FOREIGN DATA WRAPPER fdw_diff_options\n OWNER TO postgres;",
"diff_ddl": "ALTER FOREIGN DATA WRAPPER fdw_diff_options\n OPTIONS (SET debug 'false');",
"group_name": "Database Objects",
"dependencies": []
},
{
"id": 349,
"type": "foreign_data_wrapper",
"label": "Foreign Data Wrappers",
"title": "fdw_diff_add_options",
"oid": 1399706,
"source_oid": 1399706,
"target_oid": 1400620,
"status": "Different",
"source_ddl": "-- Foreign Data Wrapper: fdw_diff_add_options\n\n-- DROP FOREIGN DATA WRAPPER fdw_diff_add_options\n\nCREATE FOREIGN DATA WRAPPER fdw_diff_add_options\n OPTIONS (debug 'true');\n\nALTER FOREIGN DATA WRAPPER fdw_diff_add_options\n OWNER TO postgres;",
"target_ddl": "-- Foreign Data Wrapper: fdw_diff_add_options\n\n-- DROP FOREIGN DATA WRAPPER fdw_diff_add_options\n\nCREATE FOREIGN DATA WRAPPER fdw_diff_add_options;\n\nALTER FOREIGN DATA WRAPPER fdw_diff_add_options\n OWNER TO postgres;",
"diff_ddl": "ALTER FOREIGN DATA WRAPPER fdw_diff_add_options\n OPTIONS (ADD debug 'true');",
"group_name": "Database Objects",
"dependencies": []
},
{
"id": 346,
"type": "foreign_data_wrapper",
"label": "Foreign Data Wrappers",
"title": "test_fdw_for_foreign_server",
"oid": 1399709,
"source_oid": 1399709,
"target_oid": 1400623,
"status": "Identical",
"group_name": "Database Objects",
"dependencies": [],
"source_scid": 0,
"target_scid": 0
},
{
"id": 347,
"type": "foreign_data_wrapper",
"label": "Foreign Data Wrappers",
"title": "test_fdw_for_user_mapping",
"oid": 1399719,
"source_oid": 1399719,
"target_oid": 1400633,
"status": "Identical",
"group_name": "Database Objects",
"dependencies": [],
"source_scid": 0,
"target_scid": 0
},
{
"id": 350,
"type": "foreign_data_wrapper",
"label": "Foreign Data Wrappers",
"title": "test_fdw_for_foreign_table",
"oid": 1399633,
"source_oid": 1399633,
"target_oid": 1400548,
"status": "Identical",
"group_name": "Database Objects",
"dependencies": [],
"source_scid": 0,
"target_scid": 0
},
{
"id": 351,
"type": "language",
"label": "Languages",
"title": "src_trusted_language",
"oid": 1399695,
"status": "Source Only",
"source_ddl": "-- Language: src_trusted_language\n\n-- DROP LANGUAGE src_trusted_language\n\nCREATE TRUSTED PROCEDURAL LANGUAGE src_trusted_language\n HANDLER plpgsql_call_handler\n INLINE plpgsql_inline_handler\n VALIDATOR plpgsql_validator;\n\nALTER LANGUAGE src_trusted_language\n OWNER TO postgres;\n\nCOMMENT ON LANGUAGE src_trusted_language\n IS 'Custom Trusted Language';\n\nGRANT USAGE ON LANGUAGE src_trusted_language TO PUBLIC;\n\nGRANT USAGE ON LANGUAGE src_trusted_language TO postgres WITH GRANT OPTION;",
"target_ddl": "",
"diff_ddl": "-- Language: src_trusted_language\n\n-- DROP LANGUAGE src_trusted_language\n\nCREATE TRUSTED PROCEDURAL LANGUAGE src_trusted_language\n HANDLER plpgsql_call_handler\n INLINE plpgsql_inline_handler\n VALIDATOR plpgsql_validator;\n\nALTER LANGUAGE src_trusted_language\n OWNER TO postgres;\n\nCOMMENT ON LANGUAGE src_trusted_language\n IS 'Custom Trusted Language';\n\nGRANT USAGE ON LANGUAGE src_trusted_language TO PUBLIC;\n\nGRANT USAGE ON LANGUAGE src_trusted_language TO postgres WITH GRANT OPTION;",
"group_name": "Database Objects",
"dependencies": [
{
"type": "function",
"name": "pg_catalog.plpgsql_call_handler",
"oid": 14054
},
{
"type": "function",
"name": "pg_catalog.plpgsql_inline_handler",
"oid": 14055
},
{
"type": "function",
"name": "pg_catalog.plpgsql_validator",
"oid": 14056
}
],
"source_schema_name": null
},
{
"id": 352,
"type": "language",
"label": "Languages",
"title": "src_proc_language",
"oid": 1399696,
"status": "Source Only",
"source_ddl": "-- Language: src_proc_language\n\n-- DROP LANGUAGE src_proc_language\n\nCREATE PROCEDURAL LANGUAGE src_proc_language\n HANDLER plpgsql_call_handler\n INLINE plpgsql_inline_handler\n VALIDATOR plpgsql_validator;\n\nALTER LANGUAGE src_proc_language\n OWNER TO postgres;\n\nCOMMENT ON LANGUAGE src_proc_language\n IS 'Custom Procedural Language';",
"target_ddl": "",
"diff_ddl": "-- Language: src_proc_language\n\n-- DROP LANGUAGE src_proc_language\n\nCREATE PROCEDURAL LANGUAGE src_proc_language\n HANDLER plpgsql_call_handler\n INLINE plpgsql_inline_handler\n VALIDATOR plpgsql_validator;\n\nALTER LANGUAGE src_proc_language\n OWNER TO postgres;\n\nCOMMENT ON LANGUAGE src_proc_language\n IS 'Custom Procedural Language';",
"group_name": "Database Objects",
"dependencies": [
{
"type": "function",
"name": "pg_catalog.plpgsql_call_handler",
"oid": 14054
},
{
"type": "function",
"name": "pg_catalog.plpgsql_inline_handler",
"oid": 14055
},
{
"type": "function",
"name": "pg_catalog.plpgsql_validator",
"oid": 14056
}
],
"source_schema_name": null
},
{
"id": 353,
"type": "language",
"label": "Languages",
"title": "tar_language",
"oid": 1400610,
"status": "Target Only",
"source_ddl": "",
"target_ddl": "-- Language: tar_language\n\n-- DROP LANGUAGE tar_language\n\nCREATE TRUSTED PROCEDURAL LANGUAGE tar_language\n HANDLER plpgsql_call_handler\n INLINE plpgsql_inline_handler\n VALIDATOR plpgsql_validator;\n\nALTER LANGUAGE tar_language\n OWNER TO postgres;\n\nGRANT USAGE ON LANGUAGE tar_language TO PUBLIC;\n\nGRANT USAGE ON LANGUAGE tar_language TO postgres WITH GRANT OPTION;",
"diff_ddl": "DROP LANGUAGE tar_language;\n",
"group_name": "Database Objects",
"dependencies": []
},
{
"id": 354,
"type": "language",
"label": "Languages",
"title": "lan_diff_acl_revoke",
"oid": 1399698,
"source_oid": 1399698,
"target_oid": 1400612,
"status": "Different",
"source_ddl": "-- Language: lan_diff_acl_revoke\n\n-- DROP LANGUAGE lan_diff_acl_revoke\n\nCREATE TRUSTED PROCEDURAL LANGUAGE lan_diff_acl_revoke\n HANDLER plpgsql_call_handler\n INLINE plpgsql_inline_handler\n VALIDATOR plpgsql_validator;\n\nALTER LANGUAGE lan_diff_acl_revoke\n OWNER TO postgres;",
"target_ddl": "-- Language: lan_diff_acl_revoke\n\n-- DROP LANGUAGE lan_diff_acl_revoke\n\nCREATE TRUSTED PROCEDURAL LANGUAGE lan_diff_acl_revoke\n HANDLER plpgsql_call_handler\n INLINE plpgsql_inline_handler\n VALIDATOR plpgsql_validator;\n\nALTER LANGUAGE lan_diff_acl_revoke\n OWNER TO postgres;\n\nGRANT USAGE ON LANGUAGE lan_diff_acl_revoke TO PUBLIC;\n\nGRANT USAGE ON LANGUAGE lan_diff_acl_revoke TO postgres WITH GRANT OPTION;",
"diff_ddl": "REVOKE ALL ON LANGUAGE lan_diff_acl_revoke FROM PUBLIC;\nREVOKE ALL ON LANGUAGE lan_diff_acl_revoke FROM postgres;",
"group_name": "Database Objects",
"dependencies": [
{
"type": "function",
"name": "pg_catalog.plpgsql_call_handler",
"oid": 14054
},
{
"type": "function",
"name": "pg_catalog.plpgsql_inline_handler",
"oid": 14055
},
{
"type": "function",
"name": "pg_catalog.plpgsql_validator",
"oid": 14056
}
]
},
{
"id": 355,
"type": "language",
"label": "Languages",
"title": "lan_diff_acl_add",
"oid": 1399697,
"source_oid": 1399697,
"target_oid": 1400611,
"status": "Different",
"source_ddl": "-- Language: lan_diff_acl_add\n\n-- DROP LANGUAGE lan_diff_acl_add\n\nCREATE TRUSTED PROCEDURAL LANGUAGE lan_diff_acl_add\n HANDLER plpgsql_call_handler\n INLINE plpgsql_inline_handler\n VALIDATOR plpgsql_validator;\n\nALTER LANGUAGE lan_diff_acl_add\n OWNER TO postgres;\n\nGRANT USAGE ON LANGUAGE lan_diff_acl_add TO PUBLIC;\n\nGRANT USAGE ON LANGUAGE lan_diff_acl_add TO postgres WITH GRANT OPTION;",
"target_ddl": "-- Language: lan_diff_acl_add\n\n-- DROP LANGUAGE lan_diff_acl_add\n\nCREATE TRUSTED PROCEDURAL LANGUAGE lan_diff_acl_add\n HANDLER plpgsql_call_handler\n INLINE plpgsql_inline_handler\n VALIDATOR plpgsql_validator;\n\nALTER LANGUAGE lan_diff_acl_add\n OWNER TO postgres;",
"diff_ddl": "GRANT USAGE ON LANGUAGE lan_diff_acl_add TO PUBLIC;\n\nGRANT USAGE ON LANGUAGE lan_diff_acl_add TO postgres WITH GRANT OPTION;",
"group_name": "Database Objects",
"dependencies": [
{
"type": "function",
"name": "pg_catalog.plpgsql_call_handler",
"oid": 14054
},
{
"type": "function",
"name": "pg_catalog.plpgsql_inline_handler",
"oid": 14055
},
{
"type": "function",
"name": "pg_catalog.plpgsql_validator",
"oid": 14056
}
]
},
{
"id": 356,
"type": "language",
"label": "Languages",
"title": "lan_diff_type",
"oid": 1399699,
"source_oid": 1399699,
"target_oid": 1400613,
"status": "Different",
"source_ddl": "-- Language: lan_diff_type\n\n-- DROP LANGUAGE lan_diff_type\n\nCREATE TRUSTED PROCEDURAL LANGUAGE lan_diff_type\n HANDLER plpgsql_call_handler\n INLINE plpgsql_inline_handler\n VALIDATOR plpgsql_validator;\n\nALTER LANGUAGE lan_diff_type\n OWNER TO postgres;",
"target_ddl": "-- Language: lan_diff_type\n\n-- DROP LANGUAGE lan_diff_type\n\nCREATE PROCEDURAL LANGUAGE lan_diff_type\n HANDLER plpgsql_call_handler\n INLINE plpgsql_inline_handler\n VALIDATOR plpgsql_validator;\n\nALTER LANGUAGE lan_diff_type\n OWNER TO postgres;",
"diff_ddl": "-- WARNING:\n-- We have found the difference in either of TRUSTED, HANDLER, INLINE or VALIDATOR,\n-- so we need to drop the existing language first and re-create it.\nDROP LANGUAGE lan_diff_type CASCADE;\n\nCREATE TRUSTED PROCEDURAL LANGUAGE lan_diff_type\n HANDLER plpgsql_call_handler\n INLINE plpgsql_inline_handler\n VALIDATOR plpgsql_validator\n;",
"group_name": "Database Objects",
"dependencies": [
{
"type": "function",
"name": "pg_catalog.plpgsql_call_handler",
"oid": 14054
},
{
"type": "function",
"name": "pg_catalog.plpgsql_inline_handler",
"oid": 14055
},
{
"type": "function",
"name": "pg_catalog.plpgsql_validator",
"oid": 14056
}
]
},
{
"id": 357,
"type": "language",
"label": "Languages",
"title": "lan_diff_inline_validator",
"oid": 1399700,
"source_oid": 1399700,
"target_oid": 1400614,
"status": "Different",
"source_ddl": "-- Language: lan_diff_inline_validator\n\n-- DROP LANGUAGE lan_diff_inline_validator\n\nCREATE TRUSTED PROCEDURAL LANGUAGE lan_diff_inline_validator\n HANDLER plpgsql_call_handler\n INLINE prsd_end\n VALIDATOR pg_stat_reset_single_table_counters;\n\nALTER LANGUAGE lan_diff_inline_validator\n OWNER TO \"steve-chavez\";",
"target_ddl": "-- Language: lan_diff_inline_validator\n\n-- DROP LANGUAGE lan_diff_inline_validator\n\nCREATE TRUSTED PROCEDURAL LANGUAGE lan_diff_inline_validator\n HANDLER plpgsql_call_handler\n INLINE plpgsql_inline_handler\n VALIDATOR plpgsql_validator;\n\nALTER LANGUAGE lan_diff_inline_validator\n OWNER TO \"steve-chavez\";",
"diff_ddl": "-- WARNING:\n-- We have found the difference in either of TRUSTED, HANDLER, INLINE or VALIDATOR,\n-- so we need to drop the existing language first and re-create it.\nDROP LANGUAGE lan_diff_inline_validator CASCADE;\n\nCREATE TRUSTED PROCEDURAL LANGUAGE lan_diff_inline_validator\n HANDLER plpgsql_call_handler\n INLINE prsd_end\n VALIDATOR pg_stat_reset_single_table_counters\n;",
"group_name": "Database Objects",
"dependencies": [
{
"type": "function",
"name": "pg_catalog.plpgsql_call_handler",
"oid": 14054
},
{
"type": "role",
"name": "steve-chavez",
"field": "Owner"
}
]
},
{
"id": 358,
"type": "language",
"label": "Languages",
"title": "plpgsql",
"oid": 14057,
"source_oid": 14057,
"target_oid": 14057,
"status": "Identical",
"group_name": "Database Objects",
"dependencies": [],
"source_scid": 0,
"target_scid": 0
},
{
"id": 359,
"type": "publication",
"label": "Publications",
"title": "with_one_table_alter",
"oid": 1399730,
"status": "Source Only",
"source_ddl": "-- Publication: with_one_table_alter\n\n-- DROP PUBLICATION with_one_table_alter;\n\nCREATE PUBLICATION with_one_table_alter\n FOR TABLE test_schema_diff.table_for_publication\n WITH (publish = 'insert, update, truncate');\n",
"target_ddl": "",
"diff_ddl": "-- Publication: with_one_table_alter\n\n-- DROP PUBLICATION with_one_table_alter;\n\nCREATE PUBLICATION with_one_table_alter\n FOR TABLE test_schema_diff.table_for_publication\n WITH (publish = 'insert, update, truncate');\n",
"group_name": "Database Objects",
"dependencies": [
{
"type": "table",
"name": "test_schema_diff.table_for_publication",
"field": "normal",
"oid": 1399723
}
],
"source_schema_name": null
},
{
"id": 360,
"type": "publication",
"label": "Publications",
"title": "with_one_table_in_target_alter",
"oid": 1400650,
"status": "Target Only",
"source_ddl": "",
"target_ddl": "-- Publication: with_one_table_in_target_alter\n\n-- DROP PUBLICATION with_one_table_in_target_alter;\n\nCREATE PUBLICATION with_one_table_in_target_alter\n FOR TABLE test_schema_diff.table_for_publication_in_target\n WITH (publish = 'insert, update, truncate');\n",
"diff_ddl": "DROP PUBLICATION with_one_table_in_target_alter;\n",
"group_name": "Database Objects",
"dependencies": []
},
{
"id": 361,
"type": "publication",
"label": "Publications",
"title": "for_all_table",
"oid": 1399729,
"source_oid": 1399729,
"target_oid": 1400649,
"status": "Identical",
"group_name": "Database Objects",
"dependencies": [],
"source_scid": 0,
"target_scid": 0
},
{
"id": 362,
"type": "foreign_server",
"label": "Foreign Servers",
"title": "fs_src",
"oid": 1399710,
"status": "Source Only",
"source_ddl": "-- Foreign Server: fs_src\n\n-- DROP SERVER fs_src\n\nCREATE SERVER fs_src\n TYPE 'PG'\n VERSION '10'\n FOREIGN DATA WRAPPER test_fdw_for_foreign_server\n OPTIONS (host '127.0.0.1', port '5432');\n\nALTER SERVER fs_src\n OWNER TO postgres;\n\nCOMMENT ON SERVER fs_src\n IS 'Foreign Server';",
"target_ddl": "",
"diff_ddl": "-- Foreign Server: fs_src\n\n-- DROP SERVER fs_src\n\nCREATE SERVER fs_src\n TYPE 'PG'\n VERSION '10'\n FOREIGN DATA WRAPPER test_fdw_for_foreign_server\n OPTIONS (host '127.0.0.1', port '5432');\n\nALTER SERVER fs_src\n OWNER TO postgres;\n\nCOMMENT ON SERVER fs_src\n IS 'Foreign Server';",
"group_name": "Database Objects",
"dependencies": [
{
"type": "foreign_data_wrapper",
"name": "test_fdw_for_foreign_server",
"oid": 1399709
}
],
"source_schema_name": null
},
{
"id": 363,
"type": "foreign_server",
"label": "Foreign Servers",
"title": "fs_tar",
"oid": 1400624,
"status": "Target Only",
"source_ddl": "",
"target_ddl": "-- Foreign Server: fs_tar\n\n-- DROP SERVER fs_tar\n\nCREATE SERVER fs_tar\n TYPE 'PG'\n VERSION '10'\n FOREIGN DATA WRAPPER test_fdw_for_foreign_server\n OPTIONS (host '127.0.0.1', port '5432');\n\nALTER SERVER fs_tar\n OWNER TO postgres;\n\nCOMMENT ON SERVER fs_tar\n IS 'Foreign Server';",
"diff_ddl": "DROP SERVER fs_tar ;",
"group_name": "Database Objects",
"dependencies": []
},
{
"id": 364,
"type": "foreign_server",
"label": "Foreign Servers",
"title": "fs_diff_options_modify",
"oid": 1399718,
"source_oid": 1399718,
"target_oid": 1400632,
"status": "Different",
"source_ddl": "-- Foreign Server: fs_diff_options_modify\n\n-- DROP SERVER fs_diff_options_modify\n\nCREATE SERVER fs_diff_options_modify\n FOREIGN DATA WRAPPER test_fdw_for_foreign_server\n OPTIONS (host '192.168.1.1', port '8080');\n\nALTER SERVER fs_diff_options_modify\n OWNER TO postgres;",
"target_ddl": "-- Foreign Server: fs_diff_options_modify\n\n-- DROP SERVER fs_diff_options_modify\n\nCREATE SERVER fs_diff_options_modify\n FOREIGN DATA WRAPPER test_fdw_for_foreign_server\n OPTIONS (host '127.0.0.1', port '5432');\n\nALTER SERVER fs_diff_options_modify\n OWNER TO postgres;",
"diff_ddl": "ALTER SERVER fs_diff_options_modify\n OPTIONS (SET host '192.168.1.1', SET port '8080');",
"group_name": "Database Objects",
"dependencies": [
{
"type": "foreign_data_wrapper",
"name": "test_fdw_for_foreign_server",
"oid": 1399709
}
]
},
{
"id": 365,
"type": "foreign_server",
"label": "Foreign Servers",
"title": "fs_diff_type_version_add",
"oid": 1399713,
"source_oid": 1399713,
"target_oid": 1400627,
"status": "Different",
"source_ddl": "-- Foreign Server: fs_diff_type_version_add\n\n-- DROP SERVER fs_diff_type_version_add\n\nCREATE SERVER fs_diff_type_version_add\n TYPE 'PG'\n VERSION '10'\n FOREIGN DATA WRAPPER test_fdw_for_foreign_server;\n\nALTER SERVER fs_diff_type_version_add\n OWNER TO postgres;",
"target_ddl": "-- Foreign Server: fs_diff_type_version_add\n\n-- DROP SERVER fs_diff_type_version_add\n\nCREATE SERVER fs_diff_type_version_add\n FOREIGN DATA WRAPPER test_fdw_for_foreign_server;\n\nALTER SERVER fs_diff_type_version_add\n OWNER TO postgres;",
"diff_ddl": "-- WARNING:\n-- We have found the difference in SERVER TYPE OR FOREIGN DATA WRAPPER\n-- so we need to drop the existing foreign server first and re-create it.\nDROP SERVER fs_diff_type_version_add;\n\nCREATE SERVER fs_diff_type_version_add\n TYPE 'PG'\n VERSION '10'\n FOREIGN DATA WRAPPER test_fdw_for_foreign_server;\n\nALTER SERVER fs_diff_type_version_add\n VERSION '10';",
"group_name": "Database Objects",
"dependencies": [
{
"type": "foreign_data_wrapper",
"name": "test_fdw_for_foreign_server",
"oid": 1399709
}
]
},
{
"id": 366,
"type": "foreign_server",
"label": "Foreign Servers",
"title": "fs_diff_acl_add",
"oid": 1399711,
"source_oid": 1399711,
"target_oid": 1400625,
"status": "Different",
"source_ddl": "-- Foreign Server: fs_diff_acl_add\n\n-- DROP SERVER fs_diff_acl_add\n\nCREATE SERVER fs_diff_acl_add\n FOREIGN DATA WRAPPER test_fdw_for_foreign_server;\n\nALTER SERVER fs_diff_acl_add\n OWNER TO postgres;\nGRANT USAGE ON FOREIGN SERVER fs_diff_acl_add TO PUBLIC;\nGRANT USAGE ON FOREIGN SERVER fs_diff_acl_add TO postgres WITH GRANT OPTION;",
"target_ddl": "-- Foreign Server: fs_diff_acl_add\n\n-- DROP SERVER fs_diff_acl_add\n\nCREATE SERVER fs_diff_acl_add\n FOREIGN DATA WRAPPER test_fdw_for_foreign_server;\n\nALTER SERVER fs_diff_acl_add\n OWNER TO postgres;",
"diff_ddl": "GRANT USAGE ON FOREIGN SERVER fs_diff_acl_add TO PUBLIC;\n\nGRANT USAGE ON FOREIGN SERVER fs_diff_acl_add TO postgres WITH GRANT OPTION;",
"group_name": "Database Objects",
"dependencies": [
{
"type": "foreign_data_wrapper",
"name": "test_fdw_for_foreign_server",
"oid": 1399709
}
]
},
{
"id": 368,
"type": "foreign_server",
"label": "Foreign Servers",
"title": "fs_diff_options_remove",
"oid": 1399717,
"source_oid": 1399717,
"target_oid": 1400631,
"status": "Different",
"source_ddl": "-- Foreign Server: fs_diff_options_remove\n\n-- DROP SERVER fs_diff_options_remove\n\nCREATE SERVER fs_diff_options_remove\n FOREIGN DATA WRAPPER test_fdw_for_foreign_server;\n\nALTER SERVER fs_diff_options_remove\n OWNER TO postgres;",
"target_ddl": "-- Foreign Server: fs_diff_options_remove\n\n-- DROP SERVER fs_diff_options_remove\n\nCREATE SERVER fs_diff_options_remove\n FOREIGN DATA WRAPPER test_fdw_for_foreign_server\n OPTIONS (host '127.0.0.1', port '5432');\n\nALTER SERVER fs_diff_options_remove\n OWNER TO postgres;",
"diff_ddl": "ALTER SERVER fs_diff_options_remove\n OPTIONS (DROP host, DROP port);",
"group_name": "Database Objects",
"dependencies": [
{
"type": "foreign_data_wrapper",
"name": "test_fdw_for_foreign_server",
"oid": 1399709
}
]
},
{
"id": 369,
"type": "foreign_server",
"label": "Foreign Servers",
"title": "fs_diff_acl_revoke",
"oid": 1399712,
"source_oid": 1399712,
"target_oid": 1400626,
"status": "Different",
"source_ddl": "-- Foreign Server: fs_diff_acl_revoke\n\n-- DROP SERVER fs_diff_acl_revoke\n\nCREATE SERVER fs_diff_acl_revoke\n FOREIGN DATA WRAPPER test_fdw_for_foreign_server;\n\nALTER SERVER fs_diff_acl_revoke\n OWNER TO postgres;",
"target_ddl": "-- Foreign Server: fs_diff_acl_revoke\n\n-- DROP SERVER fs_diff_acl_revoke\n\nCREATE SERVER fs_diff_acl_revoke\n FOREIGN DATA WRAPPER test_fdw_for_foreign_server;\n\nALTER SERVER fs_diff_acl_revoke\n OWNER TO postgres;\nGRANT USAGE ON FOREIGN SERVER fs_diff_acl_revoke TO PUBLIC;\nGRANT USAGE ON FOREIGN SERVER fs_diff_acl_revoke TO postgres WITH GRANT OPTION;",
"diff_ddl": "REVOKE ALL ON FOREIGN SERVER fs_diff_acl_revoke FROM PUBLIC;\nREVOKE ALL ON FOREIGN SERVER fs_diff_acl_revoke FROM postgres;",
"group_name": "Database Objects",
"dependencies": [
{
"type": "foreign_data_wrapper",
"name": "test_fdw_for_foreign_server",
"oid": 1399709
}
]
},
{
"id": 370,
"type": "foreign_server",
"label": "Foreign Servers",
"title": "fs_diff_type_version_modify",
"oid": 1399715,
"source_oid": 1399715,
"target_oid": 1400629,
"status": "Different",
"source_ddl": "-- Foreign Server: fs_diff_type_version_modify\n\n-- DROP SERVER fs_diff_type_version_modify\n\nCREATE SERVER fs_diff_type_version_modify\n TYPE 'PG'\n VERSION '10'\n FOREIGN DATA WRAPPER test_fdw_for_foreign_server;\n\nALTER SERVER fs_diff_type_version_modify\n OWNER TO postgres;",
"target_ddl": "-- Foreign Server: fs_diff_type_version_modify\n\n-- DROP SERVER fs_diff_type_version_modify\n\nCREATE SERVER fs_diff_type_version_modify\n TYPE 'EPAS'\n VERSION '11'\n FOREIGN DATA WRAPPER test_fdw_for_foreign_server;\n\nALTER SERVER fs_diff_type_version_modify\n OWNER TO postgres;",
"diff_ddl": "-- WARNING:\n-- We have found the difference in SERVER TYPE OR FOREIGN DATA WRAPPER\n-- so we need to drop the existing foreign server first and re-create it.\nDROP SERVER fs_diff_type_version_modify;\n\nCREATE SERVER fs_diff_type_version_modify\n TYPE 'PG'\n VERSION '10'\n FOREIGN DATA WRAPPER test_fdw_for_foreign_server;\n\nALTER SERVER fs_diff_type_version_modify\n VERSION '10';",
"group_name": "Database Objects",
"dependencies": [
{
"type": "foreign_data_wrapper",
"name": "test_fdw_for_foreign_server",
"oid": 1399709
}
]
},
{
"id": 372,
"type": "foreign_server",
"label": "Foreign Servers",
"title": "fs_diff_options_add",
"oid": 1399716,
"source_oid": 1399716,
"target_oid": 1400630,
"status": "Different",
"source_ddl": "-- Foreign Server: fs_diff_options_add\n\n-- DROP SERVER fs_diff_options_add\n\nCREATE SERVER fs_diff_options_add\n FOREIGN DATA WRAPPER test_fdw_for_foreign_server\n OPTIONS (host '127.0.0.1', port '5432');\n\nALTER SERVER fs_diff_options_add\n OWNER TO postgres;",
"target_ddl": "-- Foreign Server: fs_diff_options_add\n\n-- DROP SERVER fs_diff_options_add\n\nCREATE SERVER fs_diff_options_add\n FOREIGN DATA WRAPPER test_fdw_for_foreign_server;\n\nALTER SERVER fs_diff_options_add\n OWNER TO postgres;",
"diff_ddl": "ALTER SERVER fs_diff_options_add\n OPTIONS (ADD host '127.0.0.1', ADD port '5432');",
"group_name": "Database Objects",
"dependencies": [
{
"type": "foreign_data_wrapper",
"name": "test_fdw_for_foreign_server",
"oid": 1399709
}
]
},
{
"id": 373,
"type": "foreign_server",
"label": "Foreign Servers",
"title": "fs_diff_type_version_remove",
"oid": 1399714,
"source_oid": 1399714,
"target_oid": 1400628,
"status": "Different",
"source_ddl": "-- Foreign Server: fs_diff_type_version_remove\n\n-- DROP SERVER fs_diff_type_version_remove\n\nCREATE SERVER fs_diff_type_version_remove\n FOREIGN DATA WRAPPER test_fdw_for_foreign_server;\n\nALTER SERVER fs_diff_type_version_remove\n OWNER TO postgres;",
"target_ddl": "-- Foreign Server: fs_diff_type_version_remove\n\n-- DROP SERVER fs_diff_type_version_remove\n\nCREATE SERVER fs_diff_type_version_remove\n TYPE 'PG'\n VERSION '10'\n FOREIGN DATA WRAPPER test_fdw_for_foreign_server;\n\nALTER SERVER fs_diff_type_version_remove\n OWNER TO postgres;",
"diff_ddl": "-- WARNING:\n-- We have found the difference in SERVER TYPE OR FOREIGN DATA WRAPPER\n-- so we need to drop the existing foreign server first and re-create it.\nDROP SERVER fs_diff_type_version_remove;\n\nCREATE SERVER fs_diff_type_version_remove\n FOREIGN DATA WRAPPER test_fdw_for_foreign_server;",
"group_name": "Database Objects",
"dependencies": [
{
"type": "foreign_data_wrapper",
"name": "test_fdw_for_foreign_server",
"oid": 1399709
}
]
},
{
"id": 367,
"type": "foreign_server",
"label": "Foreign Servers",
"title": "test_fs_for_user_mapping",
"oid": 1399720,
"source_oid": 1399720,
"target_oid": 1400634,
"status": "Identical",
"group_name": "Database Objects",
"dependencies": [],
"source_scid": 0,
"target_scid": 0
},
{
"id": 371,
"type": "foreign_server",
"label": "Foreign Servers",
"title": "test_fs2_for_foreign_table",
"oid": 1399635,
"source_oid": 1399635,
"target_oid": 1400550,
"status": "Identical",
"group_name": "Database Objects",
"dependencies": [],
"source_scid": 0,
"target_scid": 0
},
{
"id": 374,
"type": "foreign_server",
"label": "Foreign Servers",
"title": "test_fs_for_foreign_table",
"oid": 1399634,
"source_oid": 1399634,
"target_oid": 1400549,
"status": "Identical",
"group_name": "Database Objects",
"dependencies": [],
"source_scid": 0,
"target_scid": 0
},
{
"id": 375,
"type": "user_mapping",
"label": "User Mappings",
"title": "postgres",
"oid": 1399722,
"source_oid": 1399722,
"target_oid": 1400636,
"status": "Different",
"source_ddl": "-- User Mapping : postgres\n\n-- DROP USER MAPPING FOR postgres SERVER test_fs_for_user_mapping\n\nCREATE USER MAPPING FOR postgres SERVER test_fs_for_user_mapping\n OPTIONS (password 'admin123');",
"target_ddl": "-- User Mapping : postgres\n\n-- DROP USER MAPPING FOR postgres SERVER test_fs_for_user_mapping\n\nCREATE USER MAPPING FOR postgres SERVER test_fs_for_user_mapping;",
"diff_ddl": "ALTER USER MAPPING FOR postgres SERVER test_fs_for_user_mapping\n OPTIONS (ADD password 'admin123');\n\n",
"group_name": "Database Objects",
"dependencies": [
{
"type": "foreign_server",
"name": "test_fs_for_user_mapping",
"oid": 1399720
}
]
},
{
"id": 376,
"type": "user_mapping",
"label": "User Mappings",
"title": "public",
"oid": 1399721,
"source_oid": 1399721,
"target_oid": 1400635,
"status": "Different",
"source_ddl": "-- User Mapping : public\n\n-- DROP USER MAPPING FOR public SERVER test_fs_for_user_mapping\n\nCREATE USER MAPPING FOR public SERVER test_fs_for_user_mapping;",
"target_ddl": "-- User Mapping : public\n\n-- DROP USER MAPPING FOR public SERVER test_fs_for_user_mapping\n\nCREATE USER MAPPING FOR public SERVER test_fs_for_user_mapping\n OPTIONS (password 'admin123');",
"diff_ddl": "ALTER USER MAPPING FOR public SERVER test_fs_for_user_mapping\n OPTIONS (DROP password);\n\n",
"group_name": "Database Objects",
"dependencies": [
{
"type": "foreign_server",
"name": "test_fs_for_user_mapping",
"oid": 1399720
}
]
},
{
"id": 377,
"type": "trigger_function",
"label": "Trigger Functions",
"title": "evt_tri_fun2()",
"oid": 1400592,
"status": "Target Only",
"source_ddl": "",
"target_ddl": "CREATE FUNCTION public.evt_tri_fun2()\n RETURNS event_trigger\n LANGUAGE 'plpgsql'\n COST 100\n VOLATILE NOT LEAKPROOF\nAS $BODY$\nBEGIN\nPERFORM 1;\nEND;\n$BODY$;\n\nALTER FUNCTION public.evt_tri_fun2()\n OWNER TO postgres;\n",
"diff_ddl": "\nDROP FUNCTION public.evt_tri_fun2();\n",
"group_name": "public",
"dependencies": []
},
{
"id": 378,
"type": "trigger_function",
"label": "Trigger Functions",
"title": "evt_tri_fun()",
"oid": 1399677,
"source_oid": 1399677,
"target_oid": 1400591,
"status": "Identical",
"group_name": "public",
"dependencies": [],
"source_scid": 2200,
"target_scid": 2200
},
{
"id": 379,
"type": "table",
"label": "Tables",
"title": "test_table_for_foreign_table",
"oid": 1399636,
"source_oid": 1399636,
"target_oid": 1400551,
"status": "Identical",
"group_name": "public",
"dependencies": [],
"source_scid": 2200,
"target_scid": 2200
},
{
"id": 380,
"type": "collation",
"label": "Collations",
"title": "coll_src",
"oid": 1399544,
"status": "Source Only",
"source_ddl": "-- Collation: coll_src;\n\n-- DROP COLLATION test_schema_diff.coll_src;\n\nCREATE COLLATION test_schema_diff.coll_src\n (LC_COLLATE = 'POSIX', LC_CTYPE = 'POSIX');\n\nALTER COLLATION test_schema_diff.coll_src\n OWNER TO postgres;\n\nCOMMENT ON COLLATION test_schema_diff.coll_src\n IS 'Test Comment';",
"target_ddl": "",
"diff_ddl": "-- Collation: coll_src;\n\n-- DROP COLLATION test_schema_diff.coll_src;\n\nCREATE COLLATION test_schema_diff.coll_src\n (LC_COLLATE = 'POSIX', LC_CTYPE = 'POSIX');\n\nALTER COLLATION test_schema_diff.coll_src\n OWNER TO postgres;\n\nCOMMENT ON COLLATION test_schema_diff.coll_src\n IS 'Test Comment';",
"group_name": "test_schema_diff",
"dependencies": [],
"source_schema_name": null
},
{
"id": 381,
"type": "collation",
"label": "Collations",
"title": "coll_tar",
"oid": 1400459,
"status": "Target Only",
"source_ddl": "",
"target_ddl": "-- Collation: coll_tar;\n\n-- DROP COLLATION test_schema_diff.coll_tar;\n\nCREATE COLLATION test_schema_diff.coll_tar\n (LC_COLLATE = 'POSIX', LC_CTYPE = 'POSIX');\n\nALTER COLLATION test_schema_diff.coll_tar\n OWNER TO postgres;",
"diff_ddl": "DROP COLLATION test_schema_diff.coll_tar;",
"group_name": "test_schema_diff",
"dependencies": []
},
{
"id": 382,
"type": "collation",
"label": "Collations",
"title": "coll_diff",
"oid": 1399545,
"source_oid": 1399545,
"target_oid": 1400460,
"status": "Different",
"source_ddl": "-- Collation: coll_diff;\n\n-- DROP COLLATION test_schema_diff.coll_diff;\n\nCREATE COLLATION test_schema_diff.coll_diff\n (LC_COLLATE = 'POSIX', LC_CTYPE = 'POSIX');\n\nALTER COLLATION test_schema_diff.coll_diff\n OWNER TO postgres;\n\nCOMMENT ON COLLATION test_schema_diff.coll_diff\n IS 'Test Comment';",
"target_ddl": "-- Collation: coll_diff;\n\n-- DROP COLLATION test_schema_diff.coll_diff;\n\nCREATE COLLATION test_schema_diff.coll_diff\n (LC_COLLATE = 'C', LC_CTYPE = 'C');\n\nALTER COLLATION test_schema_diff.coll_diff\n OWNER TO postgres;",
"diff_ddl": "-- WARNING:\n-- We have found the difference in either of LC_COLLATE or LC_CTYPE or LOCALE,\n-- so we need to drop the existing collation first and re-create it.\nDROP COLLATION test_schema_diff.coll_diff;\n\nCREATE COLLATION test_schema_diff.coll_diff\n (LC_COLLATE = 'POSIX', LC_CTYPE = 'POSIX');\n\nCOMMENT ON COLLATION test_schema_diff.coll_diff\n IS 'Test Comment';",
"group_name": "test_schema_diff",
"dependencies": []
},
{
"id": 383,
"type": "domain",
"label": "Domains",
"title": "dom_src",
"oid": 1399555,
"status": "Source Only",
"source_ddl": "-- DOMAIN: test_schema_diff.dom_src\n\n-- DROP DOMAIN test_schema_diff.dom_src;\n\nCREATE DOMAIN test_schema_diff.dom_src\n AS bigint\n DEFAULT 100\n NOT NULL;\n\nALTER DOMAIN test_schema_diff.dom_src OWNER TO postgres;\n\nALTER DOMAIN test_schema_diff.dom_src\n ADD CONSTRAINT con_src CHECK (VALUE <> 100);",
"target_ddl": "",
"diff_ddl": "-- DOMAIN: test_schema_diff.dom_src\n\n-- DROP DOMAIN test_schema_diff.dom_src;\n\nCREATE DOMAIN test_schema_diff.dom_src\n AS bigint\n DEFAULT 100\n NOT NULL;\n\nALTER DOMAIN test_schema_diff.dom_src OWNER TO postgres;\n\nALTER DOMAIN test_schema_diff.dom_src\n ADD CONSTRAINT con_src CHECK (VALUE <> 100);",
"group_name": "test_schema_diff",
"dependencies": [],
"source_schema_name": null
},
{
"id": 384,
"type": "domain",
"label": "Domains",
"title": "dom_tar",
"oid": 1400470,
"status": "Target Only",
"source_ddl": "",
"target_ddl": "-- DOMAIN: test_schema_diff.dom_tar\n\n-- DROP DOMAIN test_schema_diff.dom_tar;\n\nCREATE DOMAIN test_schema_diff.dom_tar\n AS bigint\n DEFAULT 100\n NOT NULL;\n\nALTER DOMAIN test_schema_diff.dom_tar OWNER TO postgres;\n\nALTER DOMAIN test_schema_diff.dom_tar\n ADD CONSTRAINT con_tar CHECK (VALUE <> 100);",
"diff_ddl": "\nDROP DOMAIN test_schema_diff.dom_tar CASCADE;\n",
"group_name": "test_schema_diff",
"dependencies": []
},
{
"id": 385,
"type": "domain",
"label": "Domains",
"title": "dom_type_diff",
"oid": 1399562,
"source_oid": 1399562,
"target_oid": 1400477,
"status": "Different",
"source_ddl": "-- DOMAIN: test_schema_diff.dom_type_diff\n\n-- DROP DOMAIN test_schema_diff.dom_type_diff;\n\nCREATE DOMAIN test_schema_diff.dom_type_diff\n AS character varying(40)\n COLLATE pg_catalog.\"POSIX\";\n\nALTER DOMAIN test_schema_diff.dom_type_diff OWNER TO postgres;\n\nALTER DOMAIN test_schema_diff.dom_type_diff\n ADD CONSTRAINT cons1 CHECK (VALUE::text <> 'pgAdmin3'::text);\n\nALTER DOMAIN test_schema_diff.dom_type_diff\n ADD CONSTRAINT cons2 CHECK (VALUE::text <> 'pgAdmin4'::text);\n\nCOMMENT ON DOMAIN test_schema_diff.dom_type_diff\n IS 'Test comment';",
"target_ddl": "-- DOMAIN: test_schema_diff.dom_type_diff\n\n-- DROP DOMAIN test_schema_diff.dom_type_diff;\n\nCREATE DOMAIN test_schema_diff.dom_type_diff\n AS numeric(8,4);\n\nALTER DOMAIN test_schema_diff.dom_type_diff OWNER TO postgres;\n\nALTER DOMAIN test_schema_diff.dom_type_diff\n ADD CONSTRAINT cons1 CHECK (VALUE <> 45::numeric);\n\nALTER DOMAIN test_schema_diff.dom_type_diff\n ADD CONSTRAINT cons2 CHECK (VALUE <> 50::numeric);\n\nCOMMENT ON DOMAIN test_schema_diff.dom_type_diff\n IS 'Comment';",
"diff_ddl": "-- WARNING:\n-- We have found the difference in either of datatype or collation,\n-- so we need to drop the existing domain first and re-create it.\nDROP DOMAIN test_schema_diff.dom_type_diff;\n\nCREATE DOMAIN test_schema_diff.dom_type_diff\n AS character varying(40)\n COLLATE pg_catalog.\"POSIX\";\n\n\nALTER DOMAIN test_schema_diff.dom_type_diff\n ADD CONSTRAINT cons1 CHECK (VALUE::text <> 'pgAdmin3'::text);\n\nALTER DOMAIN test_schema_diff.dom_type_diff\n ADD CONSTRAINT cons2 CHECK (VALUE::text <> 'pgAdmin4'::text);\n\nCOMMENT ON DOMAIN test_schema_diff.dom_type_diff\n IS 'Test comment';",
"group_name": "test_schema_diff",
"dependencies": []
},
{
"id": 386,
"type": "domain",
"label": "Domains",
"title": "dom_cons_diff",
"oid": 1399558,
"source_oid": 1399558,
"target_oid": 1400473,
"status": "Different",
"source_ddl": "-- DOMAIN: test_schema_diff.dom_cons_diff\n\n-- DROP DOMAIN test_schema_diff.dom_cons_diff;\n\nCREATE DOMAIN test_schema_diff.dom_cons_diff\n AS bigint\n DEFAULT 100\n NOT NULL;\n\nALTER DOMAIN test_schema_diff.dom_cons_diff OWNER TO postgres;\n\nALTER DOMAIN test_schema_diff.dom_cons_diff\n ADD CONSTRAINT cons_diff_1 CHECK (VALUE <> 50);\n\nALTER DOMAIN test_schema_diff.dom_cons_diff\n ADD CONSTRAINT cons_src_only CHECK (VALUE <> 25);",
"target_ddl": "-- DOMAIN: test_schema_diff.dom_cons_diff\n\n-- DROP DOMAIN test_schema_diff.dom_cons_diff;\n\nCREATE DOMAIN test_schema_diff.dom_cons_diff\n AS bigint\n DEFAULT 400;\n\nALTER DOMAIN test_schema_diff.dom_cons_diff OWNER TO postgres;\n\nALTER DOMAIN test_schema_diff.dom_cons_diff\n ADD CONSTRAINT cons_diff_1 CHECK (VALUE <> 40);\n\nALTER DOMAIN test_schema_diff.dom_cons_diff\n ADD CONSTRAINT cons_tar_only CHECK (VALUE <> 25);",
"diff_ddl": "ALTER DOMAIN test_schema_diff.dom_cons_diff\n SET NOT NULL;\n\nALTER DOMAIN test_schema_diff.dom_cons_diff\n SET DEFAULT 100;\n\nALTER DOMAIN test_schema_diff.dom_cons_diff\n DROP CONSTRAINT cons_tar_only;\nALTER DOMAIN test_schema_diff.dom_cons_diff\n DROP CONSTRAINT cons_diff_1;\n\nALTER DOMAIN test_schema_diff.dom_cons_diff\n ADD CONSTRAINT cons_diff_1 CHECK (VALUE <> 50);\n\nCOMMENT ON CONSTRAINT cons_diff_1 ON DOMAIN test_schema_diff.dom_cons_diff\n IS NULL;\nALTER DOMAIN test_schema_diff.dom_cons_diff\n ADD CONSTRAINT cons_src_only CHECK (VALUE <> 25);",
"group_name": "test_schema_diff",
"dependencies": []
},
{
"id": 387,
"type": "foreign_table",
"label": "Foreign Tables",
"title": "ft_src",
"oid": 1399644,
"status": "Source Only",
"source_ddl": "CREATE FOREIGN TABLE test_schema_diff.ft_src(\n fid bigint NULL,\n fname text NULL COLLATE pg_catalog.\"default\"\n)\n SERVER test_fs_for_foreign_table;\n\nALTER FOREIGN TABLE test_schema_diff.ft_src\n OWNER TO postgres;\n\nALTER FOREIGN TABLE test_schema_diff.ft_src\n ADD CONSTRAINT fcheck CHECK ((fid > 1000)) NO INHERIT;\n\nCOMMENT ON FOREIGN TABLE test_schema_diff.ft_src\n IS 'Test Comment';\n\nGRANT INSERT ON TABLE test_schema_diff.ft_src TO pg_monitor;\n\nGRANT ALL ON TABLE test_schema_diff.ft_src TO postgres;",
"target_ddl": "",
"diff_ddl": "CREATE FOREIGN TABLE test_schema_diff.ft_src(\n fid bigint NULL,\n fname text NULL COLLATE pg_catalog.\"default\"\n)\n SERVER test_fs_for_foreign_table;\n\nALTER FOREIGN TABLE test_schema_diff.ft_src\n OWNER TO postgres;\n\nALTER FOREIGN TABLE test_schema_diff.ft_src\n ADD CONSTRAINT fcheck CHECK ((fid > 1000)) NO INHERIT;\n\nCOMMENT ON FOREIGN TABLE test_schema_diff.ft_src\n IS 'Test Comment';\n\nGRANT INSERT ON TABLE test_schema_diff.ft_src TO pg_monitor;\n\nGRANT ALL ON TABLE test_schema_diff.ft_src TO postgres;",
"group_name": "test_schema_diff",
"dependencies": [
{
"type": "foreign_server",
"name": "test_fs_for_foreign_table",
"oid": 1399634
}
],
"source_schema_name": null
},
{
"id": 388,
"type": "foreign_table",
"label": "Foreign Tables",
"title": "ft_tar",
"oid": 1400559,
"status": "Target Only",
"source_ddl": "",
"target_ddl": "CREATE FOREIGN TABLE test_schema_diff.ft_tar(\n fid bigint NULL,\n fname text NULL COLLATE pg_catalog.\"default\"\n)\n SERVER test_fs_for_foreign_table;\n\nALTER FOREIGN TABLE test_schema_diff.ft_tar\n OWNER TO postgres;\n\nALTER FOREIGN TABLE test_schema_diff.ft_tar\n ADD CONSTRAINT fcheck CHECK ((fid > 1000)) NO INHERIT;\n\nCOMMENT ON FOREIGN TABLE test_schema_diff.ft_tar\n IS 'Test Comment';\n\nGRANT INSERT ON TABLE test_schema_diff.ft_tar TO pg_monitor;\n\nGRANT ALL ON TABLE test_schema_diff.ft_tar TO postgres;",
"diff_ddl": "\n\nDROP FOREIGN TABLE test_schema_diff.ft_tar;\n",
"group_name": "test_schema_diff",
"dependencies": []
},
{
"id": 389,
"type": "foreign_table",
"label": "Foreign Tables",
"title": "ft_diff_opt",
"oid": 1399659,
"source_oid": 1399659,
"target_oid": 1400574,
"status": "Different",
"source_ddl": "CREATE FOREIGN TABLE test_schema_diff.ft_diff_opt(\n fid bigint NULL,\n fname text NULL COLLATE pg_catalog.\"default\"\n)\n SERVER test_fs_for_foreign_table\n OPTIONS (opt1 'val1', opt2 'val20', opt_src 'val_src');\n\nALTER FOREIGN TABLE test_schema_diff.ft_diff_opt\n OWNER TO postgres;",
"target_ddl": "CREATE FOREIGN TABLE test_schema_diff.ft_diff_opt(\n fid bigint NULL,\n fname text NULL COLLATE pg_catalog.\"default\"\n)\n SERVER test_fs_for_foreign_table\n OPTIONS (debug 'true', opt2 'val30', opt_tar 'val_tar');\n\nALTER FOREIGN TABLE test_schema_diff.ft_diff_opt\n OWNER TO postgres;",
"diff_ddl": "ALTER FOREIGN TABLE test_schema_diff.ft_diff_opt\n OPTIONS ( DROP debug);\n\nALTER FOREIGN TABLE test_schema_diff.ft_diff_opt\n OPTIONS ( DROP opt_tar);\n\nALTER FOREIGN TABLE test_schema_diff.ft_diff_opt\n OPTIONS (ADD opt1 'val1');\n\nALTER FOREIGN TABLE test_schema_diff.ft_diff_opt\n OPTIONS (ADD opt_src 'val_src');\n\nALTER FOREIGN TABLE test_schema_diff.ft_diff_opt\n OPTIONS (SET opt2 'val20');\n\n",
"group_name": "test_schema_diff",
"dependencies": [
{
"type": "foreign_server",
"name": "test_fs_for_foreign_table",
"oid": 1399634
}
]
},
{
"id": 390,
"type": "foreign_table",
"label": "Foreign Tables",
"title": "ft_diff_foreign_server",
"oid": 1399662,
"source_oid": 1399662,
"target_oid": 1400577,
"status": "Different",
"source_ddl": "CREATE FOREIGN TABLE test_schema_diff.ft_diff_foreign_server(\n fid bigint NULL,\n fname text NULL COLLATE pg_catalog.\"default\"\n)\n SERVER test_fs_for_foreign_table;\n\nALTER FOREIGN TABLE test_schema_diff.ft_diff_foreign_server\n OWNER TO postgres;",
"target_ddl": "CREATE FOREIGN TABLE test_schema_diff.ft_diff_foreign_server(\n fid bigint NULL,\n fname text NULL COLLATE pg_catalog.\"default\"\n)\n SERVER test_fs2_for_foreign_table;\n\nALTER FOREIGN TABLE test_schema_diff.ft_diff_foreign_server\n OWNER TO postgres;",
"diff_ddl": "-- WARNING:\n-- We have found the difference in foreign server\n-- so we need to drop the existing foreign table first and re-create it.\nDROP FOREIGN TABLE test_schema_diff.ft_diff_foreign_server;\n\nCREATE FOREIGN TABLE test_schema_diff.ft_diff_foreign_server(\n fid bigint NULL,\n fname text NULL COLLATE pg_catalog.\"default\"\n)\n SERVER test_fs_for_foreign_table;\n",
"group_name": "test_schema_diff",
"dependencies": [
{
"type": "foreign_server",
"name": "test_fs_for_foreign_table",
"oid": 1399634
}
]
},
{
"id": 391,
"type": "foreign_table",
"label": "Foreign Tables",
"title": "ft_diff_const",
"oid": 1399652,
"source_oid": 1399652,
"target_oid": 1400567,
"status": "Different",
"source_ddl": "CREATE FOREIGN TABLE test_schema_diff.ft_diff_const(\n fid bigint NULL,\n fname text NULL COLLATE pg_catalog.\"default\"\n)\n SERVER test_fs_for_foreign_table;\n\nALTER FOREIGN TABLE test_schema_diff.ft_diff_const\n OWNER TO postgres;\n\nALTER FOREIGN TABLE test_schema_diff.ft_diff_const\n ADD CONSTRAINT fcheck CHECK ((fid > 1000)) NO INHERIT;\n\nALTER FOREIGN TABLE test_schema_diff.ft_diff_const\n ADD CONSTRAINT fcheck1 CHECK ((fid > 1000)) NOT VALID NO INHERIT;\n\nALTER FOREIGN TABLE test_schema_diff.ft_diff_const\n ADD CONSTRAINT fcheck2 CHECK ((fid > 20));\n\nALTER FOREIGN TABLE test_schema_diff.ft_diff_const\n ADD CONSTRAINT fcheck_src CHECK ((fid > 50));\n\nGRANT INSERT ON TABLE test_schema_diff.ft_diff_const TO pg_monitor;\n\nGRANT ALL ON TABLE test_schema_diff.ft_diff_const TO postgres;",
"target_ddl": "CREATE FOREIGN TABLE test_schema_diff.ft_diff_const(\n fid bigint NULL,\n fname text NULL COLLATE pg_catalog.\"default\"\n)\n SERVER test_fs_for_foreign_table;\n\nALTER FOREIGN TABLE test_schema_diff.ft_diff_const\n OWNER TO postgres;\n\nALTER FOREIGN TABLE test_schema_diff.ft_diff_const\n ADD CONSTRAINT fcheck CHECK ((fid > 1000)) NO INHERIT;\n\nALTER FOREIGN TABLE test_schema_diff.ft_diff_const\n ADD CONSTRAINT fcheck1 CHECK ((fid > 50)) NOT VALID NO INHERIT;\n\nALTER FOREIGN TABLE test_schema_diff.ft_diff_const\n ADD CONSTRAINT fcheck2 CHECK ((fid > 20)) NO INHERIT;\n\nALTER FOREIGN TABLE test_schema_diff.ft_diff_const\n ADD CONSTRAINT fcheck_tar CHECK ((fid > 50));\n\nGRANT INSERT ON TABLE test_schema_diff.ft_diff_const TO pg_monitor;\n\nGRANT ALL ON TABLE test_schema_diff.ft_diff_const TO postgres;",
"diff_ddl": "ALTER FOREIGN TABLE test_schema_diff.ft_diff_const\n DROP CONSTRAINT fcheck_tar;\n\nALTER FOREIGN TABLE test_schema_diff.ft_diff_const\n ADD CONSTRAINT fcheck_src CHECK ((fid > 50));\n\nALTER FOREIGN TABLE test_schema_diff.ft_diff_const\n DROP CONSTRAINT fcheck1;\n\nALTER FOREIGN TABLE test_schema_diff.ft_diff_const\n ADD CONSTRAINT fcheck1 CHECK ((fid > 1000)) NOT VALID NO INHERIT;\n\nALTER FOREIGN TABLE test_schema_diff.ft_diff_const\n DROP CONSTRAINT fcheck2;\n\nALTER FOREIGN TABLE test_schema_diff.ft_diff_const\n ADD CONSTRAINT fcheck2 CHECK ((fid > 20));\n\n",
"group_name": "test_schema_diff",
"dependencies": [
{
"type": "foreign_server",
"name": "test_fs_for_foreign_table",
"oid": 1399634
}
]
},
{
"id": 392,
"type": "foreign_table",
"label": "Foreign Tables",
"title": "ft_diff_col",
"oid": 1399648,
"source_oid": 1399648,
"target_oid": 1400563,
"status": "Different",
"source_ddl": "CREATE FOREIGN TABLE test_schema_diff.ft_diff_col(\n fid bigint NULL,\n fname text NULL COLLATE pg_catalog.\"default\",\n fcity character varying(40) NULL COLLATE pg_catalog.\"POSIX\"\n)\n SERVER test_fs_for_foreign_table;\n\nALTER FOREIGN TABLE test_schema_diff.ft_diff_col\n OWNER TO postgres;\n\nALTER FOREIGN TABLE test_schema_diff.ft_diff_col\n ADD CONSTRAINT fcheck CHECK ((fid > 1000)) NO INHERIT;\n\nCOMMENT ON FOREIGN TABLE test_schema_diff.ft_diff_col\n IS 'Test Comment';",
"target_ddl": "CREATE FOREIGN TABLE test_schema_diff.ft_diff_col(\n fid bigint NULL,\n fname text NOT NULL COLLATE pg_catalog.\"default\"\n)\n SERVER test_fs_for_foreign_table;\n\nALTER FOREIGN TABLE test_schema_diff.ft_diff_col\n OWNER TO postgres;\n\nALTER FOREIGN TABLE test_schema_diff.ft_diff_col\n ADD CONSTRAINT fcheck CHECK ((fid > 1000)) NO INHERIT;\n\nCOMMENT ON FOREIGN TABLE test_schema_diff.ft_diff_col\n IS 'Comment';\n\nGRANT INSERT ON TABLE test_schema_diff.ft_diff_col TO pg_monitor;\n\nGRANT ALL ON TABLE test_schema_diff.ft_diff_col TO postgres;",
"diff_ddl": "ALTER FOREIGN TABLE test_schema_diff.ft_diff_col\n ADD COLUMN fcity character varying(40) NULL COLLATE pg_catalog.\"POSIX\";\n\nALTER FOREIGN TABLE test_schema_diff.ft_diff_col\n ALTER COLUMN fname DROP NOT NULL;\n\nCOMMENT ON FOREIGN TABLE test_schema_diff.ft_diff_col\n IS 'Test Comment';\n\nREVOKE ALL ON TABLE test_schema_diff.ft_diff_col FROM pg_monitor;\n\nREVOKE ALL ON TABLE test_schema_diff.ft_diff_col FROM postgres;\n\n",
"group_name": "test_schema_diff",
"dependencies": [
{
"type": "foreign_server",
"name": "test_fs_for_foreign_table",
"oid": 1399634
}
]
},
{
"id": 393,
"type": "foreign_table",
"label": "Foreign Tables",
"title": "ft_diff_foreign_server_1",
"oid": 1399665,
"source_oid": 1399665,
"target_oid": 1400580,
"status": "Different",
"source_ddl": "CREATE FOREIGN TABLE test_schema_diff.ft_diff_foreign_server_1(\n fid bigint NULL,\n fname text NULL COLLATE pg_catalog.\"default\"\n)\n SERVER test_fs_for_foreign_table\n OPTIONS (opt1 'val1');\n\nALTER FOREIGN TABLE test_schema_diff.ft_diff_foreign_server_1\n OWNER TO postgres;\n\nALTER FOREIGN TABLE test_schema_diff.ft_diff_foreign_server_1\n ADD CONSTRAINT cs1 CHECK ((fid > 200)) NO INHERIT;",
"target_ddl": "CREATE FOREIGN TABLE test_schema_diff.ft_diff_foreign_server_1(\n fid bigint NULL,\n fcity text NULL COLLATE pg_catalog.\"default\"\n)\n SERVER test_fs2_for_foreign_table\n OPTIONS (opt1 'val1', opt2 'val2');\n\nALTER FOREIGN TABLE test_schema_diff.ft_diff_foreign_server_1\n OWNER TO postgres;\n\nALTER FOREIGN TABLE test_schema_diff.ft_diff_foreign_server_1\n ADD CONSTRAINT cs2 CHECK ((fid > 200)) NO INHERIT;",
"diff_ddl": "-- WARNING:\n-- We have found the difference in foreign server\n-- so we need to drop the existing foreign table first and re-create it.\nDROP FOREIGN TABLE test_schema_diff.ft_diff_foreign_server_1;\n\nCREATE FOREIGN TABLE test_schema_diff.ft_diff_foreign_server_1(\n fid bigint NULL,\n fname text NULL COLLATE pg_catalog.\"default\"\n)\n SERVER test_fs_for_foreign_table\n OPTIONS (opt1 'val1');\n\nALTER FOREIGN TABLE test_schema_diff.ft_diff_foreign_server_1\n ADD CONSTRAINT cs1 CHECK ((fid > 200)) NO INHERIT;\n",
"group_name": "test_schema_diff",
"dependencies": [
{
"type": "foreign_server",
"name": "test_fs_for_foreign_table",
"oid": 1399634
}
]
},
{
"id": 394,
"type": "fts_configuration",
"label": "FTS Configurations",
"title": "fts_con_src",
"oid": 1399546,
"status": "Source Only",
"source_ddl": "-- Text Search CONFIGURATION: test_schema_diff.fts_con_src\n\n-- DROP TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src\n\nCREATE TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src (\n\tPARSER = default\n);\n\nCOMMENT ON TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src IS 'Test Comment';\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src ADD MAPPING FOR asciihword WITH german_stem;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src ADD MAPPING FOR asciiword WITH german_stem;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src ADD MAPPING FOR email WITH simple;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src ADD MAPPING FOR file WITH simple;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src ADD MAPPING FOR float WITH simple;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src ADD MAPPING FOR host WITH simple;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src ADD MAPPING FOR hword WITH german_stem;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src ADD MAPPING FOR hword_asciipart WITH german_stem;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src ADD MAPPING FOR hword_numpart WITH simple;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src ADD MAPPING FOR hword_part WITH german_stem;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src ADD MAPPING FOR int WITH simple;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src ADD MAPPING FOR numhword WITH simple;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src ADD MAPPING FOR numword WITH simple;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src ADD MAPPING FOR sfloat WITH simple;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src ADD MAPPING FOR uint WITH simple;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src ADD MAPPING FOR url WITH simple;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src ADD MAPPING FOR url_path WITH simple;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src ADD MAPPING FOR version WITH simple;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src ADD MAPPING FOR word WITH german_stem;",
"target_ddl": "",
"diff_ddl": "-- Text Search CONFIGURATION: test_schema_diff.fts_con_src\n\n-- DROP TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src\n\nCREATE TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src (\n\tPARSER = default\n);\n\nCOMMENT ON TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src IS 'Test Comment';\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src ADD MAPPING FOR asciihword WITH german_stem;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src ADD MAPPING FOR asciiword WITH german_stem;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src ADD MAPPING FOR email WITH simple;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src ADD MAPPING FOR file WITH simple;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src ADD MAPPING FOR float WITH simple;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src ADD MAPPING FOR host WITH simple;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src ADD MAPPING FOR hword WITH german_stem;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src ADD MAPPING FOR hword_asciipart WITH german_stem;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src ADD MAPPING FOR hword_numpart WITH simple;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src ADD MAPPING FOR hword_part WITH german_stem;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src ADD MAPPING FOR int WITH simple;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src ADD MAPPING FOR numhword WITH simple;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src ADD MAPPING FOR numword WITH simple;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src ADD MAPPING FOR sfloat WITH simple;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src ADD MAPPING FOR uint WITH simple;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src ADD MAPPING FOR url WITH simple;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src ADD MAPPING FOR url_path WITH simple;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src ADD MAPPING FOR version WITH simple;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_src ADD MAPPING FOR word WITH german_stem;",
"group_name": "test_schema_diff",
"dependencies": [
{
"type": "fts_dictionary",
"name": "pg_catalog.german_stem",
"oid": 13751
}
],
"source_schema_name": null
},
{
"id": 395,
"type": "fts_configuration",
"label": "FTS Configurations",
"title": "fts_con_tar",
"oid": 1400461,
"status": "Target Only",
"source_ddl": "",
"target_ddl": "-- Text Search CONFIGURATION: test_schema_diff.fts_con_tar\n\n-- DROP TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_tar\n\nCREATE TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_tar (\n\tPARSER = default\n);\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_tar ADD MAPPING FOR asciihword WITH german_stem;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_tar ADD MAPPING FOR asciiword WITH german_stem;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_tar ADD MAPPING FOR email WITH simple;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_tar ADD MAPPING FOR file WITH simple;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_tar ADD MAPPING FOR float WITH simple;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_tar ADD MAPPING FOR host WITH simple;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_tar ADD MAPPING FOR hword WITH german_stem;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_tar ADD MAPPING FOR hword_asciipart WITH german_stem;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_tar ADD MAPPING FOR hword_numpart WITH simple;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_tar ADD MAPPING FOR hword_part WITH german_stem;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_tar ADD MAPPING FOR int WITH simple;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_tar ADD MAPPING FOR numhword WITH simple;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_tar ADD MAPPING FOR numword WITH simple;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_tar ADD MAPPING FOR sfloat WITH simple;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_tar ADD MAPPING FOR uint WITH simple;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_tar ADD MAPPING FOR url WITH simple;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_tar ADD MAPPING FOR url_path WITH simple;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_tar ADD MAPPING FOR version WITH simple;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_tar ADD MAPPING FOR word WITH german_stem;",
"diff_ddl": "DROP TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_tar ;\n",
"group_name": "test_schema_diff",
"dependencies": []
},
{
"id": 396,
"type": "fts_configuration",
"label": "FTS Configurations",
"title": "fts_con_diff",
"oid": 1399547,
"source_oid": 1399547,
"target_oid": 1400462,
"status": "Different",
"source_ddl": "-- Text Search CONFIGURATION: test_schema_diff.fts_con_diff\n\n-- DROP TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_diff\n\nCREATE TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_diff (\n\tPARSER = default\n);\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_diff ADD MAPPING FOR asciiword WITH german_stem;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_diff ADD MAPPING FOR email WITH simple;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_diff ADD MAPPING FOR hword WITH dutch_stem;",
"target_ddl": "-- Text Search CONFIGURATION: test_schema_diff.fts_con_diff\n\n-- DROP TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_diff\n\nCREATE TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_diff (\n\tPARSER = default\n);\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_diff ADD MAPPING FOR asciiword WITH dutch_stem;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_diff ADD MAPPING FOR email WITH simple;\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_diff ADD MAPPING FOR hword WITH german_stem;",
"diff_ddl": "ALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_diff\n ALTER MAPPING FOR asciiword\n WITH german_stem;\n\nALTER TEXT SEARCH CONFIGURATION test_schema_diff.fts_con_diff\n ALTER MAPPING FOR hword\n WITH dutch_stem;",
"group_name": "test_schema_diff",
"dependencies": [
{
"type": "fts_dictionary",
"name": "pg_catalog.dutch_stem",
"oid": 13743
},
{
"type": "fts_dictionary",
"name": "pg_catalog.german_stem",
"oid": 13751
},
{
"type": "role",
"name": "steve-chavez",
"field": "Owner"
}
]
},
{
"id": 397,
"type": "fts_dictionary",
"label": "FTS Dictionaries",
"title": "fts_dict_src",
"oid": 1399548,
"status": "Source Only",
"source_ddl": "-- Text Search Dictionary: test_schema_diff.fts_dict_src\n\n-- DROP TEXT SEARCH DICTIONARY test_schema_diff.fts_dict_src;\n\nCREATE TEXT SEARCH DICTIONARY test_schema_diff.fts_dict_src (\n TEMPLATE = simple,\n stopwords = english\n);\n\nCOMMENT ON TEXT SEARCH DICTIONARY test_schema_diff.fts_dict_src\n IS 'Test Comment';\n",
"target_ddl": "",
"diff_ddl": "-- Text Search Dictionary: test_schema_diff.fts_dict_src\n\n-- DROP TEXT SEARCH DICTIONARY test_schema_diff.fts_dict_src;\n\nCREATE TEXT SEARCH DICTIONARY test_schema_diff.fts_dict_src (\n TEMPLATE = simple,\n stopwords = english\n);\n\nCOMMENT ON TEXT SEARCH DICTIONARY test_schema_diff.fts_dict_src\n IS 'Test Comment';\n",
"group_name": "test_schema_diff",
"dependencies": [
{
"type": "role",
"name": "steve-chavez",
"field": "Owner"
}
],
"source_schema_name": null
},
{
"id": 398,
"type": "fts_dictionary",
"label": "FTS Dictionaries",
"title": "fts_dict_tar",
"oid": 1400463,
"status": "Target Only",
"source_ddl": "",
"target_ddl": "-- Text Search Dictionary: test_schema_diff.fts_dict_tar\n\n-- DROP TEXT SEARCH DICTIONARY test_schema_diff.fts_dict_tar;\n\nCREATE TEXT SEARCH DICTIONARY test_schema_diff.fts_dict_tar (\n TEMPLATE = simple,\n stopwords = english\n);\n\n",
"diff_ddl": "\nDROP TEXT SEARCH DICTIONARY test_schema_diff.fts_dict_tar ;\n",
"group_name": "test_schema_diff",
"dependencies": []
},
{
"id": 399,
"type": "fts_dictionary",
"label": "FTS Dictionaries",
"title": "fts_dict_diff",
"oid": 1399549,
"source_oid": 1399549,
"target_oid": 1400464,
"status": "Different",
"source_ddl": "-- Text Search Dictionary: test_schema_diff.fts_dict_diff\n\n-- DROP TEXT SEARCH DICTIONARY test_schema_diff.fts_dict_diff;\n\nCREATE TEXT SEARCH DICTIONARY test_schema_diff.fts_dict_diff (\n TEMPLATE = simple,\n stopwords = english\n);\n\nCOMMENT ON TEXT SEARCH DICTIONARY test_schema_diff.fts_dict_diff\n IS 'Test Comment';\n",
"target_ddl": "-- Text Search Dictionary: test_schema_diff.fts_dict_diff\n\n-- DROP TEXT SEARCH DICTIONARY test_schema_diff.fts_dict_diff;\n\nCREATE TEXT SEARCH DICTIONARY test_schema_diff.fts_dict_diff (\n TEMPLATE = simple,\n stopwords = german\n);\n\nCOMMENT ON TEXT SEARCH DICTIONARY test_schema_diff.fts_dict_diff\n IS 'Comment';\n",
"diff_ddl": "ALTER TEXT SEARCH DICTIONARY test_schema_diff.fts_dict_diff\n (stopwords=english);\n\nCOMMENT ON TEXT SEARCH DICTIONARY test_schema_diff.fts_dict_diff\n IS 'Test Comment';",
"group_name": "test_schema_diff",
"dependencies": [
{
"type": "role",
"name": "steve-chavez",
"field": "Owner"
}
]
},
{
"id": 400,
"type": "fts_parser",
"label": "FTS Parsers",
"title": "fts_par_src",
"oid": 1399550,
"status": "Source Only",
"source_ddl": "-- Text Search Parser: test_schema_diff.fts_par_src\n\n-- DROP TEXT SEARCH PARSER test_schema_diff.fts_par_src\n\nCREATE TEXT SEARCH PARSER test_schema_diff.fts_par_src (\n START = prsd_start,\n GETTOKEN = prsd_nexttoken,\n END = prsd_end,\n LEXTYPES = prsd_lextype\n);\n\nCOMMENT ON TEXT SEARCH PARSER test_schema_diff.fts_par_src IS 'Test Comment';",
"target_ddl": "",
"diff_ddl": "-- Text Search Parser: test_schema_diff.fts_par_src\n\n-- DROP TEXT SEARCH PARSER test_schema_diff.fts_par_src\n\nCREATE TEXT SEARCH PARSER test_schema_diff.fts_par_src (\n START = prsd_start,\n GETTOKEN = prsd_nexttoken,\n END = prsd_end,\n LEXTYPES = prsd_lextype\n);\n\nCOMMENT ON TEXT SEARCH PARSER test_schema_diff.fts_par_src IS 'Test Comment';",
"group_name": "test_schema_diff",
"dependencies": [],
"source_schema_name": null
},
{
"id": 401,
"type": "fts_parser",
"label": "FTS Parsers",
"title": "fts_par_tar",
"oid": 1400465,
"status": "Target Only",
"source_ddl": "",
"target_ddl": "-- Text Search Parser: test_schema_diff.fts_par_tar\n\n-- DROP TEXT SEARCH PARSER test_schema_diff.fts_par_tar\n\nCREATE TEXT SEARCH PARSER test_schema_diff.fts_par_tar (\n START = prsd_start,\n GETTOKEN = prsd_nexttoken,\n END = prsd_end,\n LEXTYPES = prsd_lextype\n);",
"diff_ddl": "\nDROP TEXT SEARCH PARSER test_schema_diff.fts_par_tar ;\n",
"group_name": "test_schema_diff",
"dependencies": []
},
{
"id": 402,
"type": "fts_parser",
"label": "FTS Parsers",
"title": "fts_par_diff",
"oid": 1399551,
"source_oid": 1399551,
"target_oid": 1400466,
"status": "Different",
"source_ddl": "-- Text Search Parser: test_schema_diff.fts_par_diff\n\n-- DROP TEXT SEARCH PARSER test_schema_diff.fts_par_diff\n\nCREATE TEXT SEARCH PARSER test_schema_diff.fts_par_diff (\n START = prsd_start,\n GETTOKEN = prsd_nexttoken,\n END = prsd_end,\n LEXTYPES = prsd_lextype\n);\n\nCOMMENT ON TEXT SEARCH PARSER test_schema_diff.fts_par_diff IS 'Test Comment';",
"target_ddl": "-- Text Search Parser: test_schema_diff.fts_par_diff\n\n-- DROP TEXT SEARCH PARSER test_schema_diff.fts_par_diff\n\nCREATE TEXT SEARCH PARSER test_schema_diff.fts_par_diff (\n START = int4_accum,\n GETTOKEN = inet_gist_penalty,\n END = btint2sortsupport,\n LEXTYPES = dispell_init\n);\n\nCOMMENT ON TEXT SEARCH PARSER test_schema_diff.fts_par_diff IS 'Comment';",
"diff_ddl": "-- WARNING:\n-- We have found the difference in either of START or GETTOKEN or END or\n-- LEXTYPES or HEADLINE, so we need to drop the existing parser first\n-- and re-create it.\nDROP TEXT SEARCH PARSER test_schema_diff.fts_par_diff;\n\nCREATE TEXT SEARCH PARSER test_schema_diff.fts_par_diff (\n START = prsd_start,\n GETTOKEN = prsd_nexttoken,\n END = prsd_end,\n LEXTYPES = prsd_lextype\n);\nCOMMENT ON TEXT SEARCH PARSER test_schema_diff.fts_par_diff\n IS 'Test Comment';",
"group_name": "test_schema_diff",
"dependencies": []
},
{
"id": 403,
"type": "fts_template",
"label": "FTS Templates",
"title": "fts_templ_src",
"oid": 1399552,
"status": "Source Only",
"source_ddl": "-- Text Search Template: test_schema_diff.fts_templ_src\n\n-- DROP TEXT SEARCH TEMPLATE test_schema_diff.fts_templ_src\n\nCREATE TEXT SEARCH TEMPLATE test_schema_diff.fts_templ_src (\n INIT = dispell_init,\n LEXIZE = dispell_lexize\n);\n\nCOMMENT ON TEXT SEARCH TEMPLATE test_schema_diff.fts_templ_src IS 'Test Comment';",
"target_ddl": "",
"diff_ddl": "-- Text Search Template: test_schema_diff.fts_templ_src\n\n-- DROP TEXT SEARCH TEMPLATE test_schema_diff.fts_templ_src\n\nCREATE TEXT SEARCH TEMPLATE test_schema_diff.fts_templ_src (\n INIT = dispell_init,\n LEXIZE = dispell_lexize\n);\n\nCOMMENT ON TEXT SEARCH TEMPLATE test_schema_diff.fts_templ_src IS 'Test Comment';",
"group_name": "test_schema_diff",
"dependencies": [],
"source_schema_name": null
},
{
"id": 404,
"type": "fts_template",
"label": "FTS Templates",
"title": "fts_templ_tar",
"oid": 1400467,
"status": "Target Only",
"source_ddl": "",
"target_ddl": "-- Text Search Template: test_schema_diff.fts_templ_tar\n\n-- DROP TEXT SEARCH TEMPLATE test_schema_diff.fts_templ_tar\n\nCREATE TEXT SEARCH TEMPLATE test_schema_diff.fts_templ_tar (\n INIT = dispell_init,\n LEXIZE = dispell_lexize\n);",
"diff_ddl": "\nDROP TEXT SEARCH TEMPLATE test_schema_diff.fts_templ_tar ;\n",
"group_name": "test_schema_diff",
"dependencies": []
},
{
"id": 405,
"type": "fts_template",
"label": "FTS Templates",
"title": "fts_templ_diff",
"oid": 1399553,
"source_oid": 1399553,
"target_oid": 1400468,
"status": "Different",
"source_ddl": "-- Text Search Template: test_schema_diff.fts_templ_diff\n\n-- DROP TEXT SEARCH TEMPLATE test_schema_diff.fts_templ_diff\n\nCREATE TEXT SEARCH TEMPLATE test_schema_diff.fts_templ_diff (\n INIT = dispell_init,\n LEXIZE = dispell_lexize\n);\n\nCOMMENT ON TEXT SEARCH TEMPLATE test_schema_diff.fts_templ_diff IS 'Test Comment';",
"target_ddl": "-- Text Search Template: test_schema_diff.fts_templ_diff\n\n-- DROP TEXT SEARCH TEMPLATE test_schema_diff.fts_templ_diff\n\nCREATE TEXT SEARCH TEMPLATE test_schema_diff.fts_templ_diff (\n INIT = dsimple_init,\n LEXIZE = dsimple_lexize\n);\n\nCOMMENT ON TEXT SEARCH TEMPLATE test_schema_diff.fts_templ_diff IS 'Comment';",
"diff_ddl": "-- WARNING:\n-- We have found the difference in either of INIT or LEXIZE,\n-- so we need to drop the existing template first and re-create it.\nDROP TEXT SEARCH TEMPLATE test_schema_diff.fts_templ_diff;\n\nCREATE TEXT SEARCH TEMPLATE test_schema_diff.fts_templ_diff (\n INIT = dispell_init,\n LEXIZE = dispell_lexize\n);\nCOMMENT ON TEXT SEARCH TEMPLATE test_schema_diff.fts_templ_diff\n IS 'Test Comment';",
"group_name": "test_schema_diff",
"dependencies": []
},
{
"id": 406,
"type": "function",
"label": "Functions",
"title": "typ_range_src(text, text, text)",
"oid": 1399586,
"status": "Source Only",
"source_ddl": "CREATE OR REPLACE FUNCTION test_schema_diff.typ_range_src(\n\ttext,\n\ttext,\n\ttext)\n RETURNS test_schema_diff.typ_range_src\n LANGUAGE 'internal'\n COST 1\n IMMUTABLE PARALLEL SAFE \nAS $BODY$\nrange_constructor3\n$BODY$;\n\nALTER FUNCTION test_schema_diff.typ_range_src(text, text, text)\n OWNER TO postgres;\n",
"target_ddl": "",
"diff_ddl": "CREATE OR REPLACE FUNCTION test_schema_diff.typ_range_src(\n\ttext,\n\ttext,\n\ttext)\n RETURNS test_schema_diff.typ_range_src\n LANGUAGE 'internal'\n COST 1\n IMMUTABLE PARALLEL SAFE \nAS $BODY$\nrange_constructor3\n$BODY$;\n\nALTER FUNCTION test_schema_diff.typ_range_src(text, text, text)\n OWNER TO postgres;\n",
"group_name": "test_schema_diff",
"dependencies": [
{
"type": "type",
"name": "test_schema_diff.typ_range_src",
"oid": 1399583
},
{
"type": "type",
"name": "test_schema_diff.typ_range_src",
"oid": 1399583
}
],
"source_schema_name": null
},
{
"id": 407,
"type": "function",
"label": "Functions",
"title": "typ_range_comp_diff(text, text, text)",
"oid": 1399606,
"status": "Source Only",
"source_ddl": "CREATE OR REPLACE FUNCTION test_schema_diff.typ_range_comp_diff(\n\ttext,\n\ttext,\n\ttext)\n RETURNS test_schema_diff.typ_range_comp_diff\n LANGUAGE 'internal'\n COST 1\n IMMUTABLE PARALLEL SAFE \nAS $BODY$\nrange_constructor3\n$BODY$;\n\nALTER FUNCTION test_schema_diff.typ_range_comp_diff(text, text, text)\n OWNER TO postgres;\n",
"target_ddl": "",
"diff_ddl": "CREATE OR REPLACE FUNCTION test_schema_diff.typ_range_comp_diff(\n\ttext,\n\ttext,\n\ttext)\n RETURNS test_schema_diff.typ_range_comp_diff\n LANGUAGE 'internal'\n COST 1\n IMMUTABLE PARALLEL SAFE \nAS $BODY$\nrange_constructor3\n$BODY$;\n\nALTER FUNCTION test_schema_diff.typ_range_comp_diff(text, text, text)\n OWNER TO postgres;\n",
"group_name": "test_schema_diff",
"dependencies": [
{
"type": "type",
"name": "test_schema_diff.typ_range_comp_diff",
"oid": 1399603
},
{
"type": "type",
"name": "test_schema_diff.typ_range_comp_diff",
"oid": 1399603
}
],
"source_schema_name": null
},
{
"id": 408,
"type": "function",
"label": "Functions",
"title": "typ_range_subtype_diff(character, character)",
"oid": 1399593,
"status": "Source Only",
"source_ddl": "CREATE OR REPLACE FUNCTION test_schema_diff.typ_range_subtype_diff(\n\tcharacter,\n\tcharacter)\n RETURNS test_schema_diff.typ_range_subtype_diff\n LANGUAGE 'internal'\n COST 1\n IMMUTABLE PARALLEL SAFE \nAS $BODY$\nrange_constructor2\n$BODY$;\n\nALTER FUNCTION test_schema_diff.typ_range_subtype_diff(character, character)\n OWNER TO postgres;\n",
"target_ddl": "",
"diff_ddl": "CREATE OR REPLACE FUNCTION test_schema_diff.typ_range_subtype_diff(\n\tcharacter,\n\tcharacter)\n RETURNS test_schema_diff.typ_range_subtype_diff\n LANGUAGE 'internal'\n COST 1\n IMMUTABLE PARALLEL SAFE \nAS $BODY$\nrange_constructor2\n$BODY$;\n\nALTER FUNCTION test_schema_diff.typ_range_subtype_diff(character, character)\n OWNER TO postgres;\n",
"group_name": "test_schema_diff",
"dependencies": [
{
"type": "type",
"name": "test_schema_diff.typ_range_subtype_diff",
"oid": 1399591
},
{
"type": "type",
"name": "test_schema_diff.typ_range_subtype_diff",
"oid": 1399591
}
],
"source_schema_name": null
},
{
"id": 409,
"type": "function",
"label": "Functions",
"title": "typ_range_src(text, text)",
"oid": 1399585,
"status": "Source Only",
"source_ddl": "CREATE OR REPLACE FUNCTION test_schema_diff.typ_range_src(\n\ttext,\n\ttext)\n RETURNS test_schema_diff.typ_range_src\n LANGUAGE 'internal'\n COST 1\n IMMUTABLE PARALLEL SAFE \nAS $BODY$\nrange_constructor2\n$BODY$;\n\nALTER FUNCTION test_schema_diff.typ_range_src(text, text)\n OWNER TO postgres;\n",
"target_ddl": "",
"diff_ddl": "CREATE OR REPLACE FUNCTION test_schema_diff.typ_range_src(\n\ttext,\n\ttext)\n RETURNS test_schema_diff.typ_range_src\n LANGUAGE 'internal'\n COST 1\n IMMUTABLE PARALLEL SAFE \nAS $BODY$\nrange_constructor2\n$BODY$;\n\nALTER FUNCTION test_schema_diff.typ_range_src(text, text)\n OWNER TO postgres;\n",
"group_name": "test_schema_diff",
"dependencies": [
{
"type": "type",
"name": "test_schema_diff.typ_range_src",
"oid": 1399583
},
{
"type": "type",
"name": "test_schema_diff.typ_range_src",
"oid": 1399583
}
],
"source_schema_name": null
},
{
"id": 410,
"type": "function",
"label": "Functions",
"title": "typ_range_enum_diff(text, text, text)",
"oid": 1399610,
"status": "Source Only",
"source_ddl": "CREATE OR REPLACE FUNCTION test_schema_diff.typ_range_enum_diff(\n\ttext,\n\ttext,\n\ttext)\n RETURNS test_schema_diff.typ_range_enum_diff\n LANGUAGE 'internal'\n COST 1\n IMMUTABLE PARALLEL SAFE \nAS $BODY$\nrange_constructor3\n$BODY$;\n\nALTER FUNCTION test_schema_diff.typ_range_enum_diff(text, text, text)\n OWNER TO postgres;\n",
"target_ddl": "",
"diff_ddl": "CREATE OR REPLACE FUNCTION test_schema_diff.typ_range_enum_diff(\n\ttext,\n\ttext,\n\ttext)\n RETURNS test_schema_diff.typ_range_enum_diff\n LANGUAGE 'internal'\n COST 1\n IMMUTABLE PARALLEL SAFE \nAS $BODY$\nrange_constructor3\n$BODY$;\n\nALTER FUNCTION test_schema_diff.typ_range_enum_diff(text, text, text)\n OWNER TO postgres;\n",
"group_name": "test_schema_diff",
"dependencies": [
{
"type": "type",
"name": "test_schema_diff.typ_range_enum_diff",
"oid": 1399607
},
{
"type": "type",
"name": "test_schema_diff.typ_range_enum_diff",
"oid": 1399607
}
],
"source_schema_name": null
},
{
"id": 411,
"type": "function",
"label": "Functions",
"title": "typ_range_subtype_diff(character, character, text)",
"oid": 1399594,
"status": "Source Only",
"source_ddl": "CREATE OR REPLACE FUNCTION test_schema_diff.typ_range_subtype_diff(\n\tcharacter,\n\tcharacter,\n\ttext)\n RETURNS test_schema_diff.typ_range_subtype_diff\n LANGUAGE 'internal'\n COST 1\n IMMUTABLE PARALLEL SAFE \nAS $BODY$\nrange_constructor3\n$BODY$;\n\nALTER FUNCTION test_schema_diff.typ_range_subtype_diff(character, character, text)\n OWNER TO postgres;\n",
"target_ddl": "",
"diff_ddl": "CREATE OR REPLACE FUNCTION test_schema_diff.typ_range_subtype_diff(\n\tcharacter,\n\tcharacter,\n\ttext)\n RETURNS test_schema_diff.typ_range_subtype_diff\n LANGUAGE 'internal'\n COST 1\n IMMUTABLE PARALLEL SAFE \nAS $BODY$\nrange_constructor3\n$BODY$;\n\nALTER FUNCTION test_schema_diff.typ_range_subtype_diff(character, character, text)\n OWNER TO postgres;\n",
"group_name": "test_schema_diff",
"dependencies": [
{
"type": "type",
"name": "test_schema_diff.typ_range_subtype_diff",
"oid": 1399591
},
{
"type": "type",
"name": "test_schema_diff.typ_range_subtype_diff",
"oid": 1399591
}
],
"source_schema_name": null
},
{
"id": 412,
"type": "function",
"label": "Functions",
"title": "typ_range_comp_diff(text, text)",
"oid": 1399605,
"status": "Source Only",
"source_ddl": "CREATE OR REPLACE FUNCTION test_schema_diff.typ_range_comp_diff(\n\ttext,\n\ttext)\n RETURNS test_schema_diff.typ_range_comp_diff\n LANGUAGE 'internal'\n COST 1\n IMMUTABLE PARALLEL SAFE \nAS $BODY$\nrange_constructor2\n$BODY$;\n\nALTER FUNCTION test_schema_diff.typ_range_comp_diff(text, text)\n OWNER TO postgres;\n",
"target_ddl": "",
"diff_ddl": "CREATE OR REPLACE FUNCTION test_schema_diff.typ_range_comp_diff(\n\ttext,\n\ttext)\n RETURNS test_schema_diff.typ_range_comp_diff\n LANGUAGE 'internal'\n COST 1\n IMMUTABLE PARALLEL SAFE \nAS $BODY$\nrange_constructor2\n$BODY$;\n\nALTER FUNCTION test_schema_diff.typ_range_comp_diff(text, text)\n OWNER TO postgres;\n",
"group_name": "test_schema_diff",
"dependencies": [
{
"type": "type",
"name": "test_schema_diff.typ_range_comp_diff",
"oid": 1399603
},
{
"type": "type",
"name": "test_schema_diff.typ_range_comp_diff",
"oid": 1399603
}
],
"source_schema_name": null
},
{
"id": 413,
"type": "function",
"label": "Functions",
"title": "typ_range_enum_diff(text, text)",
"oid": 1399609,
"status": "Source Only",
"source_ddl": "CREATE OR REPLACE FUNCTION test_schema_diff.typ_range_enum_diff(\n\ttext,\n\ttext)\n RETURNS test_schema_diff.typ_range_enum_diff\n LANGUAGE 'internal'\n COST 1\n IMMUTABLE PARALLEL SAFE \nAS $BODY$\nrange_constructor2\n$BODY$;\n\nALTER FUNCTION test_schema_diff.typ_range_enum_diff(text, text)\n OWNER TO postgres;\n",
"target_ddl": "",
"diff_ddl": "CREATE OR REPLACE FUNCTION test_schema_diff.typ_range_enum_diff(\n\ttext,\n\ttext)\n RETURNS test_schema_diff.typ_range_enum_diff\n LANGUAGE 'internal'\n COST 1\n IMMUTABLE PARALLEL SAFE \nAS $BODY$\nrange_constructor2\n$BODY$;\n\nALTER FUNCTION test_schema_diff.typ_range_enum_diff(text, text)\n OWNER TO postgres;\n",
"group_name": "test_schema_diff",
"dependencies": [
{
"type": "type",
"name": "test_schema_diff.typ_range_enum_diff",
"oid": 1399607
},
{
"type": "type",
"name": "test_schema_diff.typ_range_enum_diff",
"oid": 1399607
}
],
"source_schema_name": null
},
{
"id": 414,
"type": "function",
"label": "Functions",
"title": "typ_enum_range_diff(text, text)",
"oid": 1400536,
"status": "Target Only",
"source_ddl": "",
"target_ddl": "CREATE OR REPLACE FUNCTION test_schema_diff.typ_enum_range_diff(\n\ttext,\n\ttext)\n RETURNS test_schema_diff.typ_enum_range_diff\n LANGUAGE 'internal'\n COST 1\n IMMUTABLE PARALLEL SAFE \nAS $BODY$\nrange_constructor2\n$BODY$;\n\nALTER FUNCTION test_schema_diff.typ_enum_range_diff(text, text)\n OWNER TO postgres;\n",
"diff_ddl": "\nDROP FUNCTION test_schema_diff.typ_enum_range_diff(text, text);\n",
"group_name": "test_schema_diff",
"dependencies": []
},
{
"id": 415,
"type": "function",
"label": "Functions",
"title": "typ_range_tar(text, text, text)",
"oid": 1400502,
"status": "Target Only",
"source_ddl": "",
"target_ddl": "CREATE OR REPLACE FUNCTION test_schema_diff.typ_range_tar(\n\ttext,\n\ttext,\n\ttext)\n RETURNS test_schema_diff.typ_range_tar\n LANGUAGE 'internal'\n COST 1\n IMMUTABLE PARALLEL SAFE \nAS $BODY$\nrange_constructor3\n$BODY$;\n\nALTER FUNCTION test_schema_diff.typ_range_tar(text, text, text)\n OWNER TO postgres;\n",
"diff_ddl": "\nDROP FUNCTION test_schema_diff.typ_range_tar(text, text, text);\n",
"group_name": "test_schema_diff",
"dependencies": []
},
{
"id": 416,
"type": "function",
"label": "Functions",
"title": "typ_range_subtype_diff(boolean, boolean)",
"oid": 1400509,
"status": "Target Only",
"source_ddl": "",
"target_ddl": "CREATE OR REPLACE FUNCTION test_schema_diff.typ_range_subtype_diff(\n\tboolean,\n\tboolean)\n RETURNS test_schema_diff.typ_range_subtype_diff\n LANGUAGE 'internal'\n COST 1\n IMMUTABLE PARALLEL SAFE \nAS $BODY$\nrange_constructor2\n$BODY$;\n\nALTER FUNCTION test_schema_diff.typ_range_subtype_diff(boolean, boolean)\n OWNER TO postgres;\n",
"diff_ddl": "\nDROP FUNCTION test_schema_diff.typ_range_subtype_diff(boolean, boolean);\n",
"group_name": "test_schema_diff",
"dependencies": []
},
{
"id": 417,
"type": "function",
"label": "Functions",
"title": "typ_comp_range_diff(text, text)",
"oid": 1400515,
"status": "Target Only",
"source_ddl": "",
"target_ddl": "CREATE OR REPLACE FUNCTION test_schema_diff.typ_comp_range_diff(\n\ttext,\n\ttext)\n RETURNS test_schema_diff.typ_comp_range_diff\n LANGUAGE 'internal'\n COST 1\n IMMUTABLE PARALLEL SAFE \nAS $BODY$\nrange_constructor2\n$BODY$;\n\nALTER FUNCTION test_schema_diff.typ_comp_range_diff(text, text)\n OWNER TO postgres;\n",
"diff_ddl": "\nDROP FUNCTION test_schema_diff.typ_comp_range_diff(text, text);\n",
"group_name": "test_schema_diff",
"dependencies": []
},
{
"id": 418,
"type": "function",
"label": "Functions",
"title": "typ_enum_range_diff(text, text, text)",
"oid": 1400537,
"status": "Target Only",
"source_ddl": "",
"target_ddl": "CREATE OR REPLACE FUNCTION test_schema_diff.typ_enum_range_diff(\n\ttext,\n\ttext,\n\ttext)\n RETURNS test_schema_diff.typ_enum_range_diff\n LANGUAGE 'internal'\n COST 1\n IMMUTABLE PARALLEL SAFE \nAS $BODY$\nrange_constructor3\n$BODY$;\n\nALTER FUNCTION test_schema_diff.typ_enum_range_diff(text, text, text)\n OWNER TO postgres;\n",
"diff_ddl": "\nDROP FUNCTION test_schema_diff.typ_enum_range_diff(text, text, text);\n",
"group_name": "test_schema_diff",
"dependencies": []
},
{
"id": 419,
"type": "function",
"label": "Functions",
"title": "typ_range_subtype_diff(boolean, boolean, text)",
"oid": 1400510,
"status": "Target Only",
"source_ddl": "",
"target_ddl": "CREATE OR REPLACE FUNCTION test_schema_diff.typ_range_subtype_diff(\n\tboolean,\n\tboolean,\n\ttext)\n RETURNS test_schema_diff.typ_range_subtype_diff\n LANGUAGE 'internal'\n COST 1\n IMMUTABLE PARALLEL SAFE \nAS $BODY$\nrange_constructor3\n$BODY$;\n\nALTER FUNCTION test_schema_diff.typ_range_subtype_diff(boolean, boolean, text)\n OWNER TO postgres;\n",
"diff_ddl": "\nDROP FUNCTION test_schema_diff.typ_range_subtype_diff(boolean, boolean, text);\n",
"group_name": "test_schema_diff",
"dependencies": []
},
{
"id": 420,
"type": "function",
"label": "Functions",
"title": "typ_range_tar(text, text)",
"oid": 1400501,
"status": "Target Only",
"source_ddl": "",
"target_ddl": "CREATE OR REPLACE FUNCTION test_schema_diff.typ_range_tar(\n\ttext,\n\ttext)\n RETURNS test_schema_diff.typ_range_tar\n LANGUAGE 'internal'\n COST 1\n IMMUTABLE PARALLEL SAFE \nAS $BODY$\nrange_constructor2\n$BODY$;\n\nALTER FUNCTION test_schema_diff.typ_range_tar(text, text)\n OWNER TO postgres;\n",
"diff_ddl": "\nDROP FUNCTION test_schema_diff.typ_range_tar(text, text);\n",
"group_name": "test_schema_diff",
"dependencies": []
},
{
"id": 421,
"type": "function",
"label": "Functions",
"title": "typ_comp_range_diff(text, text, text)",
"oid": 1400516,
"status": "Target Only",
"source_ddl": "",
"target_ddl": "CREATE OR REPLACE FUNCTION test_schema_diff.typ_comp_range_diff(\n\ttext,\n\ttext,\n\ttext)\n RETURNS test_schema_diff.typ_comp_range_diff\n LANGUAGE 'internal'\n COST 1\n IMMUTABLE PARALLEL SAFE \nAS $BODY$\nrange_constructor3\n$BODY$;\n\nALTER FUNCTION test_schema_diff.typ_comp_range_diff(text, text, text)\n OWNER TO postgres;\n",
"diff_ddl": "\nDROP FUNCTION test_schema_diff.typ_comp_range_diff(text, text, text);\n",
"group_name": "test_schema_diff",
"dependencies": []
},
{
"id": 422,
"type": "function",
"label": "Functions",
"title": "gbt_ts_union(internal, internal)",
"oid": 1399042,
"source_oid": 1399042,
"target_oid": 1399948,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 423,
"type": "function",
"label": "Functions",
"title": "gbt_date_fetch(internal)",
"oid": 1399126,
"source_oid": 1399126,
"target_oid": 1400032,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 424,
"type": "function",
"label": "Functions",
"title": "gbtreekey8_in(cstring)",
"oid": 1398835,
"source_oid": 1398835,
"target_oid": 1399741,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 425,
"type": "function",
"label": "Functions",
"title": "gbt_numeric_union(internal, internal)",
"oid": 1399291,
"source_oid": 1399291,
"target_oid": 1400197,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 426,
"type": "function",
"label": "Functions",
"title": "gbt_uuid_union(internal, internal)",
"oid": 1399388,
"source_oid": 1399388,
"target_oid": 1400294,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 427,
"type": "function",
"label": "Functions",
"title": "typ_range_col_diff(text, text)",
"oid": 1399589,
"source_oid": 1399589,
"target_oid": 1400505,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 428,
"type": "function",
"label": "Functions",
"title": "gbt_time_penalty(internal, internal, internal)",
"oid": 1399086,
"source_oid": 1399086,
"target_oid": 1399992,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 429,
"type": "function",
"label": "Functions",
"title": "gbtreekey4_out(test_schema_diff.gbtreekey4)",
"oid": 1398832,
"source_oid": 1398832,
"target_oid": 1399738,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 430,
"type": "function",
"label": "Functions",
"title": "gbtreekey16_in(cstring)",
"oid": 1398839,
"source_oid": 1398839,
"target_oid": 1399745,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 431,
"type": "function",
"label": "Functions",
"title": "gbt_macad_same(test_schema_diff.gbtreekey16, test_schema_diff.gbtreekey16, internal)",
"oid": 1399208,
"source_oid": 1399208,
"target_oid": 1400114,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 432,
"type": "function",
"label": "Functions",
"title": "gbtreekey8_out(test_schema_diff.gbtreekey8)",
"oid": 1398836,
"source_oid": 1398836,
"target_oid": 1399742,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 433,
"type": "function",
"label": "Functions",
"title": "gbt_int8_penalty(internal, internal, internal)",
"oid": 1398959,
"source_oid": 1398959,
"target_oid": 1399865,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 434,
"type": "function",
"label": "Functions",
"title": "gbt_int2_picksplit(internal, internal)",
"oid": 1398908,
"source_oid": 1398908,
"target_oid": 1399814,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 435,
"type": "function",
"label": "Functions",
"title": "gbt_float4_penalty(internal, internal, internal)",
"oid": 1398985,
"source_oid": 1398985,
"target_oid": 1399891,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 436,
"type": "function",
"label": "Functions",
"title": "gbt_int4_consistent(internal, integer, smallint, oid, internal)",
"oid": 1398929,
"source_oid": 1398929,
"target_oid": 1399835,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 437,
"type": "function",
"label": "Functions",
"title": "gbt_uuid_consistent(internal, uuid, smallint, oid, internal)",
"oid": 1399383,
"source_oid": 1399383,
"target_oid": 1400289,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 438,
"type": "function",
"label": "Functions",
"title": "gbt_date_consistent(internal, date, smallint, oid, internal)",
"oid": 1399123,
"source_oid": 1399123,
"target_oid": 1400029,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 439,
"type": "function",
"label": "Functions",
"title": "gbt_enum_union(internal, internal)",
"oid": 1399434,
"source_oid": 1399434,
"target_oid": 1400340,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 440,
"type": "function",
"label": "Functions",
"title": "gbt_time_distance(internal, time without time zone, smallint, oid, internal)",
"oid": 1399081,
"source_oid": 1399081,
"target_oid": 1399987,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 441,
"type": "function",
"label": "Functions",
"title": "gbt_oid_compress(internal)",
"oid": 1398877,
"source_oid": 1398877,
"target_oid": 1399783,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 442,
"type": "function",
"label": "Functions",
"title": "gbt_var_fetch(internal)",
"oid": 1398880,
"source_oid": 1398880,
"target_oid": 1399786,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 443,
"type": "function",
"label": "Functions",
"title": "gbtreekey32_in(cstring)",
"oid": 1398843,
"source_oid": 1398843,
"target_oid": 1399749,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 444,
"type": "function",
"label": "Functions",
"title": "gbt_time_consistent(internal, time without time zone, smallint, oid, internal)",
"oid": 1399080,
"source_oid": 1399080,
"target_oid": 1399986,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 445,
"type": "function",
"label": "Functions",
"title": "gbt_bit_consistent(internal, bit, smallint, oid, internal)",
"oid": 1399309,
"source_oid": 1399309,
"target_oid": 1400215,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 446,
"type": "function",
"label": "Functions",
"title": "gbt_macad_compress(internal)",
"oid": 1399203,
"source_oid": 1399203,
"target_oid": 1400109,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 447,
"type": "function",
"label": "Functions",
"title": "gbt_int4_penalty(internal, internal, internal)",
"oid": 1398933,
"source_oid": 1398933,
"target_oid": 1399839,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 448,
"type": "function",
"label": "Functions",
"title": "gbt_int8_picksplit(internal, internal)",
"oid": 1398960,
"source_oid": 1398960,
"target_oid": 1399866,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 449,
"type": "function",
"label": "Functions",
"title": "cash_dist(money, money)",
"oid": 1398850,
"source_oid": 1398850,
"target_oid": 1399756,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 450,
"type": "function",
"label": "Functions",
"title": "gbt_text_picksplit(internal, internal)",
"oid": 1399230,
"source_oid": 1399230,
"target_oid": 1400136,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 451,
"type": "function",
"label": "Functions",
"title": "gbt_bpchar_consistent(internal, character, smallint, oid, internal)",
"oid": 1399226,
"source_oid": 1399226,
"target_oid": 1400132,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 452,
"type": "function",
"label": "Functions",
"title": "gbt_float8_picksplit(internal, internal)",
"oid": 1399012,
"source_oid": 1399012,
"target_oid": 1399918,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 453,
"type": "function",
"label": "Functions",
"title": "gbt_uuid_fetch(internal)",
"oid": 1399384,
"source_oid": 1399384,
"target_oid": 1400290,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 454,
"type": "function",
"label": "Functions",
"title": "gbt_numeric_penalty(internal, internal, internal)",
"oid": 1399289,
"source_oid": 1399289,
"target_oid": 1400195,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 455,
"type": "function",
"label": "Functions",
"title": "gbt_ts_fetch(internal)",
"oid": 1399039,
"source_oid": 1399039,
"target_oid": 1399945,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 456,
"type": "function",
"label": "Functions",
"title": "gbt_time_compress(internal)",
"oid": 1399083,
"source_oid": 1399083,
"target_oid": 1399989,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 457,
"type": "function",
"label": "Functions",
"title": "gbt_time_union(internal, internal)",
"oid": 1399088,
"source_oid": 1399088,
"target_oid": 1399994,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 458,
"type": "function",
"label": "Functions",
"title": "gbt_int4_picksplit(internal, internal)",
"oid": 1398934,
"source_oid": 1398934,
"target_oid": 1399840,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 459,
"type": "function",
"label": "Functions",
"title": "gbt_time_picksplit(internal, internal)",
"oid": 1399087,
"source_oid": 1399087,
"target_oid": 1399993,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 460,
"type": "function",
"label": "Functions",
"title": "gbt_bytea_union(internal, internal)",
"oid": 1399269,
"source_oid": 1399269,
"target_oid": 1400175,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 461,
"type": "function",
"label": "Functions",
"title": "gbt_int2_compress(internal)",
"oid": 1398905,
"source_oid": 1398905,
"target_oid": 1399811,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 462,
"type": "function",
"label": "Functions",
"title": "gbt_enum_consistent(internal, anyenum, smallint, oid, internal)",
"oid": 1399429,
"source_oid": 1399429,
"target_oid": 1400335,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 463,
"type": "function",
"label": "Functions",
"title": "gbt_date_picksplit(internal, internal)",
"oid": 1399128,
"source_oid": 1399128,
"target_oid": 1400034,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 464,
"type": "function",
"label": "Functions",
"title": "gbt_float4_same(test_schema_diff.gbtreekey8, test_schema_diff.gbtreekey8, internal)",
"oid": 1398988,
"source_oid": 1398988,
"target_oid": 1399894,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 465,
"type": "function",
"label": "Functions",
"title": "gbt_oid_distance(internal, oid, smallint, oid, internal)",
"oid": 1398875,
"source_oid": 1398875,
"target_oid": 1399781,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 466,
"type": "function",
"label": "Functions",
"title": "gbt_macad8_picksplit(internal, internal)",
"oid": 1399410,
"source_oid": 1399410,
"target_oid": 1400316,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 467,
"type": "function",
"label": "Functions",
"title": "gbt_float8_fetch(internal)",
"oid": 1399010,
"source_oid": 1399010,
"target_oid": 1399916,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 468,
"type": "function",
"label": "Functions",
"title": "gbt_int2_penalty(internal, internal, internal)",
"oid": 1398907,
"source_oid": 1398907,
"target_oid": 1399813,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 469,
"type": "function",
"label": "Functions",
"title": "gbtreekey4_in(cstring)",
"oid": 1398831,
"source_oid": 1398831,
"target_oid": 1399737,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 470,
"type": "function",
"label": "Functions",
"title": "int2_dist(smallint, smallint)",
"oid": 1398858,
"source_oid": 1398858,
"target_oid": 1399764,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 471,
"type": "function",
"label": "Functions",
"title": "gbt_float4_compress(internal)",
"oid": 1398983,
"source_oid": 1398983,
"target_oid": 1399889,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 472,
"type": "function",
"label": "Functions",
"title": "gbt_int8_same(test_schema_diff.gbtreekey16, test_schema_diff.gbtreekey16, internal)",
"oid": 1398962,
"source_oid": 1398962,
"target_oid": 1399868,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 473,
"type": "function",
"label": "Functions",
"title": "gbt_date_union(internal, internal)",
"oid": 1399129,
"source_oid": 1399129,
"target_oid": 1400035,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 474,
"type": "function",
"label": "Functions",
"title": "gbt_intv_same(test_schema_diff.gbtreekey32, test_schema_diff.gbtreekey32, internal)",
"oid": 1399157,
"source_oid": 1399157,
"target_oid": 1400063,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 475,
"type": "function",
"label": "Functions",
"title": "tstz_dist(timestamp with time zone, timestamp with time zone)",
"oid": 1398872,
"source_oid": 1398872,
"target_oid": 1399778,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 476,
"type": "function",
"label": "Functions",
"title": "gbt_inet_penalty(internal, internal, internal)",
"oid": 1399349,
"source_oid": 1399349,
"target_oid": 1400255,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 477,
"type": "function",
"label": "Functions",
"title": "gbt_float4_union(internal, internal)",
"oid": 1398987,
"source_oid": 1398987,
"target_oid": 1399893,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 478,
"type": "function",
"label": "Functions",
"title": "gbt_int2_union(internal, internal)",
"oid": 1398909,
"source_oid": 1398909,
"target_oid": 1399815,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 479,
"type": "function",
"label": "Functions",
"title": "gbt_bit_union(internal, internal)",
"oid": 1399313,
"source_oid": 1399313,
"target_oid": 1400219,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 480,
"type": "function",
"label": "Functions",
"title": "gbt_int4_distance(internal, integer, smallint, oid, internal)",
"oid": 1398930,
"source_oid": 1398930,
"target_oid": 1399836,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 481,
"type": "function",
"label": "Functions",
"title": "gbt_float8_distance(internal, double precision, smallint, oid, internal)",
"oid": 1399008,
"source_oid": 1399008,
"target_oid": 1399914,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 482,
"type": "function",
"label": "Functions",
"title": "gbt_intv_fetch(internal)",
"oid": 1399153,
"source_oid": 1399153,
"target_oid": 1400059,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 483,
"type": "function",
"label": "Functions",
"title": "time_dist(time without time zone, time without time zone)",
"oid": 1398868,
"source_oid": 1398868,
"target_oid": 1399774,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 484,
"type": "function",
"label": "Functions",
"title": "date_dist(date, date)",
"oid": 1398852,
"source_oid": 1398852,
"target_oid": 1399758,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 485,
"type": "function",
"label": "Functions",
"title": "gbt_inet_picksplit(internal, internal)",
"oid": 1399350,
"source_oid": 1399350,
"target_oid": 1400256,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 486,
"type": "function",
"label": "Functions",
"title": "gbt_text_compress(internal)",
"oid": 1399227,
"source_oid": 1399227,
"target_oid": 1400133,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 487,
"type": "function",
"label": "Functions",
"title": "gbt_cash_penalty(internal, internal, internal)",
"oid": 1399180,
"source_oid": 1399180,
"target_oid": 1400086,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 488,
"type": "function",
"label": "Functions",
"title": "gbt_cash_compress(internal)",
"oid": 1399178,
"source_oid": 1399178,
"target_oid": 1400084,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 489,
"type": "function",
"label": "Functions",
"title": "gbt_intv_penalty(internal, internal, internal)",
"oid": 1399154,
"source_oid": 1399154,
"target_oid": 1400060,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 490,
"type": "function",
"label": "Functions",
"title": "gbt_cash_same(test_schema_diff.gbtreekey16, test_schema_diff.gbtreekey16, internal)",
"oid": 1399183,
"source_oid": 1399183,
"target_oid": 1400089,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 491,
"type": "function",
"label": "Functions",
"title": "gbt_cash_picksplit(internal, internal)",
"oid": 1399181,
"source_oid": 1399181,
"target_oid": 1400087,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 492,
"type": "function",
"label": "Functions",
"title": "gbt_intv_union(internal, internal)",
"oid": 1399156,
"source_oid": 1399156,
"target_oid": 1400062,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 493,
"type": "function",
"label": "Functions",
"title": "gbt_int8_compress(internal)",
"oid": 1398957,
"source_oid": 1398957,
"target_oid": 1399863,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 494,
"type": "function",
"label": "Functions",
"title": "gbt_macad8_compress(internal)",
"oid": 1399407,
"source_oid": 1399407,
"target_oid": 1400313,
"status": "Identical",
"group_name": "test_schema_diff",
"dependencies": [],
"source_scid": 1398828,
"target_scid": 1399734
},
{
"id": 495,
"type": "function",