# PostgreSQL issue with Historical Transaction group

**URL:** <https://forum.inductiveautomation.com/t/postgresql-issue-with-historical-transaction-group/12360>\
**Category:** Archived Topics\
**Created:** [November 15, 2016, 5:24am UTC](https://forum.inductiveautomation.com/t/postgresql-issue-with-historical-transaction-group/12360 "2016-11-15T05:24:10Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![0sm0](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/0sm0/32/15228_2.png) [@0sm0](https://forum.inductiveautomation.com/u/0sm0)\
**Post date:** [November 15, 2016, 5:24am UTC](https://forum.inductiveautomation.com/t/postgresql-issue-with-historical-transaction-group/12360/1 "2016-11-15T05:24:10Z")

</div>

Hi Guys,

Thought I would give PostgreSQL a try and found that when I create a Transaction group, all goes smoothly.

However reading the data back into an Easy chart i get and error saying the t\_stamp isn’t indexed when i run the diagnostics on the pen.

Historical Tags work fine.

Running Ignition 7.9, PostgreSQL 9.6 on windows 7

I’m sure i am missing something… ![:scratch:](https://us1.discourse-cdn.com/inductiveautomation/original/1X/76d1620bec252bfac07050c889ff5a91dc8a9c25.gif ":scratch:")

Cheers

Tim…

---

<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:** [November 15, 2016, 12:02pm UTC](https://forum.inductiveautomation.com/t/postgresql-issue-with-historical-transaction-group/12360/2 "2016-11-15T12:02:43Z")

</div>

Huh. That’s a bug worth investigating. To do so, set Postgres to log all queries, then create a new transaction group.  
Meanwhile, just use pgAdmin3 or your favorite professional management interface to index that column.

---

<div class="post-metadata">

**Author:** ![Ivan\_a](https://avatars.discourse-cdn.com/v4/letter/i/9f8e36/32.png) [@Ivan\_a](https://forum.inductiveautomation.com/u/Ivan_a)\
**Post date:** [October 31, 2018, 11:32pm UTC](https://forum.inductiveautomation.com/t/postgresql-issue-with-historical-transaction-group/12360/3 "2018-10-31T23:32:23Z")

</div>

Hi Guys,

I have noticed the same issue. it looks like this issue is still present in 7.9.9

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [October 31, 2018, 11:38pm UTC](https://forum.inductiveautomation.com/t/postgresql-issue-with-historical-transaction-group/12360/4 "2018-10-31T23:38:18Z")

</div>

It looks like this slipped under the radar. I’ve added an internal ticket to look into this and get it fixed.