David Fetter david at fetter.org
Mon Nov 1 08:22:36 PDT 2010
This may or may not be a bug fix.  It's possible it's a large enough
feature change that it might need to go into 2.1.

Cheers,
David.
On Mon, Nov 01, 2010 at 04:05:43PM +0100, Ger Timmens wrote:
> 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.

-- 
David Fetter <david at fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter at gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate


More information about the Slony1-general mailing list