From f5cfa86e941f80fa9a727ca8cf9e20614f6cb0fd Mon Sep 17 00:00:00 2001
From: Mike Bayer <mike_mp@zzzcomputing.com>
Date: Wed, 11 Oct 2006 19:48:52 +0000
Subject: [PATCH] added PGBigInteger type

---
 lib/sqlalchemy/databases/postgres.py | 5 ++++-
 1 file changed, 4 insertions(+), 1 deletion(-)

diff --git a/lib/sqlalchemy/databases/postgres.py b/lib/sqlalchemy/databases/postgres.py
index e052fe8c00..914df50f78 100644
--- a/lib/sqlalchemy/databases/postgres.py
+++ b/lib/sqlalchemy/databases/postgres.py
@@ -44,6 +44,9 @@ class PGInteger(sqltypes.Integer):
 class PGSmallInteger(sqltypes.Smallinteger):
     def get_col_spec(self):
         return "SMALLINT"
+class PGBigInteger(sqltypes.Integer):
+    def get_col_spec(self):
+        return "BIGINT"
 class PG2DateTime(sqltypes.DateTime):
     def get_col_spec(self):
         return "TIMESTAMP " + (self.timezone and "WITH" or "WITHOUT") + " TIME ZONE"
@@ -144,7 +147,7 @@ pg1_colspecs.update({
 
 pg2_ischema_names = {
     'integer' : PGInteger,
-    'bigint' : PGInteger,
+    'bigint' : PGBigInteger,
     'smallint' : PGSmallInteger,
     'character varying' : PGString,
     'character' : PGChar,
-- 
2.47.2