From aa4c702eac936964649f905741b4a99f4b489200 Mon Sep 17 00:00:00 2001
From: Bruce Momjian <bruce@momjian.us>
Date: Fri, 18 Oct 2002 18:41:22 +0000
Subject: Update /contrib for "autocommit TO 'on'".

Create objects in public schema.

Make spacing/capitalization consistent.

Remove transaction block use for object creation.

Remove unneeded function GRANTs.
---
 contrib/btree_gist/sql/btree_gist.sql | 19 ++++++++++---------
 1 file changed, 10 insertions(+), 9 deletions(-)

(limited to 'contrib/btree_gist/sql/btree_gist.sql')

diff --git a/contrib/btree_gist/sql/btree_gist.sql b/contrib/btree_gist/sql/btree_gist.sql
index 31c778b7471..d6e564dda36 100644
--- a/contrib/btree_gist/sql/btree_gist.sql
+++ b/contrib/btree_gist/sql/btree_gist.sql
@@ -3,34 +3,35 @@
 -- does not depend on contents of seg.sql.
 --
 \set ECHO none
+SET autocommit TO 'on';
 \i btree_gist.sql
 \set ECHO all
 
-create table inttmp (b int4);
+CREATE TABLE inttmp (b int4);
 
 \copy inttmp from 'data/test_btree.data'
 
-create table tstmp ( t timestamp without time zone );
+CREATE TABLE tstmp ( t timestamp without time zone );
 
 \copy tstmp from 'data/test_btree_ts.data'
 
 -- without idx
 
-select count(*) from inttmp where b <=10;
+SELECT count(*) FROM inttmp WHERE b <=10;
 
-select count(*) from tstmp where t < '2001-05-29 08:33:09';
+SELECT count(*) FROM tstmp WHERE t < '2001-05-29 08:33:09';
 
 -- create idx
 
-create index aaaidx on inttmp using gist ( b );
+CREATE INDEX aaaidx ON inttmp USING gist ( b );
 
-create index tsidx on tstmp using gist ( t );
+CREATE INDEX tsidx ON tstmp USING gist ( t );
 
 --with idx
 
-set enable_seqscan=off;
+SET enable_seqscan=off;
 
-select count(*) from inttmp where b <=10;
+SELECT count(*) FROM inttmp WHERE b <=10;
 
-select count(*) from tstmp where t < '2001-05-29 08:33:09';
+SELECT count(*) FROM tstmp WHERE t < '2001-05-29 08:33:09';
 
-- 
cgit v1.2.3

