[Pypgsql-users] Re: "create database" not allowed within transaction

[J. M. C. <jm...@do...>]

Here's one way to do it, though kludgey:
    cursor.execute('commit') # note that this closes our transaction, so 
that the following works:
    cursor.execute('create database blah')

J. Michael Caine wrote:

> If I attempt to:
>    cursor.execute('create database blah...')
> I get the following error:
>    libpq OperationalError:  ERROR: CREATE DATABASE cannot run inside a 
> transaction block
>
> How can I accomplish my objective?
>