Postgre SQL GUI Mode bulk Update records gives error

Queries and Resources
1

Hi,

I am developing a panel for bulk updating/inserting records in postgres.

I created a table and a query for bulk update using GUI Mode.

But I get an error in screenshot I attached.

image
image1294×619 63.8 KB

I have followed the retool documents and I dont know what I am missing.

Is there a solution or any other way for Bulk updating/inserting records on retool with postgres?

Thanks.

2

Hey, @dev1 could you share a screenshot of your full query and what AdminTable.recordUpdates evaluates to please? If the data is sensitive you could also write in to our support chat so we can take a closer look! We will update this post as soon as we figure out the issue. Thank You!