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.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.