# HG changeset patch
# User catherine@dellzilla
# Date 1229613659 18000
# Node ID 0351e977c245b754ccbe16c7c799b1cc7f48bf32
# Parent  c3dc0c6b6d8cba02d244cdce6502b6906717326d# Parent  ed46f2dba929b1fb74a7a3eac5cfbd9bb8dced00
folded in sessinfo fix

diff -r ed46f2dba929 -r 0351e977c245 sqlpython/sqlpyPlus.py
--- a/sqlpython/sqlpyPlus.py	Thu Dec 18 10:10:27 2008 -0500
+++ b/sqlpython/sqlpyPlus.py	Thu Dec 18 10:20:59 2008 -0500
@@ -660,11 +660,11 @@
             if len(parts) == 2:
                 owner, object_name = parts
                 object_type = self.select_scalar_list('SELECT object_type FROM all_objects WHERE owner = :owner AND object_name = :object_name',
-                                  {'owner': owner, 'object_name': object_name}
+                                  {'owner': owner, 'object_name': object_name.upper()}
                                   )[0]
             elif len(parts) == 1:
                 object_name = parts[0]
-                self.curs.execute(queries['resolve'], {'objName':object_name})
+                self.curs.execute(queries['resolve'], {'objName':object_name.upper()})
                 object_type, object_name, owner = self.curs.fetchone()
         except (TypeError, IndexError):
             print 'Could not resolve object %s.' % identifier
@@ -931,7 +931,7 @@
 
     def do_refs(self, arg):
         result = []
-        (type, owner, table_name) = self.resolve(arg)        
+        (type, owner, table_name) = self.resolve(arg.upper())        
         self.curs.execute("""SELECT constraint_name, r_owner, r_constraint_name 
                              FROM   all_constraints 
                              WHERE  constraint_type = 'R'