Bruno, If you have less than 1 second difference between the hosts you could try to truncate the current timestamp result to seconds or minutes, depending on your application needs, for example:
UPDATE public.transporte SET ativo = false, ts = CURRENT_TIMESTAMP
WHERE age(date_trunc('minute', current_timestamp)::timestamp,ts) > '2 hours'
Regards
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
