Strange Behaviour in Zope 2.10/PG9

Hi all

Using Psycopg2 in a Centos 6 / Zope 2.10 / Postgres 9
setup but getting some strange behaviour after upgrading from
Psycopg1/PG8.

In a python script if I run two methods that interact
with the db one after the other like this:

_context.insertteachers(firstname=firstname,surname=surname,name=name,title=title)_
_teacherid
= context.getlatestid()[0][0]_

..the insert doesn't work.

If I
comment out the second line so there is only one method, the insert
works. Any form of db interaction after the insert causes it to not
insert.

In Psycopg 1 I don't have this problem - I can insert then
select within one python script. If I can't find the solution to these
it's going to make it almost impossible to upgrade
because we use this
everywhere in our application i.e. inserts, then selects, then maybe
more inserts all within one script.

Any ideas?
Thanks
Rich