Simen Haugen wrote: > The problem is when the database has been updated by external sources... > When I then run this code again, I get the same result, and not the > updated values. If I restart the application it of course gets the > correct result again.
... > Start a transaction for a select statement? Isn't that a bit of a weird > workaround as I'm not modifying the database? > I don't use postgres. But if your second select is in the same transaction as the first and the db data was changed from other connections then you should not see the change. At least that is how it works in firebird. Uwe _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/dabo-users/[EMAIL PROTECTED]
