Re: [Ruby-DBI-devel] Performing SQL actions that can't be done inside of a transaction...

[Michael N. <uu...@rz...>]

Sean Chittenden wrote:
> > Have you tried the following? 
> > 
> >   dbh['AutoCommit'] = false
> > 
> > If this was set to false, no commit should be issued automatically!
> 
> Ehh...  yes it does.
> 
> And in the error log:
> 
> 2002-09-18 01:33:54 LOG:  query: select getdatabaseencoding()
> 2002-09-18 01:33:54 LOG:  query: SELECT typname, typelem FROM pg_type
> 2002-09-18 01:33:54 LOG:  query: SELECT datname FROM pg_database WHERE datname = 'foo'
> 2002-09-18 01:33:54 LOG:  query: BEGIN WORK
> 2002-09-18 01:33:54 LOG:  query: DROP DATABASE foo
> 2002-09-18 01:33:54 ERROR:  DROP DATABASE: may not be called in a transaction block
> 2002-09-18 01:33:54 LOG:  statement: DROP DATABASE foo

Could you set in method Database#initialize (Pg.rb), @debug_level to 3 and run the example
again. What's now the output on stdout?


Regards,

  Michael