Commitdfdb2e5

Thomas G. Lockhart

committed

Remove non-portable queries by replacing getpgusername() with a constant

string.

1 parent4aa0e64 commitdfdb2e5Copy full SHA for dfdb2e5

File tree

+15

-11

lines changed

+15

-11

lines changed

Lines changed: 10 additions & 10 deletions

Original file line number	Diff line number	Diff line change
`@@ -944,14 +944,14 @@ QUERY: CREATE RULE log_shoelace AS ON UPDATE TO shoelace_data`
`944`	`944`	`DO INSERT INTO shoelace_log VALUES (`
`945`	`945`	`NEW.sl_name,`
`946`	`946`	`NEW.sl_avail,`
`947`		`-getpgusername(),`
	`947`	`+'Al Bundy',`
`948`	`948`	`'epoch'::text`
`949`	`949`	`);`
`950`	`950`	`QUERY: UPDATE shoelace_data SET sl_avail = 6 WHERE sl_name = 'sl7';`
`951`	`951`	`QUERY: SELECT * FROM shoelace_log;`
`952`		`-sl_name \|sl_avail\|log_who\|log_when`
`953`		`-----------+--------+-------+--------`
`954`		`-sl7 \| 6\|postgres\|epoch`
	`952`	`+sl_name \|sl_avail\|log_who\|log_when`
	`953`	`+----------+--------+--------+--------`
	`954`	`+sl7 \| 6\|Al Bundy\|epoch`
`955`	`955`	`(1 row)`
`956`	`956`
`957`	`957`	`QUERY: CREATE RULE shoelace_ins AS ON INSERT TO shoelace`
`@@ -1019,12 +1019,12 @@ sl6 \| 20\|brown \| 0.9\|m \| 90`
`1019`	`1019`	`(8 rows)`
`1020`	`1020`
`1021`	`1021`	`QUERY: SELECT * FROM shoelace_log;`
`1022`		`-sl_name \|sl_avail\|log_who\|log_when`
`1023`		`-----------+--------+-------+--------`
`1024`		`-sl7 \| 6\|postgres\|epoch`
`1025`		`-sl3 \| 10\|postgres\|epoch`
`1026`		`-sl6 \| 20\|postgres\|epoch`
`1027`		`-sl8 \| 21\|postgres\|epoch`
	`1022`	`+sl_name \|sl_avail\|log_who\|log_when`
	`1023`	`+----------+--------+--------+--------`
	`1024`	`+sl7 \| 6\|Al Bundy\|epoch`
	`1025`	`+sl3 \| 10\|Al Bundy\|epoch`
	`1026`	`+sl6 \| 20\|Al Bundy\|epoch`
	`1027`	`+sl8 \| 21\|Al Bundy\|epoch`
`1028`	`1028`	`(4 rows)`
`1029`	`1029`
`1030`	`1030`	`QUERY: CREATE VIEW shoelace_obsolete AS`

Lines changed: 5 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -594,12 +594,16 @@ SELECT * FROM shoe_ready WHERE total_avail >= 2;`
`594`	`594`	`log_when datetime-- when`
`595`	`595`	`);`
`596`	`596`
	`597`	`+-- Want "log_who" to be CURRENT_USER,`
	`598`	`+-- but that is non-portable for the regression test`
	`599`	`+-- - thomas 1999-02-21`
	`600`	`+`
`597`	`601`	`CREATERULElog_shoelaceASONUPDATE TO shoelace_data`
`598`	`602`	`WHERENEW.sl_avail!=OLD.sl_avail`
`599`	`603`	`DOINSERT INTO shoelace_logVALUES (`
`600`	`604`	`NEW.sl_name,`
`601`	`605`	`NEW.sl_avail,`
`602`		`-getpgusername(),`
	`606`	`+'Al Bundy',`
`603`	`607`	`'epoch'::text`
`604`	`608`	`);`
`605`	`609`

Comments

(0)