Re: BUG #4087: table creation problem using python - Mailing list pgsql-bugs

From ITAGAKI Takahiro
Subject Re: BUG #4087: table creation problem using python
Date
Msg-id 20080403193154.6E2A.52131E4D@oss.ntt.co.jp
Whole thread Raw
In response to BUG #4087: table creation problem using python  ("jitendra" <teri.jitendra@gmail.com>)
List pgsql-bugs
"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

pgsql-bugs by date:

Previous
From: Zdenek Kotala
Date:
Subject: Re: BUG #4084: Some DST timezones switche to summer time (one week) later
Next
From: Jeff Dwyer
Date:
Subject: Re: BUG #4085: No implicit cast after coalesce