Skip to main content

Notifications

Community site session details

Community site session details

Session Id : k7x0IwL01bGJmRA1iNUfx1
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
    38,255 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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,513 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,681 Most Valuable Professional

Leaderboard
Loading started
Loading complete