Postgresql error while sql execution

Question

Hi Guys, I'm facing the postgresql error while SQL execution to update the table name. Let me know why i'm facing this error and i can execute the same SQL in V7 and i'm facing the issue while executing the same in V8

isahore · Accepted Answer

Hi @haricharan,

To update temp table data in ACC v8 using the above script, you must use the "change data source" activity, and select "default data source" in the activity. Then your script should work fine if there are no other syntax errors.

Let me know if that helped.

BR,

Ishan

AkshayAnand · Answer

Hi @haricharan

The error states that the temp table you are trying to access is invalid, could you check the temp table name by enabling the SQL logs in the properties of the workflow.

Hope this helps!

You can try inserting the value through JavaScript write method also. For reference.

Thanks

Akshay

Sign up

Login with SSO

Login to the community

Login with SSO