Mon Nov 1 13:41:29 PDT 2010
- Previous message: [Slony1-general] Slony1-general Digest, Vol 44, Issue 16
- Next message: [Slony1-general] Slony1-general Digest, Vol 44, Issue 16
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
> > 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
- Previous message: [Slony1-general] Slony1-general Digest, Vol 44, Issue 16
- Next message: [Slony1-general] Slony1-general Digest, Vol 44, Issue 16
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list