[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: |
Thu, 5 Sep 2019 16:19:41 +0200 |
AFAICT it should be solved now, apart from the loss of
one access log row (which is amply documented in this
email exchange now, however :-)
Karsten
> Gesendet: Donnerstag, 05. September 2019 um 15:58 Uhr
> Von: address@hidden
> An: "Karsten Hilbert" <address@hidden>
> Cc: address@hidden
> Betreff: Re: [Gnumed-bugs] Fixup Server failed
>
> Column | Type | Collation | Nullable
> | Default | Storage |
> Stats target | Description
> ---------------+--------------------------+-----------+----------+------------------------------------------------------+----------+--------------+-------------
> pk_audit | integer | | not null |
> nextval('audit.audit_fields_pk_audit_seq'::regclass) | plain
> | |
> row_version | integer | | not null |
> 0 | plain
> | |
> modified_when | timestamp with time zone | | not null |
> now() | plain
> | |
> modified_by | name | | not null |
> "current_user"() | plain
> | |
> pk | integer | | not null |
> nextval('gm.access_log_pk_seq'::regclass) | plain
> | |
> user_action | text | | not null
> | | extended
> | |
> Indexes:
> "access_log_pkey" PRIMARY KEY, btree (pk)
> Check constraints:
> "audit_audit_fields_sane_modified_when" CHECK ((modified_when <=
> clock_timestamp()) IS TRUE)
> "non_empty_user_action" CHECK
> (gm.is_null_or_blank_string(user_action) IS FALSE)
> Triggers:
> zt_del_access_log BEFORE DELETE ON gm.access_log FOR EACH ROW
> EXECUTE PROCEDURE audit.ft_del_access_log()
> zt_ins_access_log BEFORE INSERT ON gm.access_log FOR EACH ROW
> EXECUTE PROCEDURE audit.ft_ins_access_log()
> zt_upd_access_log BEFORE UPDATE ON gm.access_log FOR EACH ROW
> EXECUTE PROCEDURE audit.ft_upd_access_log()
> Inherits: audit.audit_fields
>
> Am 05.09.19 um 15:12 schrieb Karsten Hilbert:
> > SET default_transaction_read_only to off;
> > BEGIN;
> > ALTER TABLE gm.access_log ADD PRIMARY KEY (pk);
> > \d gm.access_log
> > ROLLBACK;
>
- Re: [Gnumed-bugs] Fixup Server failed, (continued)
- 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, 2019/09/04
- 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 <=
- Re: [Gnumed-bugs] Fixup Server failed, Karsten Hilbert, 2019/09/06
- Re: [Gnumed-bugs] Fixup Server failed, slappinjohn, 2019/09/11