I recommand you using psycopg2 adapter instead of pg8000 that is not as well tested...
Richard On Wed, Oct 2, 2013 at 10:11 AM, Richard Vézina <[email protected] > wrote: > See my answer to your precedent question!! > > Richard > > > On Wed, Oct 2, 2013 at 8:57 AM, at <[email protected]> wrote: > >> Hi, >> >> I am getting following error message while trying to run statements: >> db0 = DAL('postgres://adminuser:testing@localhost/postgres') >> result=db0.executesql('create database mydb owner user1;') >> >> >> <class 'gluon.contrib.pg8000.errors.ProgrammingError'> ('ERROR', '25001', >> 'CREATE DATABASE cannot run inside a transaction block') >> Can someone help pls. >> Can we create a postgres database within a web2py app? >> >> Thanks >> >> -- >> Resources: >> - http://web2py.com >> - http://web2py.com/book (Documentation) >> - http://github.com/web2py/web2py (Source code) >> - https://code.google.com/p/web2py/issues/list (Report Issues) >> --- >> You received this message because you are subscribed to the Google Groups >> "web2py-users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> For more options, visit https://groups.google.com/groups/opt_out. >> > > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
