On Monday 02 April 2007 06:22, Ed Leafe wrote:
> 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
Sorry I just woke up. Lets start from the beginning.
What version of Postgres? We aren't supporting anything before 7.4. but that
is not the issue anyway.
Generally this type of error is due to a transaction (begin) having been
started and then a second begin is attempted before a commit. I note that
you are running from "DaboRuntime" are you mixing runtime and current svn by
chance?
The select statement is not firing (syntax is OK ) because there is a
transaction in process.
I guess I need to test on windows. While I'm testing could you take the time
to provide the a simple test case in words (can't attach files).
--
John Fabiani
_______________________________________________
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]
