aboutsummaryrefslogtreecommitdiff
path: root/contrib/btree_gist
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/btree_gist
parentd9b679c13a820eb7b464a1eeb1f177c3fea13ece (diff)
downloadpostgresql-f85f43dfb5b9043ea6b01d8b824c195cd7f9ed3c.tar.gz
postgresql-f85f43dfb5b9043ea6b01d8b824c195cd7f9ed3c.zip
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/btree_gist')
-rw-r--r--contrib/btree_gist/btree_gist.sql.in2
-rw-r--r--contrib/btree_gist/expected/btree_gist.out24
2 files changed, 12 insertions, 14 deletions
diff --git a/contrib/btree_gist/btree_gist.sql.in b/contrib/btree_gist/btree_gist.sql.in
index 4f0b1291df9..70db5a860da 100644
--- a/contrib/btree_gist/btree_gist.sql.in
+++ b/contrib/btree_gist/btree_gist.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 type of int2 key
CREATE FUNCTION int2key_in(cstring)
RETURNS int2key
diff --git a/contrib/btree_gist/expected/btree_gist.out b/contrib/btree_gist/expected/btree_gist.out
index 3cd35992e44..497740062d3 100644
--- a/contrib/btree_gist/expected/btree_gist.out
+++ b/contrib/btree_gist/expected/btree_gist.out
@@ -3,18 +3,18 @@
-- does not depend on contents of btree_gist.sql.
--
\set ECHO none
-psql:btree_gist.sql:10: NOTICE: ProcedureCreate: type int2key is not yet defined
-psql:btree_gist.sql:15: NOTICE: Argument type "int2key" is only a shell
-psql:btree_gist.sql:27: NOTICE: ProcedureCreate: type int4key is not yet defined
-psql:btree_gist.sql:32: NOTICE: Argument type "int4key" is only a shell
-psql:btree_gist.sql:44: NOTICE: ProcedureCreate: type int8key is not yet defined
-psql:btree_gist.sql:49: NOTICE: Argument type "int8key" is only a shell
-psql:btree_gist.sql:61: NOTICE: ProcedureCreate: type float4key is not yet defined
-psql:btree_gist.sql:66: NOTICE: Argument type "float4key" is only a shell
-psql:btree_gist.sql:79: NOTICE: ProcedureCreate: type float8key is not yet defined
-psql:btree_gist.sql:84: NOTICE: Argument type "float8key" is only a shell
-psql:btree_gist.sql:394: NOTICE: ProcedureCreate: type tskey is not yet defined
-psql:btree_gist.sql:399: NOTICE: Argument type "tskey" is only a shell
+psql:btree_gist.sql:8: NOTICE: ProcedureCreate: type int2key is not yet defined
+psql:btree_gist.sql:13: NOTICE: Argument type "int2key" is only a shell
+psql:btree_gist.sql:25: NOTICE: ProcedureCreate: type int4key is not yet defined
+psql:btree_gist.sql:30: NOTICE: Argument type "int4key" is only a shell
+psql:btree_gist.sql:42: NOTICE: ProcedureCreate: type int8key is not yet defined
+psql:btree_gist.sql:47: NOTICE: Argument type "int8key" is only a shell
+psql:btree_gist.sql:59: NOTICE: ProcedureCreate: type float4key is not yet defined
+psql:btree_gist.sql:64: NOTICE: Argument type "float4key" is only a shell
+psql:btree_gist.sql:77: NOTICE: ProcedureCreate: type float8key is not yet defined
+psql:btree_gist.sql:82: NOTICE: Argument type "float8key" is only a shell
+psql:btree_gist.sql:392: NOTICE: ProcedureCreate: type tskey is not yet defined
+psql:btree_gist.sql:397: NOTICE: Argument type "tskey" is only a shell
CREATE TABLE int4tmp (b int4);
\copy int4tmp from 'data/test_btree.data'
CREATE TABLE int8tmp (b int8);