On Tue, May 02, 2006 at 12:13:35PM -0400, D'Arcy J.M. Cain wrote: > On Tue, 2 May 2006 15:20:23 +0100 > Mark Lee <[EMAIL PROTECTED]> wrote: > > > I'm having trouble with the following piece of code. This is just a > > stipped down example but persuaded me that the problem I'm getting lay > > within the pygres module. When this is run, it would appear the "now()" > > is evaluated at statement preparation or initial execution time. For > > each successive call to execute it would appear that now() is not > > re-evaluated and remains the same as the first time through the loop. > > Not sure if this would be called a PyGreSQL issue or a PostgreSQL issue > but the system is acting correctly as far as it goes. All you need to > do here is add "BEGIN WORK" and "END WORK" statements around the > query. Otherwise every query is in the same transaction and the time > inside a transaction has to be consistent otherwise really strange > things can happen.
Thanks very much. Just spend all morning trying to get this to work. > > -- > D'Arcy J.M. Cain > PyGreSQL Development Group > http://www.PyGreSQL.org > _______________________________________________ PyGreSQL mailing list [email protected] http://mailman.vex.net/mailman/listinfo/pygresql
