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 19 beta 3 → 20 devel

Browse PG 20 →

Development snapshot. These definitions may change before release.

0 added · 3 removed · 7 changed · 0 coverage changes. These are changes in the pinned reference snapshots.

changedALTER TABLE
--- 19 beta 3
+++ 20 devel
@@ -14,12 +14,6 @@
 ATTACH PARTITION partition_name { FOR VALUES partition_bound_spec | DEFAULT }
 ALTER TABLE [ IF EXISTS ] name
 DETACH PARTITION partition_name [ CONCURRENTLY | FINALIZE ]
-ALTER TABLE [ IF EXISTS ] name
-MERGE PARTITIONS (partition_name1, partition_name2 [, ...]) INTO partition_name
-ALTER TABLE [ IF EXISTS ] name
-SPLIT PARTITION partition_name INTO
-(PARTITION partition_name1 { FOR VALUES partition_bound_spec | DEFAULT },
-PARTITION partition_name2 { FOR VALUES partition_bound_spec | DEFAULT } [, ...])
 
 where action is one of:
 
changedCREATE AGGREGATE
--- 19 beta 3
+++ 20 devel
@@ -18,6 +18,7 @@
 [ , MFINALFUNC_MODIFY = { READ_ONLY | SHAREABLE | READ_WRITE } ]
 [ , MINITCOND = minitial_condition ]
 [ , SORTOP = sort_operator ]
+[ , SUPPORT = psfunc ]
 [ , PARALLEL = { SAFE | RESTRICTED | UNSAFE } ]
 )
 
@@ -30,6 +31,7 @@
 [ , FINALFUNC_EXTRA ]
 [ , FINALFUNC_MODIFY = { READ_ONLY | SHAREABLE | READ_WRITE } ]
 [ , INITCOND = initial_condition ]
+[ , SUPPORT = psfunc ]
 [ , PARALLEL = { SAFE | RESTRICTED | UNSAFE } ]
 [ , HYPOTHETICAL ]
 )
@@ -57,4 +59,5 @@
 [ , MFINALFUNC_MODIFY = { READ_ONLY | SHAREABLE | READ_WRITE } ]
 [ , MINITCOND = minitial_condition ]
 [ , SORTOP = sort_operator ]
+[ , SUPPORT = psfunc ]
 )
changedGRANT
--- 19 beta 3
+++ 20 devel
@@ -59,11 +59,6 @@
 TO role_specification [, ...] [ WITH GRANT OPTION ]
 [ GRANTED BY role_specification ]
 
-GRANT { SELECT | ALL [ PRIVILEGES ] }
-ON PROPERTY GRAPH graph_name [, ...]
-TO role_specification [, ...] [ WITH GRANT OPTION ]
-[ GRANTED BY role_specification ]
-
 GRANT { { CREATE | USAGE } [, ...] | ALL [ PRIVILEGES ] }
 ON SCHEMA schema_name [, ...]
 TO role_specification [, ...] [ WITH GRANT OPTION ]
changedREVOKE
--- 19 beta 3
+++ 20 devel
@@ -82,13 +82,6 @@
 [ CASCADE | RESTRICT ]
 
 REVOKE [ GRANT OPTION FOR ]
-{ SELECT | ALL [ PRIVILEGES ] }
-ON PROPERTY GRAPH graph_name [, ...]
-FROM role_specification [, ...]
-[ GRANTED BY role_specification ]
-[ CASCADE | RESTRICT ]
-
-REVOKE [ GRANT OPTION FOR ]
 { { CREATE | USAGE } [, ...] | ALL [ PRIVILEGES ] }
 ON SCHEMA schema_name [, ...]
 FROM role_specification [, ...]
changedALTER EXTENSION
--- 19 beta 3
+++ 20 devel
@@ -20,7 +20,6 @@
 OPERATOR FAMILY object_name USING index_method |
 [ PROCEDURAL ] LANGUAGE object_name |
 PROCEDURE procedure_name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] |
-PROPERTY GRAPH object_name |
 ROUTINE routine_name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] |
 SCHEMA object_name |
 SEQUENCE object_name |
changedSELECT
--- 19 beta 3
+++ 20 devel
@@ -25,7 +25,6 @@
 [ LATERAL ] function_name ( [ argument [, ...] ] ) AS ( column_definition [, ...] )
 [ LATERAL ] ROWS FROM( function_name ( [ argument [, ...] ] ) [ AS ( column_definition [, ...] ) ] [, ...] )
 [ WITH ORDINALITY ] [ [ AS ] alias [ ( column_alias [, ...] ) ] ]
