# Stored Procedure Transaction Group & PostrgreSQL

**URL:** <https://forum.inductiveautomation.com/t/stored-procedure-transaction-group-postrgresql/92725>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [July 3, 2024, 1:30am UTC](https://forum.inductiveautomation.com/t/stored-procedure-transaction-group-postrgresql/92725 "2024-07-03T01:30:26Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![elijah.roberts](https://avatars.discourse-cdn.com/v4/letter/e/a6a055/32.png) [@elijah.roberts](https://forum.inductiveautomation.com/u/elijah.roberts)\
**Post date:** [July 3, 2024, 1:30am UTC](https://forum.inductiveautomation.com/t/stored-procedure-transaction-group-postrgresql/92725/1 "2024-07-03T01:30:26Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![elijah.roberts](https://avatars.discourse-cdn.com/v4/letter/e/a6a055/32.png) [@elijah.roberts](https://forum.inductiveautomation.com/u/elijah.roberts)\
**Post date:** [July 3, 2024, 2:21am UTC](https://forum.inductiveautomation.com/t/stored-procedure-transaction-group-postrgresql/92725/2 "2024-07-03T02:21:15Z")

</div>

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.