Stored Procedure Transaction Group & PostrgreSQL

Ignition
1

Has anyone ran into trying to run a stored procedure transaction group utilizing a PostgreSQL database, and the stored procedure not populate in the drop down in the transaction group configuration?

I can manually run this procedure inside the designer using the query browser, and I haven't had any other DB issues thus far.

My ignition version is 8.1.41 and my Postgres version is 16. I will add to this that my setup is in a docker environment if that would matter at all. Haven't ever run into this before though.

2

Just in case it helps anyone in the future, my issue was is I had indeed not created a stored procedure I had created a function. Which would explain why there was not one in my dropdown.

2 Likes