diff options
| author | Tom Lane | 2003-05-14 03:26:03 +0000 |
|---|---|---|
| committer | Tom Lane | 2003-05-14 03:26:03 +0000 |
| commit | f85f43dfb5b9043ea6b01d8b824c195cd7f9ed3c (patch) | |
| tree | 149a8221767ed2e9c63adc58cc88c4d8faca5381 /contrib/fulltextindex | |
| parent | d9b679c13a820eb7b464a1eeb1f177c3fea13ece (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/fulltextindex')
| -rw-r--r-- | contrib/fulltextindex/fti.pl | 1 | ||||
| -rw-r--r-- | contrib/fulltextindex/fti.sql.in | 2 | ||||
| -rw-r--r-- | contrib/fulltextindex/uninstall.sql | 2 |
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; |