On Thu, 2008-06-19 at 19:12 +0100, Garry Saddington wrote: > On Thursday 19 June 2008 18:52, Adrian Klaver wrote: > > -------------- Original message ---------------------- > > From: Garry Saddington <[EMAIL PROTECTED]>
> > Seems like a transaction with no commit. Basically along as the session is > > active the data is there but once the session is closed the data does not > > persist. > > > Makes sense but what is to blame? If this is indeed the problem, it is likely a lack of an explicit commit to your connect object within zope. In pysocpg2 unless you set your isolation level to something different it automatically creates a new transaction for your session so if you don't do conn.commit() everything you do will be rolled back. Joshua D. Drake > Regards > Garry > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
