aboutsummaryrefslogtreecommitdiff
path: root/src/pl/plperl/sql
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2010-10-31 11:42:51 -0400
committerTom Lane <tgl@sss.pgh.pa.us>2010-10-31 11:42:51 -0400
commit76b12e0af765b2ca2eeddcabdd5e7c22eda164da (patch)
tree7c33ae67ed542302f5055c41ef9baf58fd0e7da0 /src/pl/plperl/sql
parent186cbbda8f8dc5e42f68fc7892f206a76d56a20f (diff)
downloadpostgresql-REL9_1_ALPHA2.tar.gz
postgresql-REL9_1_ALPHA2.zip
Revert removal of trigger flag from plperl function hash key.REL9_1_ALPHA2
As noted by Jan Urbanski, this flag is in fact needed to ensure that the function's input/result conversion functions are set up as expected. Add a regression test to discourage anyone from making same mistake in future.
Diffstat (limited to 'src/pl/plperl/sql')
-rw-r--r--src/pl/plperl/sql/plperl_trigger.sql7
1 files changed, 6 insertions, 1 deletions
diff --git a/src/pl/plperl/sql/plperl_trigger.sql b/src/pl/plperl/sql/plperl_trigger.sql
index 1e68759b0f8..c47ddad3ca8 100644
--- a/src/pl/plperl/sql/plperl_trigger.sql
+++ b/src/pl/plperl/sql/plperl_trigger.sql
@@ -128,5 +128,10 @@ FOR EACH ROW EXECUTE PROCEDURE immortal('immortal');
DELETE FROM trigger_test;
-
SELECT * FROM trigger_test;
+
+CREATE FUNCTION direct_trigger() RETURNS trigger AS $$
+ return;
+$$ LANGUAGE plperl;
+
+SELECT direct_trigger();