oh, fixed when i set isolation level to 0. thanks anyway! damacy wrote: > thanks. i started to use psycopg. > > however, i have this error message and i don't quite get what it means. > > it says "DROP DATABASE cannot run inside a transaction block". > > does anyone have a clue? > > Tim Roberts wrote: > > "damacy" <[EMAIL PROTECTED]> wrote: > > > > >hi, there. i have this question which might sound quite stupid to some > > >people, but here we go anyway. > > > > > >i have written a python program which interacts with a postgresql > > >database. what it does is simply drops an existing database called > > >'mytempdb'. > > > > > >the code looks like below; > > > > > >link = subprocess.Popen(command, stdin = subprocess.PIPE, stdout = > > >subprocess.PIPE, shell = True) > > >link.communicate(password) > > >link.wait() > > > > > >where command looks like "psql -h 127.0.0.1 -U postgres -W -f filename" > > >and > > >filename is the name of the file which contains a single SQL command > > >which is "drop database mytempdb". > > > > hiaips is right. The right way to do this is to use a Postgres module. > > psycopg is my favorite, but there are several alternatives. > > > > import psycopg > > db = psycopg.connect( > > "dbname=template1 user=postgres password=%s" % password ) > > c = db.cursor() > > c.execute( "drop database mytempdb;" ) > > -- > > - Tim Roberts, [EMAIL PROTECTED] > > Providenza & Boekelheide, Inc.
-- http://mail.python.org/mailman/listinfo/python-list
