↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

SQL Commands / Version comparison

What changed?

SQL Commands · PostgreSQL 9.5 → 9.6

Browse PG 9.6

Historical documentation for a PostgreSQL version that is no longer supported.

2 added · 0 removed · 19 changed · 0 coverage changes. These are changes between the pinned reference snapshots.

changedALTER MATERIALIZED VIEW 
--- 9.5
+++ 9.6
@@ -1,5 +1,7 @@
 ALTER MATERIALIZED VIEW [ IF EXISTS ] name
 action [, ... ]
+ALTER MATERIALIZED VIEW name
+DEPENDS ON EXTENSION extension_name
 ALTER MATERIALIZED VIEW [ IF EXISTS ] name
 RENAME [ COLUMN ] column_name TO new_column_name
 ALTER MATERIALIZED VIEW [ IF EXISTS ] name
changedALTER TABLE 
--- 9.5
+++ 9.6
@@ -13,7 +13,7 @@
 
 where action is one of:
 
-ADD [ COLUMN ] column_name data_type [ COLLATE collation ] [ column_constraint [ ... ] ]
+ADD [ COLUMN ] [ IF NOT EXISTS ] column_name data_type [ COLLATE collation ] [ column_constraint [ ... ] ]
 DROP [ COLUMN ] [ IF EXISTS ] column_name [ RESTRICT | CASCADE ]
 ALTER [ COLUMN ] column_name [ SET DATA ] TYPE data_type [ COLLATE collation ] [ USING expression ]
 ALTER [ COLUMN ] column_name SET DEFAULT expression
changedALTER INDEX 
--- 9.5
+++ 9.6
@@ -1,5 +1,6 @@
 ALTER INDEX [ IF EXISTS ] name RENAME TO new_name
 ALTER INDEX [ IF EXISTS ] name SET TABLESPACE tablespace_name
+ALTER INDEX name DEPENDS ON EXTENSION extension_name
 ALTER INDEX [ IF EXISTS ] name SET ( storage_parameter [= value] [, ... ] )
 ALTER INDEX [ IF EXISTS ] name RESET ( storage_parameter [, ... ] )
 ALTER INDEX ALL IN TABLESPACE name [ OWNED BY role_name [, ... ] ]
changedCREATE AGGREGATE 
--- 9.5
+++ 9.6
@@ -4,6 +4,9 @@
 [ , SSPACE = state_data_size ]
 [ , FINALFUNC = ffunc ]
 [ , FINALFUNC_EXTRA ]
+[ , COMBINEFUNC = combinefunc ]
+[ , SERIALFUNC = serialfunc ]
+[ , DESERIALFUNC = deserialfunc ]
 [ , INITCOND = initial_condition ]
 [ , MSFUNC = msfunc ]
 [ , MINVFUNC = minvfunc ]
@@ -13,6 +16,7 @@
 [ , MFINALFUNC_EXTRA ]
 [ , MINITCOND = minitial_condition ]
 [ , SORTOP = sort_operator ]
+[ , PARALLEL = { SAFE | RESTRICTED | UNSAFE } ]
 )
 
 CREATE AGGREGATE name ( [ [ argmode ] [ argname ] arg_data_type [ , ... ] ]
@@ -23,6 +27,7 @@
 [ , FINALFUNC = ffunc ]
 [ , FINALFUNC_EXTRA ]
 [ , INITCOND = initial_condition ]
+[ , PARALLEL = { SAFE | RESTRICTED | UNSAFE } ]
 [ , HYPOTHETICAL ]
 )
 
@@ -35,6 +40,9 @@
 [ , SSPACE = state_data_size ]
 [ , FINALFUNC = ffunc ]
 [ , FINALFUNC_EXTRA ]
+[ , COMBINEFUNC = combinefunc ]
+[ , SERIALFUNC = serialfunc ]
+[ , DESERIALFUNC = deserialfunc ]
 [ , INITCOND = initial_condition ]
 [ , MSFUNC = msfunc ]
 [ , MINVFUNC = minvfunc ]
