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
