pgsync.exc.foreignkeyerror:“public.book”和“public.book\u author”之间没有外键关系”

ryevplcw  于 2021-06-14  发布在  ElasticSearch
关注(0)|答案(0)|浏览(186)

elasticsearch索引无法通过pgsync工作
下面是我的schema.json

[
  {
    "database": "book",
    "index": "book_data",
    "nodes": [
      {
        "table": "book",
        "schema": "public",
        "columns": ["id", "title", "isbin"],
        "children": [
          {
            "table": "book_author",
            "schema": "public",
            "columns": ["id", "book_id", "author"],
            "relationship": {
              "variant": "object",
              "type": "one_to_one"
            }
          }
        ]
      }
    ]
  }
]

由于创建索引时pgsync抛出错误,上表没有外键约束 pgsync.exc.ForeignKeyError: 'No foreign key relationship between "public.book" and "public.book_author"' 如果我对定义了外键的表执行相同的操作,那么它将正常工作。
关于如何做到这一点而不添加外键约束的任何解决方案。

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题