From 7e5bdceb5bedd479ec0aea01d0e86ad06704fe61 Mon Sep 17 00:00:00 2001 From: asimfarooq5 Date: Tue, 16 Aug 2022 18:31:03 +0500 Subject: [PATCH] Remove TIMESTAMPTZ --- lib/sqlalchemy/dialects/postgresql/base.py | 8 -------- test/dialect/postgresql/test_types.py | 1 + 2 files changed, 1 insertion(+), 8 deletions(-) diff --git a/lib/sqlalchemy/dialects/postgresql/base.py b/lib/sqlalchemy/dialects/postgresql/base.py index d867402273..90639a4817 100644 --- a/lib/sqlalchemy/dialects/postgresql/base.py +++ b/lib/sqlalchemy/dialects/postgresql/base.py @@ -1522,10 +1522,6 @@ class MACADDR8(MACADDR): __visit_name__ = "MACADDR8" -class TIMESTAMPTZ(TIMESTAMP): - __visit_name__ = "TIMESTAMPTZ" - - ischema_names = { "_array": _array.ARRAY, "hstore": _hstore.HSTORE, @@ -1566,7 +1562,6 @@ ischema_names = { "regclass": REGCLASS, "double precision": DOUBLE_PRECISION, "timestamp": TIMESTAMP, - "timestampz": TIMESTAMPZ, "timestamp with time zone": TIMESTAMP, "timestamp without time zone": TIMESTAMP, "time with time zone": TIME, @@ -2468,9 +2463,6 @@ class PGTypeCompiler(compiler.GenericTypeCompiler): (type_.timezone and "WITH" or "WITHOUT") + " TIME ZONE", ) - def visit_TIMESTAMPTZ(self, type_, **kw): - return "TIMESTAMPTZ" - def visit_TIME(self, type_, **kw): return "TIME%s %s" % ( "(%d)" % type_.precision diff --git a/test/dialect/postgresql/test_types.py b/test/dialect/postgresql/test_types.py index b4c19238d3..67e05e3cb7 100644 --- a/test/dialect/postgresql/test_types.py +++ b/test/dialect/postgresql/test_types.py @@ -2953,6 +2953,7 @@ class SpecialTypesTest(fixtures.TablesTest, ComparesTables): Column("bitstring", postgresql.BIT(4)), Column("addr", postgresql.INET), Column("addr2", postgresql.MACADDR), + Column("addr4", postgresql.MACADDR8), Column("price", postgresql.MONEY), Column("addr3", postgresql.CIDR), Column("doubleprec", postgresql.DOUBLE_PRECISION), -- 2.47.3