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

Commita19ea9c

Browse files
committed
Revert "Add a test for transition table usage in FOR EACH ROW trigger."
This reverts commit4a03f93.
1 parent4a03f93 commita19ea9c

File tree

3 files changed

+0
-53
lines changed

3 files changed

+0
-53
lines changed

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

Lines changed: 0 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -191,7 +191,6 @@ timestamp_tbl|f
191191
timestamptz_tbl|f
192192
timetz_tbl|f
193193
tinterval_tbl|f
194-
transition_table_for_rows|f
195194
varchar_tbl|f
196195
-- restore normal output mode
197196
\a\t

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

Lines changed: 0 additions & 27 deletions
Original file line numberDiff line numberDiff line change
@@ -1893,30 +1893,3 @@ copy parted_stmt_trig1(a) from stdin;
18931893
NOTICE: trigger on parted_stmt_trig1 BEFORE INSERT for ROW
18941894
NOTICE: trigger on parted_stmt_trig1 AFTER INSERT for ROW
18951895
drop table parted_stmt_trig, parted2_stmt_trig;
1896-
--
1897-
-- Verify that transition table in FOR EACH ROW trigge shows all rows affected
1898-
-- by the statement (through the end) for each row (from the beginning).
1899-
--
1900-
create table transition_table_for_rows (c int not null);
1901-
create function transition_table_for_rows_func()
1902-
returns trigger
1903-
language plpgsql
1904-
as $$
1905-
begin
1906-
raise notice '% / % = %',
1907-
new.c,
1908-
(select sum(c) from newtable),
1909-
(select new.c::float / sum(newtable.c) from newtable);
1910-
return null;
1911-
end;
1912-
$$;
1913-
create trigger transition_table_for_rows_trig
1914-
after insert or update on transition_table_for_rows
1915-
referencing new table as newtable
1916-
for each row
1917-
execute procedure transition_table_for_rows_func();
1918-
insert into transition_table_for_rows select generate_series(1,4);
1919-
NOTICE: 1 / 10 = 0.1
1920-
NOTICE: 2 / 10 = 0.2
1921-
NOTICE: 3 / 10 = 0.3
1922-
NOTICE: 4 / 10 = 0.4

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

Lines changed: 0 additions & 25 deletions
Original file line numberDiff line numberDiff line change
@@ -1360,28 +1360,3 @@ copy parted_stmt_trig1(a) from stdin;
13601360
\.
13611361

13621362
droptable parted_stmt_trig, parted2_stmt_trig;
1363-
1364-
--
1365-
-- Verify that transition table in FOR EACH ROW trigger shows all rows
1366-
-- affected by the statement (through the end) for each row (from the
1367-
-- beginning).
1368-
--
1369-
createtabletransition_table_for_rows (cintnot null);
1370-
createfunctiontransition_table_for_rows_func()
1371-
returns trigger
1372-
language plpgsql
1373-
as $$
1374-
begin
1375-
raise notice'% / % = %',
1376-
new.c,
1377-
(selectsum(c)from newtable),
1378-
(selectnew.c::float/sum(newtable.c)from newtable);
1379-
returnnull;
1380-
end;
1381-
$$;
1382-
createtriggertransition_table_for_rows_trig
1383-
after insertorupdateon transition_table_for_rows
1384-
referencing new tableas newtable
1385-
for each row
1386-
execute procedure transition_table_for_rows_func();
1387-
insert into transition_table_for_rowsselect generate_series(1,4);

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp