# \[IGN-9717\] SECS/GEM module creates PostgreSQL schema it cannot itself work with **URL:** \ **Category:** General Discussion\ **Created:** [August 4, 2026, 6:22am UTC](https://forum.inductiveautomation.com/t/ign-9717-secs-gem-module-creates-postgresql-schema-it-cannot-itself-work-with/116643 "2026-08-04T06:22:37Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![vasily.kabanov](https://avatars.discourse-cdn.com/v4/letter/v/90db22/32.png) [@vasily.kabanov](https://forum.inductiveautomation.com/u/vasily.kabanov)\ **Post date:** [August 4, 2026, 6:22am UTC](https://forum.inductiveautomation.com/t/ign-9717-secs-gem-module-creates-postgresql-schema-it-cannot-itself-work-with/116643/1 "2026-08-04T06:22:37Z")
Ignition 8.3.8 SECS/GEM module 5.3.8 PostgreSQL 17.10, freshly installed on the same Debian host purely for Ignition. Fresh installation, not an upgrade/update. SECS/GEM module creates tables with column names in UPPERCASE, apparently quoting them. Then immediately when querying those tables it uses column names without quoting, generating jdbc errors like ```python java.sql.SQLException: Could not insert/update or query SECSGEM_EquipmentInfo database table for this Equipment Connection. at com.inductiveautomation.secsgem.EquipmentConnectionDBTablesSetup.setupDatabaseTables(EquipmentConnectionDBTablesSetup.java:103) at com.inductiveautomation.secsgem.equipment.EquipmentConnection.initialize(EquipmentConnection.java:355) at com.inductiveautomation.secsgem.equipment.EquipmentConnection$1.mainLoop(EquipmentConnection.java:117) at com.inductiveautomation.secsgem.equipment.EquipmentConnection$1.run(EquipmentConnection.java:101) at java.base/java.lang.Thread.run(Unknown Source) Caused by: org.postgresql.util.PSQLException: ERROR: column "prefix" does not exist Position: 8 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2725) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2412) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:371) ``` Is there a place to report bugs? I have not found one. ---
**Author:** ![andrew.budaiev](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/andrew.budaiev/32/72921_2.png) [@andrew.budaiev](https://forum.inductiveautomation.com/u/andrew.budaiev)\ **Post date:** [August 4, 2026, 6:58am UTC](https://forum.inductiveautomation.com/t/ign-9717-secs-gem-module-creates-postgresql-schema-it-cannot-itself-work-with/116643/2 "2026-08-04T06:58:07Z")
> [@vasily.kabanov](#): > > Is there a place to report bugs? I have not found one. You can submit a ticket here. [https://support.inductiveautomation.com/hc/en-us](https://support.inductiveautomation.com/hc/en-us) ---
**Author:** ![vasily.kabanov](https://avatars.discourse-cdn.com/v4/letter/v/90db22/32.png) [@vasily.kabanov](https://forum.inductiveautomation.com/u/vasily.kabanov)\ **Post date:** [August 4, 2026, 7:05am UTC](https://forum.inductiveautomation.com/t/ign-9717-secs-gem-module-creates-postgresql-schema-it-cannot-itself-work-with/116643/3 "2026-08-04T07:05:05Z")
Created [https://support.inductiveautomation.com/hc/en-us/requests/194908](https://support.inductiveautomation.com/hc/en-us/requests/194908) No bug reporting there, just "requests". Thanks Andrew ---
**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:** [August 4, 2026, 11:06am UTC](https://forum.inductiveautomation.com/t/ign-9717-secs-gem-module-creates-postgresql-schema-it-cannot-itself-work-with/116643/4 "2026-08-04T11:06:29Z")
> [@vasily.kabanov](#): > > No bug reporting there, just "requests". "Requests" include bug reports. This forum is not official support, and relies on a few IA employees eyeballs. The support site is full time IA staffed. ---
**Author:** ![imt.sebastian.sanche](https://avatars.discourse-cdn.com/v4/letter/i/ecb155/32.png) [@imt.sebastian.sanche](https://forum.inductiveautomation.com/u/imt.sebastian.sanche)\ **Post date:** [September 17, 2026, 9:45pm UTC](https://forum.inductiveautomation.com/t/ign-9717-secs-gem-module-creates-postgresql-schema-it-cannot-itself-work-with/116643/5 "2026-09-17T21:45:55Z")
Did you got any response from IA? I have the same issue. ---
**Author:** ![vasily.kabanov](https://avatars.discourse-cdn.com/v4/letter/v/90db22/32.png) [@vasily.kabanov](https://forum.inductiveautomation.com/u/vasily.kabanov)\ **Post date:** [September 18, 2026, 1:01am UTC](https://forum.inductiveautomation.com/t/ign-9717-secs-gem-module-creates-postgresql-schema-it-cannot-itself-work-with/116643/6 "2026-09-18T01:01:35Z")
I did, the issue had been already reported some time ago, but had not been fixed since. ---
**Author:** ![osolorzano](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/osolorzano/32/6432_2.png) [@osolorzano](https://forum.inductiveautomation.com/u/osolorzano)\ **Post date:** [September 18, 2026, 11:32pm UTC](https://forum.inductiveautomation.com/t/ign-9717-secs-gem-module-creates-postgresql-schema-it-cannot-itself-work-with/116643/7 "2026-09-18T23:32:36Z")
I dug up the issue from our internal tracking and saw that you can work around it by adding a Database Table Prefix when making the equipment connection.