Skip to main content

Notifications

Community site session details

Community site session details

Session Id : fNL2YO3qMhUJLVeOmfbvEO
Power Automate - AI Builder
Unanswered

Power automate to delete/append Postgresql table

Like (1) ShareShare
ReportReport
Posted on 13 Sep 2024 20:20:54 by 2
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:
  • Suggested answer
    Michael E. Gernaey Profile Picture
    42,549 Super User 2025 Season 1 on 14 Sep 2024 at 04:13:38
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Automate - AI Builder

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 8 Super User 2025 Season 1

#2
CA-07040719-0 Profile Picture

CA-07040719-0 4

#2
takolota1 Profile Picture

takolota1 4 Super User 2025 Season 1

Overall leaderboard
Loading started