Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit5484c0a

Browse files
committed
Minor fixes in contrib installation scripts.
Extension scripts should never use CREATE OR REPLACE for initial objectcreation. If there is a collision with a pre-existing (probablyuser-created) object, we want extension installation to fail, not silentlyoverwrite the user's object. Bloom and sslinfo both violated this precept.Also fix a number of scripts that had no standard header (the file namecomment and the \echo...\quit guard). Probably the \echo...\quit hackis less important now than it was in 9.1 days, but that doesn't meanthat individual extensions get to choose whether to use it or not.And fix a couple of evident copy-and-pasteos in file name comments.No need for back-patch: the REPLACE bugs are both new in 9.6, and therest of this is pretty much cosmetic.Andreas Karlsson and Tom Lane
1 parent332fdbe commit5484c0a

13 files changed

+50
-5
lines changed

‎contrib/bloom/bloom--1.0.sql

Lines changed: 6 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,9 @@
1-
CREATE OR REPLACEFUNCTIONblhandler(internal)
1+
/* contrib/bloom/bloom--1.0.sql*/
2+
3+
-- complain if script is sourced in psql, rather than via CREATE EXTENSION
4+
\echo Use"CREATE EXTENSION bloom" to load this file. \quit
5+
6+
CREATEFUNCTIONblhandler(internal)
27
RETURNS index_am_handler
38
AS'MODULE_PATHNAME'
49
LANGUAGE C;

‎contrib/hstore_plperl/hstore_plperl--1.0.sql

Lines changed: 5 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1,3 +1,8 @@
1+
/* contrib/hstore_plperl/hstore_plperl--1.0.sql*/
2+
3+
-- complain if script is sourced in psql, rather than via CREATE EXTENSION
4+
\echo Use"CREATE EXTENSION hstore_plperl" to load this file. \quit
5+
16
-- make sure the prerequisite libraries are loaded
27
LOAD'plperl';
38
SELECTNULL::hstore;

‎contrib/hstore_plperl/hstore_plperlu--1.0.sql

Lines changed: 5 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1,3 +1,8 @@
1+
/* contrib/hstore_plperl/hstore_plperlu--1.0.sql*/
2+
3+
-- complain if script is sourced in psql, rather than via CREATE EXTENSION
4+
\echo Use"CREATE EXTENSION hstore_plperlu" to load this file. \quit
5+
16
-- make sure the prerequisite libraries are loaded
27
LOAD'plperl';
38
SELECTNULL::hstore;

‎contrib/hstore_plpython/hstore_plpython2u--1.0.sql

Lines changed: 5 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1,3 +1,8 @@
1+
/* contrib/hstore_plpython/hstore_plpython2u--1.0.sql*/
2+
3+
-- complain if script is sourced in psql, rather than via CREATE EXTENSION
4+
\echo Use"CREATE EXTENSION hstore_plpython2u" to load this file. \quit
5+
16
-- make sure the prerequisite libraries are loaded
27
LOAD'plpython2';
38
SELECTNULL::hstore;

‎contrib/hstore_plpython/hstore_plpython3u--1.0.sql

Lines changed: 5 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1,3 +1,8 @@
1+
/* contrib/hstore_plpython/hstore_plpython3u--1.0.sql*/
2+
3+
-- complain if script is sourced in psql, rather than via CREATE EXTENSION
4+
\echo Use"CREATE EXTENSION hstore_plpython3u" to load this file. \quit
5+
16
-- make sure the prerequisite libraries are loaded
27
LOAD'plpython3';
38
SELECTNULL::hstore;

‎contrib/hstore_plpython/hstore_plpythonu--1.0.sql

Lines changed: 5 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1,3 +1,8 @@
1+
/* contrib/hstore_plpython/hstore_plpythonu--1.0.sql*/
2+
3+
-- complain if script is sourced in psql, rather than via CREATE EXTENSION
4+
\echo Use"CREATE EXTENSION hstore_plpythonu" to load this file. \quit
5+
16
-- make sure the prerequisite libraries are loaded
27
LOAD'plpython2';-- change to plpython3 if that ever becomes the default
38
SELECTNULL::hstore;

‎contrib/ltree_plpython/ltree_plpython2u--1.0.sql

Lines changed: 5 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1,3 +1,8 @@
1+
/* contrib/ltree_plpython/ltree_plpython2u--1.0.sql*/
2+
3+
-- complain if script is sourced in psql, rather than via CREATE EXTENSION
4+
\echo Use"CREATE EXTENSION ltree_plpython2u" to load this file. \quit
5+
16
-- make sure the prerequisite libraries are loaded
27
LOAD'plpython2';
38
SELECTNULL::ltree;

‎contrib/ltree_plpython/ltree_plpython3u--1.0.sql

Lines changed: 5 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1,3 +1,8 @@
1+
/* contrib/ltree_plpython/ltree_plpython3u--1.0.sql*/
2+
3+
-- complain if script is sourced in psql, rather than via CREATE EXTENSION
4+
\echo Use"CREATE EXTENSION ltree_plpython3u" to load this file. \quit
5+
16
-- make sure the prerequisite libraries are loaded
27
LOAD'plpython3';
38
SELECTNULL::ltree;

‎contrib/ltree_plpython/ltree_plpythonu--1.0.sql

Lines changed: 5 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1,3 +1,8 @@
1+
/* contrib/ltree_plpython/ltree_plpythonu--1.0.sql*/
2+
3+
-- complain if script is sourced in psql, rather than via CREATE EXTENSION
4+
\echo Use"CREATE EXTENSION ltree_plpythonu" to load this file. \quit
5+
16
-- make sure the prerequisite libraries are loaded
27
LOAD'plpython2';-- change to plpython3 if that ever becomes the default
38
SELECTNULL::ltree;

‎contrib/pgcrypto/pgcrypto--1.3.sql

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
/* contrib/pgcrypto/pgcrypto--1.2.sql*/
1+
/* contrib/pgcrypto/pgcrypto--1.3.sql*/
22

33
-- complain if script is sourced in psql, rather than via CREATE EXTENSION
44
\echo Use"CREATE EXTENSION pgcrypto" to load this file. \quit

‎contrib/pgrowlocks/pgrowlocks--1.2.sql

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
/* contrib/pgrowlocks/pgrowlocks--1.1.sql*/
1+
/* contrib/pgrowlocks/pgrowlocks--1.2.sql*/
22

33
-- complain if script is sourced in psql, rather than via CREATE EXTENSION
44
\echo Use"CREATE EXTENSION pgrowlocks" to load this file. \quit

‎contrib/pgstattuple/pgstattuple--1.4.sql

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
/* contrib/pgstattuple/pgstattuple--1.3.sql*/
1+
/* contrib/pgstattuple/pgstattuple--1.4.sql*/
22

33
-- complain if script is sourced in psql, rather than via CREATE EXTENSION
44
\echo Use"CREATE EXTENSION pgstattuple" to load this file. \quit

‎contrib/sslinfo/sslinfo--1.0--1.1.sql

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -3,7 +3,7 @@
33
-- complain if script is sourced in psql, rather than via CREATE EXTENSION
44
\echo Use"ALTER EXTENSION sslinfo UPDATE TO '1.1'" to load this file. \quit
55

6-
CREATEOR REPLACEFUNCTION
6+
CREATE FUNCTION
77
ssl_extension_info(OUT nametext,
88
OUT valuetext,
99
OUT criticalboolean

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp