Commit1ade4b3

committed

Triggers should return TRIGGER not OPAQUE. Looks like this script got

overlooked in 7.3 updates. Not a critical fix but avoids a notice whenthe resulting SQL script is executed.

1 parent96ecf9d commit1ade4b3Copy full SHA for 1ade4b3

File tree

-1

lines changed

-1

lines changed

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -881,7 +881,7 @@ print STDERR "Add triggers definition...\n" if ($self->{debug});`
`881`	`881`	`if ($self->{export_schema}) {`
`882`	`882`	`$sql_output .="SET search_path =$self->{schema}, pg_catalog;\n\n";`
`883`	`883`	`}`
`884`		`-$sql_output .="CREATE FUNCTION pg_fct_\L$trig->[0]\E () RETURNSOPAQUE AS '\n$trig->[4]\n' LANGUAGE 'plpgsql'\n\n";`
	`884`	`+$sql_output .="CREATE FUNCTION pg_fct_\L$trig->[0]\E () RETURNSTRIGGER AS '\n$trig->[4]\n' LANGUAGE 'plpgsql'\n\n";`
`885`	`885`	`$sql_output .="CREATE TRIGGER\L$trig->[0]\E\n\t$trig->[1]$trig->[2] ON\"\L$trig->[3]\E\" FOR EACH ROW\n\tEXECUTE PROCEDURE pg_fct_\L$trig->[0]\E();\n\n";`
`886`	`886`	`}`
`887`	`887`	`}`

Comments

(0)