Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitcef6004

Browse files
committed
Mention trigger name in trigger test
This makes it more explicit exactly what is going on, for furtherproposed behavior changes.Discussion:https://postgr.es/m/20180214212624.hm7of76flesodamf@alvherre.pgsql
1 parentad7dbee commitcef6004

File tree

2 files changed

+22
-22
lines changed

2 files changed

+22
-22
lines changed

‎src/test/regress/expected/triggers.out

Lines changed: 21 additions & 21 deletions
Original file line numberDiff line numberDiff line change
@@ -1865,7 +1865,7 @@ create table parted2_stmt_trig1 partition of parted2_stmt_trig for values in (1)
18651865
create table parted2_stmt_trig2 partition of parted2_stmt_trig for values in (2);
18661866
create or replace function trigger_notice() returns trigger as $$
18671867
begin
1868-
raise notice 'trigger on % % % for %', TG_TABLE_NAME, TG_WHEN, TG_OP, TG_LEVEL;
1868+
raise notice 'trigger%on % % % for %', TG_NAME, TG_TABLE_NAME, TG_WHEN, TG_OP, TG_LEVEL;
18691869
if TG_LEVEL = 'ROW' then
18701870
return NEW;
18711871
end if;
@@ -1910,12 +1910,12 @@ create trigger trig_del_after after delete on parted2_stmt_trig
19101910
with ins (a) as (
19111911
insert into parted2_stmt_trig values (1), (2) returning a
19121912
) insert into parted_stmt_trig select a from ins returning tableoid::regclass, a;
1913-
NOTICE: trigger on parted_stmt_trig BEFORE INSERT for STATEMENT
1914-
NOTICE: trigger on parted2_stmt_trig BEFORE INSERT for STATEMENT
1915-
NOTICE: trigger on parted_stmt_trig1 BEFORE INSERT for ROW
1916-
NOTICE: trigger on parted_stmt_trig1 AFTER INSERT for ROW
1917-
NOTICE: trigger on parted2_stmt_trig AFTER INSERT for STATEMENT
1918-
NOTICE: trigger on parted_stmt_trig AFTER INSERT for STATEMENT
1913+
NOTICE: triggertrig_ins_beforeon parted_stmt_trig BEFORE INSERT for STATEMENT
1914+
NOTICE: triggertrig_ins_beforeon parted2_stmt_trig BEFORE INSERT for STATEMENT
1915+
NOTICE: triggertrig_ins_beforeon parted_stmt_trig1 BEFORE INSERT for ROW
1916+
NOTICE: triggertrig_ins_afteron parted_stmt_trig1 AFTER INSERT for ROW
1917+
NOTICE: triggertrig_ins_afteron parted2_stmt_trig AFTER INSERT for STATEMENT
1918+
NOTICE: triggertrig_ins_afteron parted_stmt_trig AFTER INSERT for STATEMENT
19191919
tableoid | a
19201920
-------------------+---
19211921
parted_stmt_trig1 | 1
@@ -1925,25 +1925,25 @@ NOTICE: trigger on parted_stmt_trig AFTER INSERT for STATEMENT
19251925
with upd as (
19261926
update parted2_stmt_trig set a = a
19271927
) update parted_stmt_trig set a = a;
1928-
NOTICE: trigger on parted_stmt_trig BEFORE UPDATE for STATEMENT
1929-
NOTICE: trigger on parted_stmt_trig1 BEFORE UPDATE for ROW
1930-
NOTICE: trigger on parted2_stmt_trig BEFORE UPDATE for STATEMENT
1931-
NOTICE: trigger on parted_stmt_trig1 AFTER UPDATE for ROW
1932-
NOTICE: trigger on parted_stmt_trig AFTER UPDATE for STATEMENT
1933-
NOTICE: trigger on parted2_stmt_trig AFTER UPDATE for STATEMENT
1928+
NOTICE: triggertrig_upd_beforeon parted_stmt_trig BEFORE UPDATE for STATEMENT
1929+
NOTICE: triggertrig_upd_beforeon parted_stmt_trig1 BEFORE UPDATE for ROW
1930+
NOTICE: triggertrig_upd_beforeon parted2_stmt_trig BEFORE UPDATE for STATEMENT
1931+
NOTICE: triggertrig_upd_afteron parted_stmt_trig1 AFTER UPDATE for ROW
1932+
NOTICE: triggertrig_upd_afteron parted_stmt_trig AFTER UPDATE for STATEMENT
1933+
NOTICE: triggertrig_upd_afteron parted2_stmt_trig AFTER UPDATE for STATEMENT
19341934
delete from parted_stmt_trig;
1935-
NOTICE: trigger on parted_stmt_trig BEFORE DELETE for STATEMENT
1936-
NOTICE: trigger on parted_stmt_trig AFTER DELETE for STATEMENT
1935+
NOTICE: triggertrig_del_beforeon parted_stmt_trig BEFORE DELETE for STATEMENT
1936+
NOTICE: triggertrig_del_afteron parted_stmt_trig AFTER DELETE for STATEMENT
19371937
-- insert via copy on the parent
19381938
copy parted_stmt_trig(a) from stdin;
1939-
NOTICE: trigger on parted_stmt_trig BEFORE INSERT for STATEMENT
1940-
NOTICE: trigger on parted_stmt_trig1 BEFORE INSERT for ROW
1941-
NOTICE: trigger on parted_stmt_trig1 AFTER INSERT for ROW
1942-
NOTICE: trigger on parted_stmt_trig AFTER INSERT for STATEMENT
1939+
NOTICE: triggertrig_ins_beforeon parted_stmt_trig BEFORE INSERT for STATEMENT
1940+
NOTICE: triggertrig_ins_beforeon parted_stmt_trig1 BEFORE INSERT for ROW
1941+
NOTICE: triggertrig_ins_afteron parted_stmt_trig1 AFTER INSERT for ROW
1942+
NOTICE: triggertrig_ins_afteron parted_stmt_trig AFTER INSERT for STATEMENT
19431943
-- insert via copy on the first partition
19441944
copy parted_stmt_trig1(a) from stdin;
1945-
NOTICE: trigger on parted_stmt_trig1 BEFORE INSERT for ROW
1946-
NOTICE: trigger on parted_stmt_trig1 AFTER INSERT for ROW
1945+
NOTICE: triggertrig_ins_beforeon parted_stmt_trig1 BEFORE INSERT for ROW
1946+
NOTICE: triggertrig_ins_afteron parted_stmt_trig1 AFTER INSERT for ROW
19471947
drop table parted_stmt_trig, parted2_stmt_trig;
19481948
--
19491949
-- Test the interaction between transition tables and both kinds of

‎src/test/regress/sql/triggers.sql

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1317,7 +1317,7 @@ create table parted2_stmt_trig2 partition of parted2_stmt_trig for values in (2)
13171317

13181318
create or replacefunctiontrigger_notice() returns triggeras $$
13191319
begin
1320-
raise notice'trigger on % % % for %', TG_TABLE_NAME, TG_WHEN, TG_OP, TG_LEVEL;
1320+
raise notice'trigger%on % % % for %', TG_NAME, TG_TABLE_NAME, TG_WHEN, TG_OP, TG_LEVEL;
13211321
if TG_LEVEL='ROW' then
13221322
return NEW;
13231323
end if;

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp