# HG changeset patch
# User catherine@dellzilla
# Date 1229613272 18000
# Node ID c3dc0c6b6d8cba02d244cdce6502b6906717326d
# Parent  1c3df79fd088f898f01bcb4ddfb71066c2bc1dc1
synch

diff -r 1c3df79fd088 -r c3dc0c6b6d8c sqlpython/sqlpyPlus.py
--- a/sqlpython/sqlpyPlus.py	Fri Dec 12 10:14:09 2008 -0500
+++ b/sqlpython/sqlpyPlus.py	Thu Dec 18 10:14:32 2008 -0500
@@ -655,11 +655,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
@@ -929,7 +929,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'