summaryrefslogtreecommitdiff
path: root/contrib/ltree
diff options
context:
space:
mode:
authorTom Lane2003-05-14 03:26:03 +0000
committerTom Lane2003-05-14 03:26:03 +0000
commitf85f43dfb5b9043ea6b01d8b824c195cd7f9ed3c (patch)
tree149a8221767ed2e9c63adc58cc88c4d8faca5381 /contrib/ltree
parentd9b679c13a820eb7b464a1eeb1f177c3fea13ece (diff)
Backend support for autocommit removed, per recent discussions. The
only remnant of this failed experiment is that the server will take SET AUTOCOMMIT TO ON. Still TODO: provide some client-side autocommit logic in libpq.
Diffstat (limited to 'contrib/ltree')
-rw-r--r--contrib/ltree/expected/ltree.out16
-rw-r--r--contrib/ltree/ltree.sql.in2
2 files changed, 8 insertions, 10 deletions
diff --git a/contrib/ltree/expected/ltree.out b/contrib/ltree/expected/ltree.out
index 01246444f89..d856f0dbabc 100644
--- a/contrib/ltree/expected/ltree.out
+++ b/contrib/ltree/expected/ltree.out
@@ -1,12 +1,12 @@
\set ECHO none
-psql:ltree.sql:9: NOTICE: ProcedureCreate: type ltree is not yet defined
-psql:ltree.sql:14: NOTICE: Argument type "ltree" is only a shell
-psql:ltree.sql:301: NOTICE: ProcedureCreate: type lquery is not yet defined
-psql:ltree.sql:306: NOTICE: Argument type "lquery" is only a shell
-psql:ltree.sql:412: NOTICE: ProcedureCreate: type ltxtquery is not yet defined
-psql:ltree.sql:417: NOTICE: Argument type "ltxtquery" is only a shell
-psql:ltree.sql:479: NOTICE: ProcedureCreate: type ltree_gist is not yet defined
-psql:ltree.sql:484: NOTICE: Argument type "ltree_gist" is only a shell
+psql:ltree.sql:7: NOTICE: ProcedureCreate: type ltree is not yet defined
+psql:ltree.sql:12: NOTICE: Argument type "ltree" is only a shell
+psql:ltree.sql:299: NOTICE: ProcedureCreate: type lquery is not yet defined
+psql:ltree.sql:304: NOTICE: Argument type "lquery" is only a shell
+psql:ltree.sql:410: NOTICE: ProcedureCreate: type ltxtquery is not yet defined
+psql:ltree.sql:415: NOTICE: Argument type "ltxtquery" is only a shell
+psql:ltree.sql:477: NOTICE: ProcedureCreate: type ltree_gist is not yet defined
+psql:ltree.sql:482: NOTICE: Argument type "ltree_gist" is only a shell
SELECT ''::ltree;
ltree
-------
diff --git a/contrib/ltree/ltree.sql.in b/contrib/ltree/ltree.sql.in
index 2f267b9828a..7d8bdc35240 100644
--- a/contrib/ltree/ltree.sql.in
+++ b/contrib/ltree/ltree.sql.in
@@ -1,8 +1,6 @@
-- Adjust this setting to control where the objects get created.
SET search_path = public;
-SET autocommit TO 'on';
-
CREATE FUNCTION ltree_in(cstring)
RETURNS ltree
AS 'MODULE_PATHNAME'