On Apr 2, 2007, at 9:07 AM, [EMAIL PROTECTED] wrote:
> Again, nothing seems to happen.
Yes, something did happen: an error! That's what the traceback is: a
representation of the steps that led to the error, along with the
error itself:
File "c:\DaboRuntime\dabo\db\dbPostgreSQL.py", line 66, in getTables
tempCursor.execute(sqltablestr)
ProgrammingError: current transaction is aborted, commands ignored
until end of
transaction block
Looking at dbPostgreSQL.py, just before line 66, I see this
assignment for sqltablestr:
sqltablestr = (("SELECT schemaname || '.' || tablename AS tablename
FROM pg_tables WHERE has_table_privilege('%s', schemaname || '.' ||
tablename, 'SELECT')") % self.conn_user)
I don't know enough about the SQL syntax for Postgres to figure out
what could possibly be wrong with this. Perhaps a pg user (John?)
could help out?
> What did I miss this time?
AFAIK, nothing. Looks like an issue with how Dabo is interacting
with Postgres.
-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com
_______________________________________________
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]