summaryrefslogtreecommitdiff
path: root/contrib/fulltextindex
diff options
context:
space:
mode:
Diffstat (limited to 'contrib/fulltextindex')
-rw-r--r--contrib/fulltextindex/fti.pl1
-rw-r--r--contrib/fulltextindex/fti.sql.in2
-rw-r--r--contrib/fulltextindex/uninstall.sql2
3 files changed, 0 insertions, 5 deletions
diff --git a/contrib/fulltextindex/fti.pl b/contrib/fulltextindex/fti.pl
index 60c7d97c6b..17f000149b 100644
--- a/contrib/fulltextindex/fti.pl
+++ b/contrib/fulltextindex/fti.pl
@@ -167,7 +167,6 @@ sub main {
}
PQexec($PG_CONN, "SET search_path = public");
- PQexec($PG_CONN, "SET autocommit TO 'on'");
PQexec($PG_CONN, "begin");
$query = "declare C cursor for select (\"";
diff --git a/contrib/fulltextindex/fti.sql.in b/contrib/fulltextindex/fti.sql.in
index d109aa9a10..93eff0f633 100644
--- a/contrib/fulltextindex/fti.sql.in
+++ b/contrib/fulltextindex/fti.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 OR REPLACE FUNCTION fti() RETURNS trigger AS
'MODULE_PATHNAME', 'fti'
LANGUAGE 'C' VOLATILE CALLED ON NULL INPUT;
diff --git a/contrib/fulltextindex/uninstall.sql b/contrib/fulltextindex/uninstall.sql
index 5a330546ab..a06bab860f 100644
--- a/contrib/fulltextindex/uninstall.sql
+++ b/contrib/fulltextindex/uninstall.sql
@@ -1,6 +1,4 @@
-- Adjust this setting to control where the objects get created.
SET search_path = public;
-SET autocommit TO 'on';
-
DROP FUNCTION fti() CASCADE;