Postgres Pro
Downloads
Home   >   mailing lists

Thread: pypgsql 'create database' problem

pypgsql 'create database' problem

From
rdacker@pacbell.net (rdack)
Date:
from python using PgSQL.
i get:
" libpq.OperationalError: ERROR:  CREATE DATABASE: may not be called
in a transaction block"

in a python script i do :
db = PgSQL.connect(database='template1')
cur=db.cursor()
cur.execute("create database tt2")
cur.close()
del db, cur

how does one not be in a transaction block?
what is the correct way to create a db?

Re: pypgsql 'create database' problem

From
rdacker@pacbell.net (rdack)
Date:
rdacker@pacbell.net (rdack) wrote in message news:<644f6688.0110011048.51982136@posting.google.com>...
> from python using PgSQL.
> i get:
> " libpq.OperationalError: ERROR:  CREATE DATABASE: may not be called
> in a transaction block"
>
> in a python script i do :
> db = PgSQL.connect(database='template1')
> cur=db.cursor()
> cur.execute("create database tt2")
> cur.close()
> del db, cur
>
> how does one not be in a transaction block?
> what is the correct way to create a db?

answer is to use libpq module. low level interface has method to
execute queries without wrapping in a transaction:

import libpq
db = libpq.PQconnectdb('dbname=%s' % db_name)
db.query('create database %s' % tbl_name)

Re: pypgsql 'create database' problem

From
bga@bajor.mug.org (Billy G. Allie)
Date:
On 1 Oct 2001 11:48:31 -0700, rdack <rdacker@pacbell.net> wrote:
>from python using PgSQL.
>i get:
>" libpq.OperationalError: ERROR:  CREATE DATABASE: may not be called
>in a transaction block"
>
>in a python script i do :
>db = PgSQL.connect(database='template1')
>cur=db.cursor()
>cur.execute("create database tt2")
>cur.close()
>del db, cur
>
>how does one not be in a transaction block?
>what is the correct way to create a db?

Turn on autocommit.  For example:

db = PgSQL.connect(database='template1')
db.autocommit = 1 # You must turn on autocommit before creating any cursor.
cur = db.cursor()
cur.execute("create database tt2")
cur.close()
del db, cur

--
____       | Billy G. Allie    | Domain....: Bill.Allie@mug.org
|  /|      | 7436 Hartwell     | MSN.......: B_G_Allie@email.msn.com
|-/-|----- | Dearborn, MI 48126|
|/  |LLIE  | (313) 582-1540    |

Error Codes?

From
Fran Fabrizio
Date:
I'm a bit confused about the current state of error codes in Pg.  The docs and
the mailing list archives seem to indicate that this is a TODO item, however,
at least when using Perl with DBD::Pg, when I call $db->err() or examine
$DBI::err I get a number back.  For instance, 7 if I try to insert too many
columns into a row, and a 1 if the connection fails.  What's the scoop, and if
error codes really do exist, is there a list of such codes?

Thanks,
Fran