On Tue, Jun 16, 2009 at 11:01 AM, Longtime<[email protected]> wrote:
> When I inserting the present time data with a NOW( ) function > ex: > the NOW( ) function is contained in the query, > or the default value of a table is being set to 'NOW' pgpool-II sends the query to both nodes and makes sure that both were executed properly. pgpool-II won't alter the SQL query, therefore that NOW() function will be executed on each node and the affected datetime field will receive that value (e.g. 2009-06-16 22:10:00:00 GMT). > That values could be replicated? pgpool-II cannot control that the value returned by the execution of the NOW() function is the same on both nodes due to the nature of replication at SQL level (not binary level), but it provides a mechanism named "insert_lock" to help out with that sort of problems. Please see: http://pgpool.projects.postgresql.org/pgpool-II/doc/pgpool-en.html Use your browser search function to find "insert_lock". Still, from my experience, it's best to get that value at the business logic level and use databases as pure storage servers (no login inside them). -- Jaume Sabater http://linuxsilo.net/ "Ubi sapientas ibi libertas" _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
