summaryrefslogtreecommitdiff
path: root/src/test
diff options
context:
space:
mode:
authorTom Lane2010-01-26 16:33:40 +0000
committerTom Lane2010-01-26 16:33:40 +0000
commitd879697cd291a31c635edf17c4b8c170ac40ffc1 (patch)
treec8d673ff347fb4e42b78ca3c18c3dfa822a0e5a4 /src/test
parent6c0f94fc0daa9ff1aa5636aea25afb4d5c6d767e (diff)
Remove the default_do_language parameter, instead making DO use a hardwired
default of "plpgsql". This is more reasonable than it was when the DO patch was written, because we have since decided that plpgsql should be installed by default. Per discussion, having a parameter for this doesn't seem useful enough to justify the risk of application breakage if the value is changed unexpectedly.
Diffstat (limited to 'src/test')
-rw-r--r--src/test/regress/expected/plpgsql.out4
-rw-r--r--src/test/regress/sql/plpgsql.sql4
2 files changed, 4 insertions, 4 deletions
diff --git a/src/test/regress/expected/plpgsql.out b/src/test/regress/expected/plpgsql.out
index c2bf41d6fc..619939ffa3 100644
--- a/src/test/regress/expected/plpgsql.out
+++ b/src/test/regress/expected/plpgsql.out
@@ -3984,7 +3984,7 @@ BEGIN
LOOP
RAISE NOTICE '%, %', r.roomno, r.comment;
END LOOP;
-END$$ LANGUAGE plpgsql;
+END$$;
NOTICE: 001, Entrance
NOTICE: 002, Office
NOTICE: 003, Office
@@ -4000,7 +4000,7 @@ DO LANGUAGE plpgsql $$begin return 1; end$$;
ERROR: RETURN cannot have a parameter in function returning void
LINE 1: DO LANGUAGE plpgsql $$begin return 1; end$$;
^
-DO LANGUAGE plpgsql $$
+DO $$
DECLARE r record;
BEGIN
FOR r IN SELECT rtrim(roomno) AS roomno, foo FROM Room ORDER BY roomno
diff --git a/src/test/regress/sql/plpgsql.sql b/src/test/regress/sql/plpgsql.sql
index 3613194fd9..e181b10898 100644
--- a/src/test/regress/sql/plpgsql.sql
+++ b/src/test/regress/sql/plpgsql.sql
@@ -3164,12 +3164,12 @@ BEGIN
LOOP
RAISE NOTICE '%, %', r.roomno, r.comment;
END LOOP;
-END$$ LANGUAGE plpgsql;
+END$$;
-- these are to check syntax error reporting
DO LANGUAGE plpgsql $$begin return 1; end$$;
-DO LANGUAGE plpgsql $$
+DO $$
DECLARE r record;
BEGIN
FOR r IN SELECT rtrim(roomno) AS roomno, foo FROM Room ORDER BY roomno