aboutsummaryrefslogtreecommitdiffstats
path: root/python/db.py
diff options
context:
space:
mode:
Diffstat (limited to 'python/db.py')
-rw-r--r--python/db.py5
1 files changed, 3 insertions, 2 deletions
diff --git a/python/db.py b/python/db.py
index 64448ce7..bf379ff7 100644
--- a/python/db.py
+++ b/python/db.py
@@ -42,7 +42,8 @@ def dbconn(dbname, cursor_factory=DictCursor):
return psycopg2.connect(database=dbname,
user=user_name,
host=os.environ.get("PGHOST", "debian"),
- cursor_factory=cursor_factory)
+ cursor_factory=cursor_factory,
+ options="-c extra_float_digits=3")
def dbengine(dbname):
if dbname in ['rmbs_model', 'corelogic']:
@@ -59,7 +60,7 @@ def dbengine(dbname):
host=os.environ.get("PGHOST", "debian"),
username=user_name,
database=dbname)
- return create_engine(uri, paramstyle="format")
+ return create_engine(uri, paramstyle="format", connect_args={'options':"-c extra_float_digits=3"})
def with_connection(dbname):
def decorator(f):