Mercurial > sqlpython

changeset 310:c897add05eb1

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
fixed grep bug
author catherine@Elli.myhome.westell.com
date Thu, 26 Mar 2009 10:21:31 -0400
parents 0d16630d8e04
children 38ac0fbb2b63
files sqlpython/sqlpyPlus.py
diffstat 1 files changed, 4 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/sqlpython/sqlpyPlus.py	Wed Mar 25 18:42:22 2009 -0400
+++ b/sqlpython/sqlpyPlus.py	Thu Mar 26 10:21:31 2009 -0400
@@ -1435,8 +1435,10 @@
         targets = [] 
         for target in targetnames:
             if '*' in target:
-                self._execute("SELECT owner, table_name FROM all_tables WHERE table_name LIKE '%s'%s" %
-                                  (target.upper().replace('*','%')), arg.terminator)
+                self._execute("""SELECT owner, object_name FROM all_objects 
+                                 WHERE object_type IN ('TABLE','VIEW')
+                                 AND object_name LIKE '%s'%s""" %
+                              (target.upper().replace('*','%'), arg.parsed.terminator))
                 for row in self.curs:
                     targets.append('%s.%s' % row)
             else: