E-Maj functions list¶
E-Maj functions that are available to users are listed in alphabetic order below. They are all callable by roles having emaj_adm privileges. The chart also specifies those callable by emaj_viewer roles (sign (V) behind the function name).
Functions | Input parameters | Output data |
---|---|---|
emaj_alter_group | group TEXT
|
#.tables.and.seq INT |
emaj_alter_groups | groups.array TEXT[]
|
#.tables.and.seq INT |
emaj_cleanup_rollback_state | #.rollback INT | |
emaj_comment_group | group TEXT,
comment TEXT
|
|
emaj_comment_mark_group | group TEXT,
mark TEXT,
comment TEXT
|
|
emaj_consolidate_rollback_group | group TEXT,
end.rollback.mark TEXT
|
#.tables.and.seq INT |
emaj_create_group | group TEXT,
[is.rollbackable BOOLEAN],
[is.empty BOOLEAN]
|
#.tables.and.seq INT |
emaj_delete_before_mark_group | group TEXT,
mark TEXT
|
#.deleted.marks INT |
emaj_delete_mark_group | group TEXT,
mark TEXT
|
1 INT |
emaj_detailed_log_stat_group (V) | group TEXT,
start.mark TEXT,
end.mark TEXT
|
SETOF emaj_detailed_log_stat_type |
emaj_disable_protection_by_event_triggers | #.triggers INT | |
emaj_drop_group | group TEXT
|
#.tables.and.seq INT |
emaj_enable_protection_by_event_triggers | #.triggers INT | |
emaj_estimate_rollback_group (V) | group TEXT,
mark TEXT
|
duration INTERVAL |
emaj_estimate_rollback_groups (V) | groups.array TEXT[],
mark TEXT
|
duration INTERVAL |
emaj_force_drop_group | group TEXT
|
#.tables.and.seq INT |
emaj_force_stop_group | group TEXT
|
#.tables.and.seq INT |
emaj_gen_sql_group | group TEXT,
start.mark TEXT,
end.mark TEXT,
output.file.path TEXT,
[tables.seq.array TEXT[]]
|
#.gen.statements BIGINT |
emaj_gen_sql_groups | groups.array TEXT[],
start.mark TEXT,
end.mark TEXT,
output.file.path TEXT,
[tables.seq.array TEXT[]]
|
#.gen.statements BIGINT |
emaj_get_consolidable_rollbacks (V) | SETOF emaj_consolidable_rollback_type | |
emaj_get_previous_mark_group (V) | group TEXT,
date.time TIMESTAMPTZ
|
mark TEXT |
emaj_get_previous_mark_group (V) | group TEXT,
mark TEXT
|
mark TEXT |
emaj_log_stat_group (V) | group TEXT,
start.mark TEXT,
end.mark TEXT
|
SETOF emaj_log_stat_type |
emaj_logged_rollback_group | group TEXT,
mark TEXT,
is_alter_group_allowed
BOOLEAN
|
SETOF (severity TEXT, message TEXT) |
emaj_logged_rollback_groups | groups.array TEXT[],
mark TEXT,
is_alter_group_allowed
BOOLEAN
|
SETOF (severity TEXT, message TEXT) |
emaj_protect_group | group TEXT
|
0/1 INT |
emaj_protect_mark_group | group TEXT,
mark TEXT
|
0/1 INT |
emaj_rename_mark_group | group TEXT,
mark TEXT,
new.name TEXT
|
|
emaj_reset_group | group TEXT
|
#.tables.and.seq INT |
emaj_rollback_activity (V) | SETOF emaj_rollback_activity_type | |
emaj_rollback_group | group TEXT,
mark TEXT,
is_alter_group_allowed
BOOLEAN
|
SETOF (severity TEXT, message TEXT) |
emaj_rollback_groups | groups.array TEXT[],
mark TEXT,
is_alter_group_allowed
BOOLEAN
|
SETOF (severity TEXT, message TEXT) |
emaj_set_mark_group | group TEXT,
[mark TEXT]
|
#.tables.and.seq INT |
emaj_set_mark_groups | groups.array TEXT[],
[mark TEXT]
|
#.tables.and.seq INT |
emaj_snap_group | group TEXT,
directory TEXT,
copy.options TEXT
|
#.tables.and.seq INT |
emaj_snap_log_group | group TEXT,
start.mark TEXT,
end.mark TEXT,
directory TEXT,
copy.options TEXT
|
#.tables.and.seq INT |
emaj_start_group | group TEXT,
[mark TEXT],
[reset.log BOOLEAN]
|
#.tables.and.seq INT |
emaj_start_groups | groups.array TEXT[],
[mark TEXT],
[reset.log BOOLEAN]
|
#.tables.and.seq INT |
emaj_stop_group | group TEXT,
[mark TEXT]
|
#.tables.and.seq INT |
emaj_stop_groups | groups.array TEXT[],
[mark TEXT]
|
#.tables.and.seq INT |
emaj_unprotect_group | group TEXT
|
0/1 INT |
emaj_unprotect_mark_group | group TEXT,
mark TEXT
|
0/1 INT |
emaj_verify_all (V) | Setof TEXT |