SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-10-2008, 11:15 AM
| ||||
| ||||
 BUG #4087: table creation problem using python The following bug has been logged online: Bug reference: 4087 Logged by: jitendra Email address: teri.jitendra@gmail.com PostgreSQL version: 8.1.4 Operating system: rhel 5 Description: table creation problem using python Details: hi, I'm jitendra from delhi(India),I've a problem with table creation using python....script executed but there's nothing happened. the program written in python is... import psycopg2 try: print "Waiting for Connection........." conn = psycopg2.connect("dbname='jitu' user='postgres' host='localhost' password=''") print "connection established........" except: print "I am unable to connect to the database" try: print "trying to execute query....." cur = conn.cursor() cur.execute("create table ph2 (nm varchar, ph varchar)") print "table created....." except: print "Sorry, unable to create table....." try: cur.close () conn.close () print "connection closed..." except: "problem........." It runs without any error but when I'm trying to see table ...such as.. "select * from tablename"..it flashes an error.. error:relaton ph2 does not not exit. plz..help me... -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs      |
|
04-10-2008, 11:15 AM
| ||||
| ||||
| Re: BUG #4087: table creation problem using python "jitendra" <teri.jitendra@gmail.com> wrote: > I'm jitendra from delhi(India),I've a problem with table creation using > python....script executed but there's nothing happened. > the program written in python is... You need to add conn.commit() here: > cur.execute("create table ph2 (nm varchar, ph varchar)") conn.commit() > print "table created....." An auto-commit feature is initially off on databases supporting transactions. See http://www.python.org/dev/peps/pep-0249/ . Regards, --- ITAGAKI Takahiro NTT Open Source Software Center -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs |
 |
« 335 http://bloqueadorgsm.vilabol.uol.com.br - Bloqueador gps gsm -localizador gps gsm - sem mensalidade - alarme automotivo , alarme paracarros 3357682152366685811713028
|
BUG #4079: libpq.dll very slow (unusable) »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
All times are GMT. The time now is 04:15 PM.
