Plugin Contributor
Kim L
(@kimmyx)
Hi @recallza,
Tables are created on our data server without a primary key. Remote primary keys are not recognized automatically. You need to add a primary key to enable transactions.
To add primary keys, you may use the SQL Query Builder or Data Designer.
Let us know if you have other questions. 😊
Hi Kim,
Thank you for the reply.
I’m not sure I’m following – please forgive me if I’m not understanding the process correctly. I will list what I’m doing below in steps
- I use data explorer to connect to my remote postgres table
- This then creates a table on the rdb:wpdafree.youniquedata.com database which keeps the data syncronised.
- I can go to data explorer, and view the newly created table in database ‘wpdafree.youniquedata.com’ where I can see the primary key isn’t set as you mentioned above. I can then manage the table and alter it, and set a primary key manually but this doesn’t seem to take affect and I’m still prompted with no Primary Key set when I try create an application
Please let me know if I’m doing something wrong?
Plugin Contributor
Kim L
(@kimmyx)
Hi @recallza,
Could you send us a ticket for this issue? We might need to take a closer look.
I’ll close this thread as premium features need to be addressed in our premium support channel.
We’ll wait for your email!
