toluaina / pgsync

Postgres to Elasticsearch/OpenSearch sync
https://pgsync.com
MIT License
1.1k stars 172 forks source link

Primary Key Not Found Error #446

Open ravikumarbalraj opened 1 year ago

ravikumarbalraj commented 1 year ago

PGSync version: 2.5.0

Postgres version: 15

Openserch version: 2.5

Redis version: 7

Python version: 3.11

Problem Description: We don't have primary key in our table. Is this is mandatory or any other configuration for disabling the primary key error.

Error Message (if any):

pgsync.exc.PrimaryKeyNotFoundError: 'No primary key found on table:

toluaina commented 10 months ago

Unless it's the root node, a primary key is required for joining relationships.