Hi, I have an external postgreSQL database hosted on AWS, and when I'm doing the Insert/Select from the database is working ok, however, when I'm trying to UPDATE the record ,it shows the following error, really appreciate any advice!
I think this error its mean: have problem with column "public".
You can check again in postgreSQL about User_consent table, other related table, column "public" → update table in Integration Studio → update Entity in Service Studio.
Hello GuoXin Tian,
This error clearly states that it fails to recognize the column that you are tying to update. Also there can be a case sensitivity issue. To resolve this issue, provide the same case for source and target columns.
Hi Shubham,
I added some new columns in my external postgreSQL database, may I ask how to save the change into service studio? It looks like whenever I made the change, I need to create a new connection in integration studio and connect in Service studio
Hello, i think i have similiar issue like GuoXin Tian.
So the error "column 'xxx' on relation 'yyyyy'" happened where the 'xxx' is the schema and 'yyyy' is table name. Is there any solution for this? I'm using PostgreSQL too
I'm facing same problem, has anybody got a solution for this? I'm also not able to get Update/Delete built-in DB actions of entity, though user has write permission in DB.
For me, the update issue can be solved by changing "SET {tablename}.[columnname] = value" to "SET columnname = value".
And for your issue in not able to get Update/Delete on external db, did you have 2 primary key on the table? or in other case, you must specify identifier column of the table in integration studio
Thanks a lot Abby, It solved my problem of update! your other suggestion is also helpful, table has a column 'Key' of type Serial4 with Sequence created on that so I thought that will work like a Primary key but its actually not, this is why I'm not getting Update/Delete actions. I'm checking possibility to define an Identifier column as we are implementing new app over an existing DB.