[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-bugs] Fixup Server failed
From: |
Karsten Hilbert |
Subject: |
Re: [Gnumed-bugs] Fixup Server failed |
Date: |
Wed, 4 Sep 2019 22:54:13 +0200 |
User-agent: |
Mutt/1.10.1 (2018-07-13) |
On Wed, Sep 04, 2019 at 12:22:43PM +0200, address@hidden wrote:
> pk_audit | row_version | modified_when | modified_by |
> pk | user_action
> ----------+-------------+-------------------------------+-------------+-------+-----------------------------------------------
> 593072 | 0 | 2019-07-23 06:08:28.608499+00 | maan |
> 67314 | EMR access: pulling chart for identity [9670]
> 593079 | 0 | 2019-07-23 06:26:59.141724+00 | maan |
> 67314 | EMR access: pulling chart for identity [9672]
> (2 rows)
One might simply delete one of the rows:
SET default_transaction_read_only to off;
BEGIN;
SELECT * FROM gm.access_log WHERE pk = 67314;
DELETE FROM gm.access_log WHERE pk_audit = 593079;
REINDEX TABLE gm.access_log;
ROLLBACK;
Karsten
--
GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B
- [Gnumed-bugs] Fixup Server failed, slappinjohn, 2019/09/02
- Re: [Gnumed-bugs] Fixup Server failed, Karsten Hilbert, 2019/09/02
- Re: [Gnumed-bugs] Fixup Server failed, slappinjohn, 2019/09/02
- Re: [Gnumed-bugs] Fixup Server failed, Karsten Hilbert, 2019/09/02
- Re: [Gnumed-bugs] Fixup Server failed, slappinjohn, 2019/09/03
- Re: [Gnumed-bugs] Fixup Server failed, Karsten Hilbert, 2019/09/03
- Re: [Gnumed-bugs] Fixup Server failed, slappinjohn, 2019/09/03
- Re: [Gnumed-bugs] Fixup Server failed, Karsten Hilbert, 2019/09/03
- Re: [Gnumed-bugs] Fixup Server failed, slappinjohn, 2019/09/04
- Message not available
- Re: [Gnumed-bugs] Fixup Server failed, slappinjohn, 2019/09/04
- Re: [Gnumed-bugs] Fixup Server failed,
Karsten Hilbert <=
- Re: [Gnumed-bugs] Fixup Server failed, slappinjohn, 2019/09/05
- Re: [Gnumed-bugs] Fixup Server failed, Karsten Hilbert, 2019/09/05
- Re: [Gnumed-bugs] Fixup Server failed, slappinjohn, 2019/09/05
- Re: [Gnumed-bugs] Fixup Server failed, Karsten Hilbert, 2019/09/05
- Re: [Gnumed-bugs] Fixup Server failed, slappinjohn, 2019/09/05
- Re: [Gnumed-bugs] Fixup Server failed, Karsten Hilbert, 2019/09/05
- Re: [Gnumed-bugs] Fixup Server failed, slappinjohn, 2019/09/05
- Re: [Gnumed-bugs] Fixup Server failed, Karsten Hilbert, 2019/09/05
- Re: [Gnumed-bugs] Fixup Server failed, Karsten Hilbert, 2019/09/06
- Re: [Gnumed-bugs] Fixup Server failed, slappinjohn, 2019/09/11