Power automate to delete/append Postgresql table

Like (1) Share

Report

Posted on 13 Sep 2024 20:20:54 by SC-13092016-0

Hi All,

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

Shab

Categories:

Business Processes

All responses (1)

Answers (0)

Suggested answer

Michael E. Gernaey 38,255 Super User 2025 Season 1 on 14 Sep 2024 at 04:13:38

Like (0)

Report

Power automate to delete/append Postgresql table

HI

Its super straight forward the error tells you.

1. You need a primary key for those actions (delete)

2. Your table doesn't have one

so whats the solution

Add One

If this answers your question please mark the answer