[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-bugs] Fixup Server failed
From: |
slappinjohn |
Subject: |
Re: [Gnumed-bugs] Fixup Server failed |
Date: |
Wed, 11 Sep 2019 21:17:45 +0200 |
User-agent: |
Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.8.0 |
did it that way! Thanks
Am 06.09.19 um 16:42 schrieb Karsten Hilbert:
> On Thu, Sep 05, 2019 at 04:19:41PM +0200, Karsten Hilbert wrote:
>
>> AFAICT it should be solved now,
> Wait, the below only shows that
>
>>>> SET default_transaction_read_only to off;
>>>> BEGIN;
>>>> ALTER TABLE gm.access_log ADD PRIMARY KEY (pk);
>>>> \d gm.access_log
>>>> ROLLBACK;
> does what it should.
>
> We now need to re-run it with COMMIT instead of ROLLBACK
> (unless you already did that yourself :-)
> _
> \
> |
> v
>
> SET default_transaction_read_only to off;
> BEGIN;
> \d gm.access_log
> ALTER TABLE gm.access_log ADD PRIMARY KEY (pk);
> \d gm.access_log
> COMMIT;
>
>
> 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, 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, 2019/09/05
- Re: [Gnumed-bugs] Fixup Server failed, Karsten Hilbert, 2019/09/06
- Re: [Gnumed-bugs] Fixup Server failed,
slappinjohn <=