--mysql create trigger dump
create database test_dump dbcompatibility='B';
\c test_dump
create user sys_dump with sysadmin password 'Aa@12356';
create database test1_dump with dbcompatibility='B';
\c test1_dump
create user sys1_dump with sysadmin password 'Aa@12356';
create database test2_dump with dbcompatibility='B';
\c test2_dump
create user sys2_dump with sysadmin password 'Aa@12356';
\c test_dump
create table old_dump(id int,c1 int);
create table tab_dump(id int,c1 int);
create user use_dump password 'Aa@12356';
grant insert,update,select,delete on table old_dump to use_dump;
grant insert,update,select,delete on table tab_dump to use_dump;
create definer=use_dump trigger if not exists tri_dump
before insert on old_dump
for each row
begin
    insert into tab_dump values(new.id,new.c1);
end;
/
--insert
insert into old_dump values(1,1);
select * from old_dump;
 id | c1 
----+----
  1 |  1
(1 row)

select * from tab_dump;
 id | c1 
----+----
  1 |  1
(1 row)

\! @abs_bindir@/gs_dump test_dump -p @portstring@ -U sys_dump -W Aa@12356 -F p -f @abs_bindir@/trigger_dump.sql >/dev/null 2>&1
\! @abs_bindir@/gs_dump test_dump -p @portstring@ -U sys_dump -W Aa@12356 -F c -f @abs_bindir@/trigger_dump.dmp >/dev/null 2>&1
\! @abs_bindir@/gs_restore -U sys1_dump -W Aa@12356 -p @portstring@ @abs_bindir@/trigger_dump.dmp -d test1_dump >/dev/null 2>&1
\! @abs_bindir@/gsql -d test2_dump -p @portstring@ -f @abs_bindir@/trigger_dump.sql >/dev/null 2>&1
\c test1_dump
--insert
insert into old_dump values(2,2);
select * from old_dump;
 id | c1 
----+----
  1 |  1
  2 |  2
(2 rows)

select * from tab_dump;
 id | c1 
----+----
  1 |  1
  2 |  2
(2 rows)

revoke insert on table tab_dump from use_dump;
insert into old_dump values(2,2);
ERROR:  permission denied for relation tab_dump
DETAIL:  N/A
CONTEXT:  SQL statement "insert into tab_dump values(new.id,new.c1)"
PL/pgSQL function tri_dump_old_dump_inlinefunc_1() line 2 at SQL statement
\c test2_dump
--insert
insert into old_dump values(2,2);
select * from old_dump;
 id | c1 
----+----
  1 |  1
  2 |  2
(2 rows)

select * from tab_dump;
 id | c1 
----+----
  1 |  1
  2 |  2
(2 rows)

revoke insert on table tab_dump from use_dump;
insert into old_dump values(2,2);
ERROR:  permission denied for relation tab_dump
DETAIL:  N/A
CONTEXT:  SQL statement "insert into tab_dump values(new.id,new.c1)"
PL/pgSQL function tri_dump_old_dump_inlinefunc_1() line 2 at SQL statement
\c regression
drop database test_dump;
drop database test1_dump;
drop database test2_dump;
drop role sys_dump;
drop role sys1_dump;
drop role sys2_dump;
drop role use_dump;