Ger Timmens Ger.Timmens at adyen.com
Mon Nov 1 08:05:43 PDT 2010
I understand, but maybe I wasn't clear:
The column defition of the slony sl_ tables should be adapted
to 'timestamp with time zone' instead of 'timestamp without
timezone' to prevent any errors in monitoring scripts when
the clock goes one hour back from summer to winter time.

So it's more of a suggestion/patch for
slony-1.2.22 and slony-2.0.6.

Regards,

Ger Timmens


On 11/01/2010 03:58 PM, David Fetter wrote:
> On Sun, Oct 31, 2010 at 09:55:05AM +0100, Ger Timmens wrote:
>> Can we change the definitions of all 'timestamp' columns
>> from 'timestamp without time zone' to timestamp with time stamp'
>> in slony (we are using 1.2.20 rightnow).
> 
> You need to send any DDL changes via EXECUTE SCRIPT.  ALTER TABLE is a
> DDL change :)
> 
> Cheers,
> David.


More information about the Slony1-general mailing list