Re: [Gnumed-bugs] Fixup Server failed

[slappinjohn]

    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;