diff options
| author | Tom Lane | 2010-01-26 16:33:40 +0000 |
|---|---|---|
| committer | Tom Lane | 2010-01-26 16:33:40 +0000 |
| commit | d879697cd291a31c635edf17c4b8c170ac40ffc1 (patch) | |
| tree | c8d673ff347fb4e42b78ca3c18c3dfa822a0e5a4 /src/test | |
| parent | 6c0f94fc0daa9ff1aa5636aea25afb4d5c6d767e (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.out | 4 | ||||
| -rw-r--r-- | src/test/regress/sql/plpgsql.sql | 4 |
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 |
