From f85f43dfb5b9043ea6b01d8b824c195cd7f9ed3c Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Wed, 14 May 2003 03:26:03 +0000 Subject: 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. --- contrib/ltree/expected/ltree.out | 16 ++++++++-------- contrib/ltree/ltree.sql.in | 2 -- 2 files changed, 8 insertions(+), 10 deletions(-) (limited to 'contrib/ltree') diff --git a/contrib/ltree/expected/ltree.out b/contrib/ltree/expected/ltree.out index 01246444f8..d856f0dbab 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 2f267b9828..7d8bdc3524 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' -- cgit v1.2.1