Commit5214f09

committed

Clean up for dblink autocommit OFF handling.

1 parentaa4c702 commit5214f09Copy full SHA for 5214f09

File tree

-2

lines changed

-2

lines changed

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -183,7 +183,7 @@ WHERE t.a > 7;`
`183`	`183`	`ERROR: dblink: no connection available`
`184`	`184`	`-- put more data into our slave table, first using arbitrary connection syntax`
`185`	`185`	`-- but truncate the actual return value so we can use diff to check for success`
`186`		`-SELECT substr(dblink_exec('dbname=regression_slave','INSERT INTO foo VALUES (10,''k'',''{"a10","b10","c10"}'')'),1,6);`
	`186`	`+SELECT substr(dblink_exec('dbname=regression_slave','SET autocommit TO ''on'';INSERT INTO foo VALUES (10,''k'',''{"a10","b10","c10"}'')'),1,6);`
`187`	`187`	`substr`
`188`	`188`	`--------`
`189`	`189`	`INSERT`

Lines changed: 3 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -30,6 +30,7 @@ CREATE DATABASE regression_slave;`
`30`	`30`	`-- Turn off echoing so that expected file does not depend on`
`31`	`31`	`-- contents of dblink.sql.`
`32`	`32`	`\set ECHO none`
	`33`	`+SET autocommit TO'on';`
`33`	`34`	`\idblink.sql`
`34`	`35`	`\set ECHO all`
`35`	`36`
`@@ -72,6 +73,7 @@ SELECT dblink_build_sql_delete('foo','1 2',2,'{"0", "a"}');`
`72`	`73`	`--`
`73`	`74`	`\connect regression`
`74`	`75`	`\set ECHO none`
	`76`	`+SET autocommit TO'on';`
`75`	`77`	`\idblink.sql`
`76`	`78`	`\set ECHO all`
`77`	`79`
`@@ -124,7 +126,7 @@ WHERE t.a > 7;`
`124`	`126`
`125`	`127`	`-- put more data into our slave table, first using arbitrary connection syntax`
`126`	`128`	`-- but truncate the actual return value so we can use diff to check for success`
`127`		`-SELECT substr(dblink_exec('dbname=regression_slave','INSERT INTO foo VALUES(10,''k'',''{"a10","b10","c10"}'')'),1,6);`
	`129`	`+SELECT substr(dblink_exec('dbname=regression_slave','SET autocommit TO''on'';INSERT INTO foo VALUES(10,''k'',''{"a10","b10","c10"}'')'),1,6);`
`128`	`130`
`129`	`131`	`-- create a persistent connection`
`130`	`132`	`SELECT dblink_connect('dbname=regression_slave');`

Comments

(0)