X-Git-Url: http://sigaev.ru/git/gitweb.cgi?p=wildspeed.git;a=blobdiff_plain;f=wildspeed--1.0.sql;fp=wildspeed.sql.in;h=39f7b43d9b32365e421b8044a03b95a8c49aa8fc;hp=4cbaa5af16c0f874fbe4a7d37ace7fb20ed57fa3;hb=HEAD;hpb=936872280c2b3d21e5c20931c2094f33d3a0e6c2

diff --git a/wildspeed.sql.in b/wildspeed--1.0.sql
similarity index 87%
rename from wildspeed.sql.in
rename to wildspeed--1.0.sql
index 4cbaa5a..39f7b43 100644
--- a/wildspeed.sql.in
+++ b/wildspeed--1.0.sql
@@ -1,4 +1,5 @@
-BEGIN;
+-- complain if script is sourced in psql, rather than via CREATE EXTENSION
+\echo Use "CREATE EXTENSION wildspeed" to load this file. \quit
 
 -- support functions for gin
 CREATE OR REPLACE FUNCTION gin_extract_permuted(text, internal)
@@ -29,7 +30,7 @@ LANGUAGE C IMMUTABLE;
 CREATE OPERATOR CLASS wildcard_ops
 FOR TYPE text USING gin
 AS
-    OPERATOR        1       ~~,
+	OPERATOR        1       ~~,
 	FUNCTION        1       wildcmp(text,text),
 	FUNCTION        2       gin_extract_permuted(text, internal),
 	FUNCTION        3       gin_extract_wildcard(text, internal, int2, internal),
@@ -43,5 +44,3 @@ CREATE OR REPLACE FUNCTION permute(text)
 RETURNS _text
 AS 'MODULE_PATHNAME'
 LANGUAGE C STRICT IMMUTABLE;
-
-COMMIT;