summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/dialects/postgresql
diff options
context:
space:
mode:
authorFederico Caselli <cfederico87@gmail.com>2023-04-12 23:17:38 +0200
committerFederico Caselli <cfederico87@gmail.com>2023-04-12 23:17:38 +0200
commitee7e49964fcf13ed0f5a3541b81f00302a9db29a (patch)
tree71d6b1cbfc8705658e2cfd8de56b817ca28fd67e /lib/sqlalchemy/dialects/postgresql
parent107ec58bdfbcbb09f40d92590f8197ffa683a925 (diff)
downloadsqlalchemy-ee7e49964fcf13ed0f5a3541b81f00302a9db29a.tar.gz
Remove old versionadded and versionchanged
Removed versionadded and versionchanged for version prior to 1.2 since they are no longer useful. Change-Id: I5c53d1188bc5fec3ab4be39ef761650ed8fa6d3e
Diffstat (limited to 'lib/sqlalchemy/dialects/postgresql')
-rw-r--r--lib/sqlalchemy/dialects/postgresql/array.py7
-rw-r--r--lib/sqlalchemy/dialects/postgresql/base.py25
-rw-r--r--lib/sqlalchemy/dialects/postgresql/dml.py6
-rw-r--r--lib/sqlalchemy/dialects/postgresql/ext.py4
-rw-r--r--lib/sqlalchemy/dialects/postgresql/hstore.py2
-rw-r--r--lib/sqlalchemy/dialects/postgresql/json.py16
-rw-r--r--lib/sqlalchemy/dialects/postgresql/named_types.py8
-rw-r--r--lib/sqlalchemy/dialects/postgresql/psycopg2cffi.py2
-rw-r--r--lib/sqlalchemy/dialects/postgresql/types.py8
9 files changed, 1 insertions, 77 deletions
diff --git a/lib/sqlalchemy/dialects/postgresql/array.py b/lib/sqlalchemy/dialects/postgresql/array.py
index 5b53916c6..ba53bf665 100644
--- a/lib/sqlalchemy/dialects/postgresql/array.py
+++ b/lib/sqlalchemy/dialects/postgresql/array.py
@@ -163,12 +163,8 @@ OVERLAP = operators.custom_op("&&", precedence=5, is_comparison=True)
class ARRAY(sqltypes.ARRAY):
-
"""PostgreSQL ARRAY type.
- .. versionchanged:: 1.1 The :class:`_postgresql.ARRAY` type is now
- a subclass of the core :class:`_types.ARRAY` type.
-
The :class:`_postgresql.ARRAY` type is constructed in the same way
as the core :class:`_types.ARRAY` type; a member type is required, and a
number of dimensions is recommended if the type is to be used for more
@@ -308,9 +304,6 @@ class ARRAY(sqltypes.ARRAY):
a value of one will be added to all index values before passing
to the database.
- .. versionadded:: 0.9.5
-
-
"""
if isinstance(item_type, ARRAY):
raise ValueError(
diff --git a/lib/sqlalchemy/dialects/postgresql/base.py b/lib/sqlalchemy/dialects/postgresql/base.py
index 4d299b918..1ce5600e1 100644
--- a/lib/sqlalchemy/dialects/postgresql/base.py
+++ b/lib/sqlalchemy/dialects/postgresql/base.py
@@ -551,8 +551,6 @@ and :meth:`~.postgresql.Insert.on_conflict_do_nothing`:
{printsql}INSERT INTO my_table (id, data) VALUES (%(id)s, %(data)s)
ON CONFLICT ON CONSTRAINT pk_my_table DO UPDATE SET data = %(param_1)s
-.. versionadded:: 1.1
-
.. seealso::
`INSERT .. ON CONFLICT
@@ -1021,16 +1019,12 @@ keyword argument::
Index('my_index', my_table.c.data, postgresql_with={"fillfactor": 50})
-.. versionadded:: 1.0.6
-
PostgreSQL allows to define the tablespace in which to create the index.
The tablespace can be specified on :class:`.Index` using the
``postgresql_tablespace`` keyword argument::
Index('my_index', my_table.c.data, postgresql_tablespace='my_tablespace')
-.. versionadded:: 1.1
-
Note that the same option is available on :class:`_schema.Table` as well.
.. _postgresql_index_concurrently:
@@ -1055,11 +1049,6 @@ a connection-less dialect, it will emit::
DROP INDEX CONCURRENTLY test_idx1
-.. versionadded:: 1.1 support for CONCURRENTLY on DROP INDEX. The
- CONCURRENTLY keyword is now only emitted if a high enough version
- of PostgreSQL is detected on the connection (or for a connection-less
- dialect).
-
When using CONCURRENTLY, the PostgreSQL database requires that the statement
be invoked outside of a transaction block. The Python DBAPI enforces that
even for a single statement, a transaction is present, so to use this
@@ -1098,14 +1087,6 @@ in :attr:`_schema.Table.indexes` when it is detected as mirroring a
:class:`.UniqueConstraint` in the :attr:`_schema.Table.constraints` collection
.
-.. versionchanged:: 1.0.0 - :class:`_schema.Table` reflection now includes
- :class:`.UniqueConstraint` objects present in the
- :attr:`_schema.Table.constraints`
- collection; the PostgreSQL backend will no longer include a "mirrored"
- :class:`.Index` construct in :attr:`_schema.Table.indexes`
- if it is detected
- as corresponding to a unique constraint.
-
Special Reflection Options
--------------------------
@@ -1155,8 +1136,6 @@ dialect in conjunction with the :class:`_schema.Table` construct:
Table("some_table", metadata, ..., postgresql_inherits=("t1", "t2", ...))
- .. versionadded:: 1.0.0
-
* ``PARTITION BY``::
Table("some_table", metadata, ...,
@@ -2785,8 +2764,6 @@ class PGInspector(reflection.Inspector):
(typically 'public') is used. May also be set to ``'*'`` to
indicate load enums for all schemas.
- .. versionadded:: 1.0.0
-
"""
with self._operation_context() as conn:
return self.dialect._load_enums(
@@ -2803,8 +2780,6 @@ class PGInspector(reflection.Inspector):
except that the list is limited to those tables that report a
``relkind`` value of ``f``.
- .. versionadded:: 1.0.0
-
"""
with self._operation_context() as conn:
return self.dialect._get_foreign_table_names(
diff --git a/lib/sqlalchemy/dialects/postgresql/dml.py b/lib/sqlalchemy/dialects/postgresql/dml.py
index a1807d7b3..e17b87d1e 100644
--- a/lib/sqlalchemy/dialects/postgresql/dml.py
+++ b/lib/sqlalchemy/dialects/postgresql/dml.py
@@ -51,8 +51,6 @@ class Insert(StandardInsert):
The :class:`_postgresql.Insert` object is created using the
:func:`sqlalchemy.dialects.postgresql.insert` function.
- .. versionadded:: 1.1
-
"""
stringify_dialect = "postgresql"
@@ -148,8 +146,6 @@ class Insert(StandardInsert):
not meeting the ``WHERE`` condition will not be updated
(effectively a ``DO NOTHING`` for those rows).
- .. versionadded:: 1.1
-
.. seealso::
@@ -188,8 +184,6 @@ class Insert(StandardInsert):
Additional WHERE criterion that can be used to infer a
conditional target index.
- .. versionadded:: 1.1
-
.. seealso::
:ref:`postgresql_insert_on_conflict`
diff --git a/lib/sqlalchemy/dialects/postgresql/ext.py b/lib/sqlalchemy/dialects/postgresql/ext.py
index 8c09eddda..c79e90034 100644
--- a/lib/sqlalchemy/dialects/postgresql/ext.py
+++ b/lib/sqlalchemy/dialects/postgresql/ext.py
@@ -54,8 +54,6 @@ class aggregate_order_by(expression.ColumnElement):
SELECT string_agg(a, ',' ORDER BY a) FROM table;
- .. versionadded:: 1.1
-
.. versionchanged:: 1.2.13 - the ORDER BY argument may be multiple terms
.. seealso::
@@ -288,8 +286,6 @@ def array_agg(*arg, **kw):
the plain :class:`_types.ARRAY`, unless an explicit ``type_``
is passed.
- .. versionadded:: 1.1
-
"""
kw["_default_array_type"] = ARRAY
return functions.func.array_agg(*arg, **kw)
diff --git a/lib/sqlalchemy/dialects/postgresql/hstore.py b/lib/sqlalchemy/dialects/postgresql/hstore.py
index 7f83f3113..dc7e4d40d 100644
--- a/lib/sqlalchemy/dialects/postgresql/hstore.py
+++ b/lib/sqlalchemy/dialects/postgresql/hstore.py
@@ -147,8 +147,6 @@ class HSTORE(sqltypes.Indexable, sqltypes.Concatenable, sqltypes.TypeEngine):
:param text_type: the type that should be used for indexed values.
Defaults to :class:`_types.Text`.
- .. versionadded:: 1.1.0
-
"""
if text_type is not None:
self.text_type = text_type
diff --git a/lib/sqlalchemy/dialects/postgresql/json.py b/lib/sqlalchemy/dialects/postgresql/json.py
index 9c2936006..232f05804 100644
--- a/lib/sqlalchemy/dialects/postgresql/json.py
+++ b/lib/sqlalchemy/dialects/postgresql/json.py
@@ -183,12 +183,6 @@ class JSON(sqltypes.JSON):
data_table.c.data[('key_1', 'key_2', 5, ..., 'key_n')].astext == 'some value'
- .. versionchanged:: 1.1 The :meth:`_expression.ColumnElement.cast`
- operator on
- JSON objects now requires that the :attr:`.JSON.Comparator.astext`
- modifier be called explicitly, if the cast works only from a textual
- string.
-
Index operations return an expression object whose type defaults to
:class:`_types.JSON` by default,
so that further JSON-oriented instructions
@@ -213,9 +207,6 @@ class JSON(sqltypes.JSON):
:class:`_postgresql.JSONB`
- .. versionchanged:: 1.1 :class:`_postgresql.JSON` is now a PostgreSQL-
- specific specialization of the new :class:`_types.JSON` type.
-
""" # noqa
astext_type = sqltypes.Text()
@@ -231,9 +222,6 @@ class JSON(sqltypes.JSON):
from sqlalchemy import null
conn.execute(table.insert(), data=null())
- .. versionchanged:: 0.9.8 - Added ``none_as_null``, and :func:`.null`
- is now supported in order to persist a NULL value.
-
.. seealso::
:attr:`_types.JSON.NULL`
@@ -242,8 +230,6 @@ class JSON(sqltypes.JSON):
:attr:`.JSON.Comparator.astext`
accessor on indexed attributes. Defaults to :class:`_types.Text`.
- .. versionadded:: 1.1
-
"""
super().__init__(none_as_null=none_as_null)
if astext_type is not None:
@@ -323,8 +309,6 @@ class JSONB(JSON):
in the same way that ``psycopg2.extras.register_default_json`` is used
to register these handlers with the json type.
- .. versionadded:: 0.9.7
-
.. seealso::
:class:`_types.JSON`
diff --git a/lib/sqlalchemy/dialects/postgresql/named_types.py b/lib/sqlalchemy/dialects/postgresql/named_types.py
index b0427b569..92aba6f63 100644
--- a/lib/sqlalchemy/dialects/postgresql/named_types.py
+++ b/lib/sqlalchemy/dialects/postgresql/named_types.py
@@ -231,14 +231,6 @@ class ENUM(NamedType, sqltypes.NativeForEmulated, sqltypes.Enum):
my_enum.create(engine)
my_enum.drop(engine)
- .. versionchanged:: 1.0.0 The PostgreSQL :class:`_postgresql.ENUM` type
- now behaves more strictly with regards to CREATE/DROP. A metadata-level
- ENUM type will only be created and dropped at the metadata level,
- not the table level, with the exception of
- ``table.create(checkfirst=True)``.
- The ``table.drop()`` call will now emit a DROP TYPE for a table-level
- enumerated type.
-
"""
native_enum = True
diff --git a/lib/sqlalchemy/dialects/postgresql/psycopg2cffi.py b/lib/sqlalchemy/dialects/postgresql/psycopg2cffi.py
index 8a69e1b85..211432c6d 100644
--- a/lib/sqlalchemy/dialects/postgresql/psycopg2cffi.py
+++ b/lib/sqlalchemy/dialects/postgresql/psycopg2cffi.py
@@ -17,8 +17,6 @@ r"""
layer. This makes it suitable for use in e.g. PyPy. Documentation
is as per ``psycopg2``.
-.. versionadded:: 1.0.0
-
.. seealso::
:mod:`sqlalchemy.dialects.postgresql.psycopg2`
diff --git a/lib/sqlalchemy/dialects/postgresql/types.py b/lib/sqlalchemy/dialects/postgresql/types.py
index a6b82044b..edab23935 100644
--- a/lib/sqlalchemy/dialects/postgresql/types.py
+++ b/lib/sqlalchemy/dialects/postgresql/types.py
@@ -102,11 +102,7 @@ class MONEY(sqltypes.TypeEngine[str]):
class OID(sqltypes.TypeEngine[int]):
- """Provide the PostgreSQL OID type.
-
- .. versionadded:: 0.9.5
-
- """
+ """Provide the PostgreSQL OID type."""
__visit_name__ = "OID"
@@ -246,8 +242,6 @@ class TSVECTOR(sqltypes.TypeEngine[str]):
It can be used to do full text queries on natural language
documents.
- .. versionadded:: 0.9.0
-
.. seealso::
:ref:`postgresql_match`