I am trying to delete existing table and updating a new table on Postgresql using power automate. Seems like there is no primary key on the Postgresql table. I am getting the below error. Any idea how to fix this? I table has a index column with unique number in each row, I am trying to use that a primary key, but it does not work.
"
The specified table has no primary key. Update and delete operations are not supported.
inner exception: The specified table has no primary key. Update and delete operations are not supported.
clientRequestId: 055ca333-81c5-495e-8559-f33986dbf148
"
Thanks