![How to sync DB to salesforce if updates done by custom triggers using Heroku connect. – TECH ON RIA – Shubham's Blog How to sync DB to salesforce if updates done by custom triggers using Heroku connect. – TECH ON RIA – Shubham's Blog](https://techonria.files.wordpress.com/2018/02/team-trailhead_heroku_en-us_salesforce-heroku-integration_images_heroku-connect_9e8f2e26c7a5dd0df003996d41ee67b4.jpg)
How to sync DB to salesforce if updates done by custom triggers using Heroku connect. – TECH ON RIA – Shubham's Blog
I am able to insert static data in heroko postgresql as insert into table(field1, field2) values('val1', val2) But, when I am making it dynamic by setting input parameter it is not working.
![ERROR: cannot execute TRUNCATE TABLE in a read-only transaction` in Heroku PostgreSQL - Stack Overflow ERROR: cannot execute TRUNCATE TABLE in a read-only transaction` in Heroku PostgreSQL - Stack Overflow](https://i.stack.imgur.com/ns93A.png)