Not commit
Antonio Prado <antonio-m7WKv7+duuT/[email protected]>
| Newsgroups | gmane.comp.python.db.psycopg.devel |
|---|---|
| Message-ID | <1233255125.2184.30.camel@localhost> |
In Python 2.4
The cursor B does not view / updated insert in A.
Why ??
import psycopg
A = psycopg.connect("host=%s dbname=%s user=%s" %(host, dbname,
user))
B = psycopg.connect("host=%s dbname=%s user=%s" %(host, dbname,
user))
A.cursor.execute("INSERT abc INTO tabela")
A.commit()
A.cursor.execute("SELECT abc FROM tabela")
result = B.cursor.fetchall()
result [abc]
B.cursor.execute("SELECT abc FROM tabela")
result = B.cursor.fetchall()
result []
Register not found.
Thanks
Antonio.