Issue with Primary Key with Remote Postgres Table

  • Resolved recallza

    (@recallza)


    2 months ago

    Hi,

    I’m remotely connecting to my Postgres Database, and my Postgres table has a primary key, but when its imported into WP Data Access it unfortunately doesn’t show the table with a primary key.

    I’m unable to edit values in the table because of this issue.

    Please assist

Viewing 3 replies - 1 through 3 (of 3 total)
  • 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. ??

    Thread Starter recallza

    (@recallza)

    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

    1. I use data explorer to connect to my remote postgres table
    2. This then creates a table on the rdb:wpdafree.youniquedata.com database which keeps the data syncronised.
    3. 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!

Viewing 3 replies - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.