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"'
如果我对定义了外键的表执行相同的操作,那么它将正常工作。
关于如何做到这一点而不添加外键约束的任何解决方案。
暂无答案!
目前还没有任何答案,快来回答吧!