I have traced my problems to this code:
def getTables(self, cursor, includeSystemTables=False):
# jfcs 11/01/04 assumed public schema
#tempCursor.execute("select tablename from pg_tables where
schemaname
= 'public'")
# jfcs 01/22/07 added below to support schema
# thanks to Phillip J. Allen who provided a Select state that
filtered
for the user name
if includeSystemTables:
sqltablestr = (("SELECT schemaname || '.' || tablename
AS tablename
FROM pg_tables WHERE has_table_privilege('%s', schemaname || '.' ||
tablename, 'SELECT')") % self.conn_user)
else:
sqltablestr = (("SELECT schemaname || '.' || tablename
AS tablename
FROM pg_tables WHERE (schemaname not like 'pg_%s' and schemaname not
like 'information%s') and has_table_privilege('%s', schemaname || '.' ||
tablename, 'SELECT')") % ('%','%',self.conn_user))
cursor.execute(sqltablestr)
rs = cursor.getDataSet()
tables = []
for record in rs:
tables.append(record[0])
return tuple(tables)
"tables" is empty. I deleted the database and re-created it. There are
5 user tables in it.
--
Jeff
Jeff Johnson
[EMAIL PROTECTED]
SanDC, Inc.
623-582-0323
Fax 623-869-0675
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/dabo-users/[EMAIL PROTECTED]
