[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: |
Fri, 6 Sep 2019 16:42:30 +0200 |
User-agent: |
Mutt/1.10.1 (2018-07-13) |
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;
> >
>
--
GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B
- Re: [Gnumed-bugs] Fixup Server failed, (continued)
- 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, 2019/09/05
- Re: [Gnumed-bugs] Fixup Server failed,
Karsten Hilbert <=
- Re: [Gnumed-bugs] Fixup Server failed, slappinjohn, 2019/09/11