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

Commitb60653b

Browse files
committed
Remove hstore's text => text operator.
Since PostgreSQL 9.0, we've emitted a warning message when an operatornamed => is created, because the SQL standard now reserves that tokenfor another use. But we've also shipped such an operator with hstore.Use of the function hstore(text, text) has been recommended inpreference to =>(text, text). Per discussion, it's now time to takethe next step and stop shipping the operator. This will allow us toprohibit the use of => as an operator name in a future release if andwhen we wish to support the SQL standard use of this token.The release notes should mention this incompatibility.Patch by me, reviewed by David Wheeler, Dimitri Fontaine and Tom Lane.
1 parentbbb6e55 commitb60653b

File tree

5 files changed

+535
-18
lines changed

5 files changed

+535
-18
lines changed

‎contrib/hstore/Makefile

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -5,7 +5,8 @@ OBJS = hstore_io.o hstore_op.o hstore_gist.o hstore_gin.o hstore_compat.o \
55
crc32.o
66

77
EXTENSION = hstore
8-
DATA = hstore--1.0.sql hstore--unpackaged--1.0.sql
8+
DATA = hstore--1.0.sql hstore--1.1.sql hstore--1.0--1.1.sql\
9+
hstore--unpackaged--1.0.sql
910

1011
REGRESS = hstore
1112

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

Lines changed: 7 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,7 @@
1+
/* contrib/hstore/hstore-1.0-1.1.sql*/
2+
3+
-- complain if script is sourced in psql, rather than via CREATE EXTENSION
4+
\echo Use"ALTER EXTENSION hstore UPDATE TO '1.1'" to load this file. \quit
5+
6+
ALTER EXTENSION hstore DROP OPERATOR=> (text,text);
7+
DROPOPERATOR=> (text,text);

0 commit comments

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