Sorry everyone! I just updated the dabo framework and you must have
fixed this because it works fine.
Jeff
Jeff Johnson
[EMAIL PROTECTED]
SanDC, Inc.
623-582-0323
Fax 623-869-0675
Jeff Johnson wrote:
> 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.
>
_______________________________________________
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]
