Re: [Gnumed-bugs] Fixup Server failed

[Karsten Hilbert]

On Mon, Sep 02, 2019 at 10:30:59PM +0200, slappinjohn wrote:

>  pk_audit | row_version |         modified_when         | modified_by | 
> pk   |                  user_action                 
> ----------+-------------+-------------------------------+-------------+-------+-----------------------------------------------
>    593079 |           0 | 2019-07-23 06:26:59.141724+00 | maan        |
> 67314 | EMR access: pulling chart for identity [9672]
> (1 Zeile)

I had outsmarted myself: the old index still exists, and
points to one of the rows (this one) with the pk of 67314.

However, we need both, so we need to switch off the index for
that query.


        set enable_indexonlyscan to off;
        set enable_indexscan to off;
        SELECT * FROM gm.access_log WHERE pk = 67314;

This should return both rows.

Karsten
--
GPG  40BE 5B0E C98E 1713 AFA6  5BC0 3BEA AC80 7D4F C89B