# Generate table to database with PostgreSQL does not generate data

**URL:** <https://forum.inductiveautomation.com/t/generate-table-to-database-with-postgresql-does-not-generate-data/71750>\
**Category:** Ignition\
**Tags:** scripting, database, ignition80\
**Created:** [March 29, 2023, 1:09am UTC](https://forum.inductiveautomation.com/t/generate-table-to-database-with-postgresql-does-not-generate-data/71750 "2023-03-29T01:09:51Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Julio\_Cesar\_Aguilar](https://avatars.discourse-cdn.com/v4/letter/j/77aa72/32.png) [@Julio\_Cesar\_Aguilar](https://forum.inductiveautomation.com/u/Julio_Cesar_Aguilar)\
**Post date:** [March 29, 2023, 1:09am UTC](https://forum.inductiveautomation.com/t/generate-table-to-database-with-postgresql-does-not-generate-data/71750/1 "2023-03-29T01:09:51Z")

</div>

Hello everyone, I have this problem, I am working with PostgresSQL, it is supposed that through the tranciscion group I generate data and create a table within the database but I stop generating data at a certain point, by deleting and recreating the table within the database no longer performs any writes  
I activate the trigger of the transition group  
generate data  
I use a button to generate the table  
it is supposed to display data  
any idea what to do?

 ![1](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/a/2ab48908534ba309ea6c31250b44bb9d09df7892.png)  
 ![2](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/b/6b1e75861aecc6aea54e7fc6120b15a963e8735e.png)  
 ![3](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/a/9a45121ad7ae44257d2179768e01bce6551ed1e7.png)  
 ![4](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/c/3c85c47aa6cde139054a51081ad85508787cc691.png)

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [March 29, 2023, 9:52am UTC](https://forum.inductiveautomation.com/t/generate-table-to-database-with-postgresql-does-not-generate-data/71750/2 "2023-03-29T09:52:27Z")

</div>

To be clear, when does the transaction group stop working? I see two errors in your setup, which will prevent the group from working.

---

<div class="post-metadata">

**Author:** ![Julio\_Cesar\_Aguilar](https://avatars.discourse-cdn.com/v4/letter/j/77aa72/32.png) [@Julio\_Cesar\_Aguilar](https://forum.inductiveautomation.com/u/Julio_Cesar_Aguilar)\
**Post date:** [March 29, 2023, 3:23pm UTC](https://forum.inductiveautomation.com/t/generate-table-to-database-with-postgresql-does-not-generate-data/71750/3 "2023-03-29T15:23:20Z")

</div>

I activate the trigger to collect data  
and after that I press the button to create the table in the DB,  
The table is created but it is empty.

What are the problems you have detected?  
thanks for comment!!!

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [March 29, 2023, 4:21pm UTC](https://forum.inductiveautomation.com/t/generate-table-to-database-with-postgresql-does-not-generate-data/71750/4 "2023-03-29T16:21:10Z")

</div>

> [@Julio\_Cesar\_Aguilar](#):
>
> What are the problems you have detected?

Right there in your screenshot: "Error\_Configuration" and an "Error\_ExpressionEval..."