| -- start_ignore |
| SET SEARCH_PATH=TestPreparedStatement_TestPreparedStatementInsert; |
| SET |
| -- end_ignore |
| -- start_ignore |
| drop function if exists f1(); |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:5: NOTICE: function f1() does not exist, skipping |
| DROP FUNCTION |
| drop function if exists f2(); |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:6: NOTICE: function f2() does not exist, skipping |
| DROP FUNCTION |
| drop table if exists t1; |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:7: NOTICE: table "t1" does not exist, skipping |
| DROP TABLE |
| drop table if exists t2; |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:8: NOTICE: table "t2" does not exist, skipping |
| DROP TABLE |
| -- end_ignore |
| create table t1 (id int); |
| CREATE TABLE |
| insert into t1 values (1); |
| INSERT 0 1 |
| create table t2 (id int); |
| CREATE TABLE |
| CREATE OR REPLACE FUNCTION f1() |
| RETURNS text |
| LANGUAGE plpgsql |
| AS |
| $body$ |
| DECLARE |
| l_rec record; |
| l_item record; |
| l_count integer; |
| BEGIN |
| |
| RAISE NOTICE '--- Initial content of t1: begin ---'; |
| SELECT count(*) INTO l_count FROM t1; |
| RAISE NOTICE '--- # tuple: %', l_count; |
| RAISE NOTICE 'id'; |
| FOR l_item IN SELECT * FROM t1 LOOP |
| RAISE NOTICE '%', quote_ident(l_item.id); |
| END LOOP; |
| RAISE NOTICE '--- Initial content of t1: end ---'; |
| |
| FOR l_rec IN ( SELECT generate_series(1, 3) AS idx ) |
| LOOP |
| INSERT INTO t1 SELECT * FROM t1; |
| |
| RAISE NOTICE '--- Content of t1 after %d insert in loop: begin ---', l_rec.idx; |
| SELECT count(*) INTO l_count FROM t1; |
| RAISE NOTICE '--- # tuple: %', l_count; |
| RAISE NOTICE 'id'; |
| FOR l_item IN SELECT * FROM t1 LOOP |
| RAISE NOTICE '%', quote_ident(l_item.id); |
| END LOOP; |
| RAISE NOTICE '--- Content of t1 after %d insert in loop: end ---', l_rec.idx; |
| END LOOP; |
| |
| RAISE NOTICE '--- Final content of t1: begin ---'; |
| SELECT count(*) INTO l_count FROM t1; |
| RAISE NOTICE '--- # tuple: %', l_count; |
| RAISE NOTICE 'id'; |
| FOR l_item IN SELECT * FROM t1 LOOP |
| RAISE NOTICE '%', quote_ident(l_item.id); |
| END LOOP; |
| RAISE NOTICE '--- Final content of t1: end ---'; |
| |
| RETURN 'done'; |
| END |
| $body$ |
| ; |
| CREATE FUNCTION |
| CREATE OR REPLACE FUNCTION f2() |
| RETURNS text |
| LANGUAGE plpgsql |
| AS |
| $body$ |
| DECLARE |
| l_rec record; |
| l_item record; |
| l_count integer; |
| BEGIN |
| RAISE NOTICE '--- Initial content of t2: begin ---'; |
| SELECT count(*) INTO l_count FROM t2; |
| RAISE NOTICE '--- # tuple: %', l_count; |
| RAISE NOTICE 'id'; |
| FOR l_item IN SELECT * FROM t2 LOOP |
| RAISE NOTICE '%', quote_ident(l_item.id); |
| END LOOP; |
| RAISE NOTICE '--- Initial content of t2: end ---'; |
| |
| insert into t2 values (1); |
| |
| RAISE NOTICE '--- Content of t2 after seed data inserted: begin ---'; |
| SELECT count(*) INTO l_count FROM t2; |
| RAISE NOTICE '--- # tuple: %', l_count; |
| RAISE NOTICE 'id'; |
| FOR l_item IN SELECT * FROM t2 LOOP |
| RAISE NOTICE '%', quote_ident(l_item.id); |
| END LOOP; |
| RAISE NOTICE '--- Content of t2 after seed data inserted: end ---'; |
| |
| FOR l_rec IN ( SELECT generate_series(1, 3) AS idx ) |
| LOOP |
| INSERT INTO t2 SELECT * FROM t2; |
| |
| RAISE NOTICE '--- Content of t2 after %d insert in loop: begin ---', l_rec.idx; |
| SELECT count(*) INTO l_count FROM t2; |
| RAISE NOTICE '--- # tuple: %', l_count; |
| RAISE NOTICE 'id'; |
| FOR l_item IN SELECT * FROM t2 LOOP |
| RAISE NOTICE '%', quote_ident(l_item.id); |
| END LOOP; |
| RAISE NOTICE '--- Content of t2 after %d insert in loop: end ---', l_rec.idx; |
| END LOOP; |
| |
| RAISE NOTICE '--- Final content of t2: begin ---'; |
| SELECT count(*) INTO l_count FROM t2; |
| RAISE NOTICE '--- # tuple: %', l_count; |
| RAISE NOTICE 'id'; |
| FOR l_item IN SELECT * FROM t2 LOOP |
| RAISE NOTICE '%', quote_ident(l_item.id); |
| END LOOP; |
| RAISE NOTICE '--- Final content of t2: end ---'; |
| |
| RETURN 'done'; |
| END |
| $body$ |
| ; |
| CREATE FUNCTION |
| select f1(); |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:122: NOTICE: --- Initial content of t1: begin --- |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:122: NOTICE: --- # tuple: 1 |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:122: NOTICE: id |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:122: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:122: NOTICE: --- Initial content of t1: end --- |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:122: NOTICE: --- Content of t1 after 1d insert in loop: begin --- |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:122: NOTICE: --- # tuple: 2 |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:122: NOTICE: id |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:122: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:122: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:122: NOTICE: --- Content of t1 after 1d insert in loop: end --- |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:122: NOTICE: --- Content of t1 after 2d insert in loop: begin --- |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:122: NOTICE: --- # tuple: 4 |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:122: NOTICE: id |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:122: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:122: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:122: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:122: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:122: NOTICE: --- Content of t1 after 2d insert in loop: end --- |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:122: NOTICE: --- Content of t1 after 3d insert in loop: begin --- |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:122: NOTICE: --- # tuple: 8 |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:122: NOTICE: id |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:122: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:122: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:122: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:122: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:122: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:122: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:122: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:122: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:122: NOTICE: --- Content of t1 after 3d insert in loop: end --- |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:122: NOTICE: --- Final content of t1: begin --- |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:122: NOTICE: --- # tuple: 8 |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:122: NOTICE: id |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:122: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:122: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:122: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:122: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:122: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:122: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:122: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:122: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:122: NOTICE: --- Final content of t1: end --- |
| f1 |
| ------ |
| done |
| (1 row) |
| |
| select f2(); |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: --- Initial content of t2: begin --- |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: --- # tuple: 0 |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: id |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: --- Initial content of t2: end --- |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: --- Content of t2 after seed data inserted: begin --- |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: --- # tuple: 1 |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: id |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: --- Content of t2 after seed data inserted: end --- |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: --- Content of t2 after 1d insert in loop: begin --- |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: --- # tuple: 2 |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: id |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: --- Content of t2 after 1d insert in loop: end --- |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: --- Content of t2 after 2d insert in loop: begin --- |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: --- # tuple: 4 |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: id |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: --- Content of t2 after 2d insert in loop: end --- |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: --- Content of t2 after 3d insert in loop: begin --- |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: --- # tuple: 8 |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: id |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: --- Content of t2 after 3d insert in loop: end --- |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: --- Final content of t2: begin --- |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: --- # tuple: 8 |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: id |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: "1" |
| psql:/tmp/TestPreparedStatement_TestPreparedStatementInsert.sql:124: NOTICE: --- Final content of t2: end --- |
| f2 |
| ------ |
| done |
| (1 row) |
| |
| select * from t1; |
| id |
| ---- |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| (8 rows) |
| |
| select * from t2; |
| id |
| ---- |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| (8 rows) |
| |
| drop function if exists f1(); |
| DROP FUNCTION |
| drop function if exists f2(); |
| DROP FUNCTION |
| drop table if exists t1; |
| DROP TABLE |
| drop table if exists t2; |
| DROP TABLE |