-GRAPH_TABLE ( graph_name MATCH graph_pattern COLUMNS ( { expression [ AS name ] } [, ...] ) ) [ [ AS ] alias [ ( column_alias [, ...] ) ] ]
 from_item join_type from_item { ON join_condition | USING ( join_column [, ...] ) [ AS join_using_alias ] }
 from_item NATURAL join_type from_item
 from_item CROSS JOIN from_item
changedCOMMENT
--- 19 beta 3
+++ 20 devel
@@ -24,7 +24,6 @@
 POLICY policy_name ON table_name |
 [ PROCEDURAL ] LANGUAGE object_name |
 PROCEDURE procedure_name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] |
-PROPERTY GRAPH object_name
 PUBLICATION object_name |
 ROLE object_name |
 ROUTINE routine_name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] |
removedCREATE PROPERTY GRAPH
--- 19 beta 3
+++ 20 devel
@@ -1,20 +0,0 @@
-CREATE [ TEMP | TEMPORARY ] PROPERTY GRAPH name
-[ {VERTEX|NODE} TABLES ( vertex_table_definition [, ...] ) ]
-[ {EDGE|RELATIONSHIP} TABLES ( edge_table_definition [, ...] ) ]
-
-where vertex_table_definition is:
-vertex_table_name [ AS alias ] [ KEY ( column_name [, ...] ) ] [ element_table_label_and_properties ]
-
-and edge_table_definition is:
-edge_table_name [ AS alias ] [ KEY ( column_name [, ...] ) ]
-SOURCE [ KEY ( column_name [, ...] ) REFERENCES ] source_table [ ( column_name [, ...] ) ]
-DESTINATION [ KEY ( column_name [, ...] ) REFERENCES ] dest_table [ ( column_name [, ...] ) ]
-[ element_table_label_and_properties ]
-
-and element_table_label_and_properties is either:
-
-NO PROPERTIES | PROPERTIES ALL COLUMNS | PROPERTIES ( { expression [ AS property_name ] } [, ...] )
-
-or:
-
-{ { LABEL label_name | DEFAULT LABEL } [ NO PROPERTIES | PROPERTIES ALL COLUMNS | PROPERTIES ( { expression [ AS property_name ] } [, ...] ) ] } [...]
removedALTER PROPERTY GRAPH
--- 19 beta 3
+++ 20 devel
@@ -1,29 +0,0 @@
-ALTER PROPERTY GRAPH name ADD
-[ {VERTEX|NODE} TABLES ( vertex_table_definition [, ...] ) ]
-[ {EDGE|RELATIONSHIP} TABLES ( edge_table_definition [, ...] ) ]
-
-ALTER PROPERTY GRAPH name DROP
-{VERTEX|NODE} TABLES ( vertex_table_alias [, ...] ) [ CASCADE | RESTRICT ]
-
-ALTER PROPERTY GRAPH name DROP
-{EDGE|RELATIONSHIP} TABLES ( edge_table_alias [, ...] ) [ CASCADE | RESTRICT ]
-
-ALTER PROPERTY GRAPH name ALTER
-{VERTEX|NODE|EDGE|RELATIONSHIP} TABLE element_table_alias
-{ ADD LABEL label_name [ NO PROPERTIES | PROPERTIES ALL COLUMNS | PROPERTIES ( { expression [ AS property_name ] } [, ...] ) ] } [ ... ]
-
-ALTER PROPERTY GRAPH name ALTER
-{VERTEX|NODE|EDGE|RELATIONSHIP} TABLE element_table_alias
-DROP LABEL label_name [ CASCADE | RESTRICT ]
-
-ALTER PROPERTY GRAPH name ALTER
-{VERTEX|NODE|EDGE|RELATIONSHIP} TABLE element_table_alias
-ALTER LABEL label_name ADD PROPERTIES ( { expression [ AS property_name ] } [, ...] )
-
-ALTER PROPERTY GRAPH name ALTER
-{VERTEX|NODE|EDGE|RELATIONSHIP} TABLE element_table_alias
-ALTER LABEL label_name DROP PROPERTIES ( property_name [, ...] ) [ CASCADE | RESTRICT ]
-
-ALTER PROPERTY GRAPH name OWNER TO { new_owner | CURRENT_USER | SESSION_USER }
-ALTER PROPERTY GRAPH name RENAME TO new_name
-ALTER PROPERTY GRAPH [ IF EXISTS ] name SET SCHEMA new_schema
removedDROP PROPERTY GRAPH
--- 19 beta 3
+++ 20 devel
@@ -1 +0,0 @@
-DROP PROPERTY GRAPH [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]