Inconsistent relationship behavior

[jpughcs]

• Leaf relationship with empty dataset causes sync issues with intermediate relationship data
• Inconsistent relationship trigger behavior (data change not propagating backwards)

I am only experiencing issues with the former, but I am including the full message here by @lehuuthien2 below:

    i don't know if my problem is same as above, but i also have 3 tier relationship. You treat the middle tier (train_stations) like an pivot table, but it's a normal table and has subdata as the 3rd tier (train_station_floors) (3rd tier may or may not have data).

Problems:

• If there is no data in the 3rd tier, the 2nd tier will not be indexed even though it has data
• When the 3rd tier changes (insert, update,...) nothing happens, and I have to update the 2nd tier to sync the data

  "table": "railway_assets",
  "schema": "public",
  "columns": [
  "id",
  "company_id",
  "area_id",
  "name",
  "milepost",
  "image"
  ],
  "children": [
  {
      "table": "train_stations",
      "label": "train_station",
      "schema": "public",
      "columns": [
          "id",
          "railway_asset_id",
          "type",
          "area",
      ],
      "relationship": {
          "variant": "object",
          "type": "one_to_one",
          "foreign_key": {
              "child": [
                  "railway_asset_id"
              ],
              "parent": [
                  "id"
              ]
          }
      },
      "children": [
          {
              "table": "train_station_floors",
              "label": "train_station_floors",
              "relationship": {
                  "variant": "object",
                  "type": "one_to_many",
                  "foreign_key": {
                      "child": [
                          "train_station_id"
                      ],
                      "parent": [
                          "id"
                      ]
                  }
              }
          }
      ]
  }
  ]

  Originally posted by @lehuuthien2 in https://github.com/toluaina/pgsync/issues/199#issuecomment-1059002314

[toluaina]

Hi, Sorry for the delay. This has been addressed in the main branch. Can you try this out, please?

[jpughcs]

This appears to be resolved