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

Commit4909357

Browse files
committed
Remove unnecessary ABORT commands in dblink regression tests.
1 parent768dfd0 commit4909357

File tree

2 files changed

+0
-40
lines changed

2 files changed

+0
-40
lines changed

‎contrib/dblink/expected/dblink.out‎

Lines changed: 0 additions & 28 deletions
Original file line numberDiff line numberDiff line change
@@ -223,13 +223,6 @@ DETAIL: ERROR: cursor "rmt_foobar_cursor" does not exist
223223
ERROR
224224
(1 row)
225225

226-
-- reset remote transaction state
227-
SELECT dblink_exec('ABORT');
228-
dblink_exec
229-
-------------
230-
ROLLBACK
231-
(1 row)
232-
233226
-- should generate 'cursor "rmt_foo_cursor" not found' error
234227
SELECT *
235228
FROM dblink_fetch('rmt_foo_cursor',4) AS t(a int, b text, c text[]);
@@ -310,13 +303,6 @@ DETAIL: ERROR: relation "foobar" does not exist
310303
---+---+---
311304
(0 rows)
312305

313-
-- reset remote transaction state
314-
SELECT dblink_exec('ABORT');
315-
dblink_exec
316-
-------------
317-
ROLLBACK
318-
(1 row)
319-
320306
-- change some data
321307
SELECT dblink_exec('UPDATE foo SET f3[2] = ''b99'' WHERE f1 = 11');
322308
dblink_exec
@@ -343,13 +329,6 @@ DETAIL: ERROR: relation "foobar" does not exist
343329
ERROR
344330
(1 row)
345331

346-
-- reset remote transaction state
347-
SELECT dblink_exec('ABORT');
348-
dblink_exec
349-
-------------
350-
ROLLBACK
351-
(1 row)
352-
353332
-- delete some data
354333
SELECT dblink_exec('DELETE FROM foo WHERE f1 = 11');
355334
dblink_exec
@@ -411,13 +390,6 @@ DETAIL: ERROR: relation "foobar" does not exist
411390
---+---+---
412391
(0 rows)
413392

414-
-- reset remote transaction state
415-
SELECT dblink_exec('myconn','ABORT');
416-
dblink_exec
417-
-------------
418-
ROLLBACK
419-
(1 row)
420-
421393
-- create a second named persistent connection
422394
-- should error with "duplicate connection name"
423395
SELECT dblink_connect('myconn','dbname=contrib_regression');

‎contrib/dblink/sql/dblink.sql‎

Lines changed: 0 additions & 12 deletions
Original file line numberDiff line numberDiff line change
@@ -117,9 +117,6 @@ SELECT dblink_exec('ABORT');
117117
-- close the wrong cursor
118118
SELECT dblink_close('rmt_foobar_cursor',false);
119119

120-
-- reset remote transaction state
121-
SELECT dblink_exec('ABORT');
122-
123120
-- should generate 'cursor "rmt_foo_cursor" not found' error
124121
SELECT*
125122
FROM dblink_fetch('rmt_foo_cursor',4)AS t(aint, btext, ctext[]);
@@ -155,9 +152,6 @@ FROM dblink('SELECT * FROM foo') AS t(a int, b text, c text[]);
155152
SELECT*
156153
FROM dblink('SELECT * FROM foobar',false)AS t(aint, btext, ctext[]);
157154

158-
-- reset remote transaction state
159-
SELECT dblink_exec('ABORT');
160-
161155
-- change some data
162156
SELECT dblink_exec('UPDATE foo SET f3[2] =''b99'' WHERE f1 = 11');
163157

@@ -169,9 +163,6 @@ WHERE a = 11;
169163
-- botch a change to some other data
170164
SELECT dblink_exec('UPDATE foobar SET f3[2] =''b99'' WHERE f1 = 11',false);
171165

172-
-- reset remote transaction state
173-
SELECT dblink_exec('ABORT');
174-
175166
-- delete some data
176167
SELECT dblink_exec('DELETE FROM foo WHERE f1 = 11');
177168

@@ -205,9 +196,6 @@ SELECT *
205196
FROM dblink('myconn','SELECT * FROM foobar',false)AS t(aint, btext, ctext[])
206197
WHEREt.a>7;
207198

208-
-- reset remote transaction state
209-
SELECT dblink_exec('myconn','ABORT');
210-
211199
-- create a second named persistent connection
212200
-- should error with "duplicate connection name"
213201
SELECT dblink_connect('myconn','dbname=contrib_regression');

0 commit comments

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