changedCREATE FUNCTION 
--- 9.5
+++ 9.6
@@ -5,9 +5,11 @@
 { LANGUAGE lang_name
 | TRANSFORM { FOR TYPE type_name } [, ... ]
 | WINDOW
-| IMMUTABLE | STABLE | VOLATILE | [ NOT ] LEAKPROOF
-| CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT | STRICT
-| [ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER
+| { IMMUTABLE | STABLE | VOLATILE }
+| [ NOT ] LEAKPROOF
+| { CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT | STRICT }
+| { [ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER }
+| PARALLEL { UNSAFE | RESTRICTED | SAFE }
 | COST execution_cost
 | ROWS result_rows
 | SET configuration_parameter { TO value | = value | FROM CURRENT }
changedALTER FUNCTION 
--- 9.5
+++ 9.6
@@ -6,11 +6,15 @@
 OWNER TO { new_owner | CURRENT_USER | SESSION_USER }
 ALTER FUNCTION name ( [ [ argmode ] [ argname ] argtype [, ...] ] )
 SET SCHEMA new_schema
+ALTER FUNCTION name ( [ [ argmode ] [ argname ] argtype [, ...] ] )
+DEPENDS ON EXTENSION extension_name
 where action is one of:
 
 CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT | STRICT
-IMMUTABLE | STABLE | VOLATILE | [ NOT ] LEAKPROOF
+IMMUTABLE | STABLE | VOLATILE
+[ NOT ] LEAKPROOF
 [ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER
+PARALLEL { UNSAFE | RESTRICTED | SAFE }
 COST execution_cost
 ROWS result_rows
 SET configuration_parameter { TO | = } { value | DEFAULT }
changedDROP TRANSFORM 
--- 9.5
+++ 9.6
@@ -1 +1 @@
-DROP TRANSFORM [ IF EXISTS ] FOR type_name LANGUAGE lang_name
+DROP TRANSFORM [ IF EXISTS ] FOR type_name LANGUAGE lang_name [ CASCADE | RESTRICT ]
changedALTER OPERATOR 
--- 9.5
+++ 9.6
@@ -3,3 +3,8 @@
 
 ALTER OPERATOR name ( { left_type | NONE } , { right_type | NONE } )
 SET SCHEMA new_schema
+
+ALTER OPERATOR name ( { left_type | NONE } , { right_type | NONE } )
+SET ( { RESTRICT = { res_proc | NONE }
+| JOIN = { join_proc | NONE }
+} [, ... ] )
changedCREATE GROUP 
--- 9.5
+++ 9.6
@@ -5,7 +5,6 @@
 SUPERUSER | NOSUPERUSER
 | CREATEDB | NOCREATEDB
 | CREATEROLE | NOCREATEROLE
-| CREATEUSER | NOCREATEUSER
 | INHERIT | NOINHERIT
 | LOGIN | NOLOGIN
 | REPLICATION | NOREPLICATION
changedDROP POLICY 
--- 9.5
+++ 9.6
@@ -1 +1 @@
-DROP POLICY [ IF EXISTS ] name ON table_name
+DROP POLICY [ IF EXISTS ] name ON table_name [ CASCADE | RESTRICT ]
changedCREATE ROLE 
--- 9.5
+++ 9.6
@@ -5,7 +5,6 @@
 SUPERUSER | NOSUPERUSER
 | CREATEDB | NOCREATEDB
 | CREATEROLE | NOCREATEROLE
-| CREATEUSER | NOCREATEUSER
 | INHERIT | NOINHERIT
 | LOGIN | NOLOGIN
 | REPLICATION | NOREPLICATION
changedALTER ROLE 
--- 9.5
+++ 9.6
@@ -5,7 +5,6 @@
 SUPERUSER | NOSUPERUSER
 | CREATEDB | NOCREATEDB
 | CREATEROLE | NOCREATEROLE
-| CREATEUSER | NOCREATEUSER
 | INHERIT | NOINHERIT
 | LOGIN | NOLOGIN
 | REPLICATION | NOREPLICATION
changedCREATE USER 
--- 9.5
+++ 9.6
@@ -5,7 +5,6 @@
 SUPERUSER | NOSUPERUSER
 | CREATEDB | NOCREATEDB
 | CREATEROLE | NOCREATEROLE
-| CREATEUSER | NOCREATEUSER
 | INHERIT | NOINHERIT
 | LOGIN | NOLOGIN
 | REPLICATION | NOREPLICATION
changedALTER USER 
--- 9.5
+++ 9.6
@@ -5,7 +5,6 @@
 SUPERUSER | NOSUPERUSER
 | CREATEDB | NOCREATEDB
 | CREATEROLE | NOCREATEROLE
-| CREATEUSER | NOCREATEUSER
 | INHERIT | NOINHERIT
 | LOGIN | NOLOGIN
 | REPLICATION | NOREPLICATION
changedALTER TRIGGER 
--- 9.5
+++ 9.6
@@ -1 +1,2 @@
 ALTER TRIGGER name ON table_name RENAME TO new_name
+ALTER TRIGGER name ON table_name DEPENDS ON EXTENSION extension_name
addedCREATE ACCESS METHOD 
--- 9.5
+++ 9.6
@@ -0,0 +1,3 @@
+CREATE ACCESS METHOD name
+TYPE access_method_type
+HANDLER handler_function
addedDROP ACCESS METHOD 
--- 9.5
+++ 9.6
@@ -0,0 +1 @@
+DROP ACCESS METHOD [ IF EXISTS ] name [ CASCADE | RESTRICT ]
changedCREATE EXTENSION 
--- 9.5
+++ 9.6
@@ -2,3 +2,4 @@
 [ WITH ] [ SCHEMA schema_name ]
 [ VERSION version ]
 [ FROM old_version ]
+[ CASCADE ]
changedALTER EXTENSION 
--- 9.5
+++ 9.6
@@ -4,6 +4,7 @@
 ALTER EXTENSION name DROP member_object
 where member_object is:
 
+ACCESS METHOD object_name |
 AGGREGATE aggregate_name ( aggregate_signature ) |
 CAST (source_type AS target_type) |
 COLLATION object_name |
changedVACUUM 
--- 9.5
+++ 9.6
@@ -1,3 +1,3 @@
-VACUUM [ ( { FULL | FREEZE | VERBOSE | ANALYZE } [, ...] ) ] [ table_name [ (column_name [, ...] ) ] ]
+VACUUM [ ( { FULL | FREEZE | VERBOSE | ANALYZE | DISABLE_PAGE_SKIPPING } [, ...] ) ] [ table_name [ (column_name [, ...] ) ] ]
 VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] [ table_name ]
 VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] ANALYZE [ table_name [ (column_name [, ...] ) ] ]
changedCOMMENT 
--- 9.5
+++ 9.6
@@ -1,5 +1,6 @@
 COMMENT ON
 {
+ACCESS METHOD object_name |
 AGGREGATE aggregate_name ( aggregate_signature ) |
 CAST (source_type AS target_type) |
 COLLATION object_name |