Postgres Function Execution Error


We are encountering a peculiar bug when attempting to execute a database function through Retool. Retool returns an error (screenshot attached) which we believe to be incorrect. Here are the details:

  • Even with this error, The function runs to completion successfully.
  • Executing the same function and values directly using a database client outside retool yields no errors.

Additionally, the success handler event that typically runs upon successful execution is not being triggered due to this bug.

Your assistance in resolving this issue would be greatly appreciated.

Hi @heroes_timothygithinji Thanks for reaching out! :thinking: Maybe there is a parsing or permissions issue

Does it make any difference if you hardcode the dynamic inputs? (i.e tab3valueHere::integer, instead of {{tabs3.value}}::integer,)
What is the expected data response?