On Mon, Jul 02, 2007 at 10:54:35PM -0400, Bill Moran wrote:
> On both systems, the database is set to est5edt timezone, yet some
> rows (not all, mind you) change the timezone from edt to est when
> the data is replicated.
Just as a point of information, since I see you have the problem
fixed, this can _never_ be true in the sense of changing the data.
PostgreSQL stores its dates internally as UTC, so if your client
timezone setting changes, you'll see a difference. So whenever you
see something like this, look for a problem around how the data is
being presented (like in your case, different timezone rules).
A
--
Andrew Sullivan | [EMAIL PROTECTED]
The very definition of "news" is "something that hardly ever happens."
--Bruce Schneier
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
