Brian Hirt bhirt at me.com
Mon Nov 1 13:41:29 PDT 2010
> 
> Actually, that's backwards.  We have always used timestamp *without*
> timezone, and the proposal is to change to use timestamp *with*
> timezone.
> 
> There's a small issue that "with timezone" consumes a little more space;
> I wouldn't consider that terribly important.
> 
> In my view, to use a timezone which has a known incontinuity (e.g. -
> where you can expect a 1 hour "leap" every so often) *is* the footgun.

Christopher,

You are right, i did get it backwards and say it the other way around.  Right now the timestamp in the sl_* tables are timestamp without time zone.   If they were all timestamp with time zone, couldn't the  slon clients just issue a "set timezone TO 'UTC'" command when they start up and everything would work nicely because postgres would be able to translate to a time zone that slony would like to see the data in. 

--brian



More information about the Slony1-general mailing list