# HG changeset patch
# User Catherine Devlin <catherine.devlin@gmail.com>
# Date 1289646466 18000
# Node ID ba3c6c6cc952e22432deea2c0adc60e9773eaa3b
# Parent  26bdff5abf785495877748faa7eb1861058c3f39
more pyscopg2 connection defaults

diff -r 26bdff5abf78 -r ba3c6c6cc952 sqlpython/connections.py
--- a/sqlpython/connections.py	Wed Nov 10 07:26:24 2010 -0500
+++ b/sqlpython/connections.py	Sat Nov 13 06:07:46 2010 -0500
@@ -346,9 +346,10 @@
     paramstyle = 'format'
     def set_defaults(self):
         self.port = os.getenv('PGPORT') or self.default_port
-        self.database = os.getenv('ORACLE_SID')
-        self.hostname = os.getenv('PGHOST') or 'localhost'
-        self.username = os.getenv('USER')
+        self.database = os.getenv('PGDATABASE')
+        self.hostname = os.getenv('PGHOST') or os.getenv('PGHOSTADDR') or 'localhost'
+        self.username = os.getenv('PGUSER') or os.getenv('USER')
+        self.password = os.getenv('PGPASSWORD')
     def connect(self):
         self.connection = psycopg2.connect(host = self.hostname, user = self.username, 
                                  password = self.password, database = self.database,