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

Commit3f0f991

Browse files
committed
Remove master/slave usage from plpgsql tests
Author: Dagfinn Ilmari Mannsåker <ilmari@ilmari.org>Discussion:https://www.postgresql.org/message-id/flat/E393EC88-377F-4C59-A67A-69F2A38D17C7@yesql.se
1 parentdb1f289 commit3f0f991

File tree

2 files changed

+18
-18
lines changed

2 files changed

+18
-18
lines changed

‎src/pl/plpgsql/src/expected/plpgsql_trap.out

Lines changed: 12 additions & 12 deletions
Original file line numberDiff line numberDiff line change
@@ -186,17 +186,17 @@ NOTICE: should see this only if -100 fits in smallint
186186
--
187187
-- test foreign key error trapping
188188
--
189-
create temp tablemaster(f1 int primary key);
190-
create temp tableslave(f1 int referencesmaster deferrable);
191-
insert intomaster values(1);
192-
insert intoslave values(1);
193-
insert intoslave values(2);-- fails
194-
ERROR: insert or update on table "slave" violates foreign key constraint "slave_f1_fkey"
195-
DETAIL: Key (f1)=(2) is not present in table "master".
189+
create temp tableroot(f1 int primary key);
190+
create temp tableleaf(f1 int referencesroot deferrable);
191+
insert intoroot values(1);
192+
insert intoleaf values(1);
193+
insert intoleaf values(2);-- fails
194+
ERROR: insert or update on table "leaf" violates foreign key constraint "leaf_f1_fkey"
195+
DETAIL: Key (f1)=(2) is not present in table "root".
196196
create function trap_foreign_key(int) returns int as $$
197197
begin
198198
begin-- start a subtransaction
199-
insert intoslave values($1);
199+
insert intoleaf values($1);
200200
exception
201201
when foreign_key_violation then
202202
raise notice 'caught foreign_key_violation';
@@ -238,8 +238,8 @@ begin;
238238

239239
savepoint x;
240240
set constraints all immediate; -- fails
241-
ERROR: insert or update on table "slave" violates foreign key constraint "slave_f1_fkey"
242-
DETAIL: Key (f1)=(2) is not present in table "master".
241+
ERROR: insert or update on table "leaf" violates foreign key constraint "leaf_f1_fkey"
242+
DETAIL: Key (f1)=(2) is not present in table "root".
243243
rollback to x;
244244
select trap_foreign_key_2(); -- detects FK violation
245245
NOTICE: caught foreign_key_violation
@@ -249,7 +249,7 @@ NOTICE: caught foreign_key_violation
249249
(1 row)
250250

251251
commit;-- still fails
252-
ERROR: insert or update on table "slave" violates foreign key constraint "slave_f1_fkey"
253-
DETAIL: Key (f1)=(2) is not present in table "master".
252+
ERROR: insert or update on table "leaf" violates foreign key constraint "leaf_f1_fkey"
253+
DETAIL: Key (f1)=(2) is not present in table "root".
254254
drop function trap_foreign_key(int);
255255
drop function trap_foreign_key_2();

‎src/pl/plpgsql/src/sql/plpgsql_trap.sql

Lines changed: 6 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -127,18 +127,18 @@ select test_variable_storage();
127127
-- test foreign key error trapping
128128
--
129129

130-
create temp tablemaster(f1intprimary key);
130+
create temp tableroot(f1intprimary key);
131131

132-
create temp tableslave(f1intreferencesmaster deferrable);
132+
create temp tableleaf(f1intreferencesroot deferrable);
133133

134-
insert intomastervalues(1);
135-
insert intoslavevalues(1);
136-
insert intoslavevalues(2);-- fails
134+
insert intorootvalues(1);
135+
insert intoleafvalues(1);
136+
insert intoleafvalues(2);-- fails
137137

138138
createfunctiontrap_foreign_key(int) returnsintas $$
139139
begin
140140
begin-- start a subtransaction
141-
insert intoslavevalues($1);
141+
insert intoleafvalues($1);
142142
exception
143143
when foreign_key_violation then
144144
raise notice'caught foreign_key_violation';

0 commit comments

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