summaryrefslogtreecommitdiff
path: root/contrib/earthdistance
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2003-05-14 03:26:03 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2003-05-14 03:26:03 +0000
commitf85f43dfb5b9043ea6b01d8b824c195cd7f9ed3c (patch)
tree149a8221767ed2e9c63adc58cc88c4d8faca5381 /contrib/earthdistance
parentd9b679c13a820eb7b464a1eeb1f177c3fea13ece (diff)
downloadpostgresql-f85f43dfb5b9043ea6b01d8b824c195cd7f9ed3c.tar.gz
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/earthdistance')
-rw-r--r--contrib/earthdistance/earthdistance.sql.in2
-rw-r--r--contrib/earthdistance/expected/earthdistance.out4
2 files changed, 2 insertions, 4 deletions
diff --git a/contrib/earthdistance/earthdistance.sql.in b/contrib/earthdistance/earthdistance.sql.in
index 6ee9a87b4f..6520c6eb41 100644
--- a/contrib/earthdistance/earthdistance.sql.in
+++ b/contrib/earthdistance/earthdistance.sql.in
@@ -1,8 +1,6 @@
-- Adjust this setting to control where the objects get created.
SET search_path = public;
-SET autocommit TO 'on';
-
-- The earth functions rely on contrib/cube having been installed and loaded.
-- earth() returns the radius of the earth in meters. This is the only
diff --git a/contrib/earthdistance/expected/earthdistance.out b/contrib/earthdistance/expected/earthdistance.out
index 963c3b11b0..e1aadef9c7 100644
--- a/contrib/earthdistance/expected/earthdistance.out
+++ b/contrib/earthdistance/expected/earthdistance.out
@@ -6,8 +6,8 @@
-- does not depend on contents of earthdistance.sql or cube.sql.
--
\set ECHO none
-psql:../cube/cube.sql:12: NOTICE: ProcedureCreate: type cube is not yet defined
-psql:../cube/cube.sql:17: NOTICE: Argument type "cube" is only a shell
+psql:../cube/cube.sql:10: NOTICE: ProcedureCreate: type cube is not yet defined
+psql:../cube/cube.sql:15: NOTICE: Argument type "cube" is only a shell
--
-- The radius of the Earth we are using.
--