Sebastian K?hner wrote:

>...and following error message occurs:
>
>ERROR:  invalid input syntax for type timestamp: "Tue Sep 06 02:23:17.284444
>2005 Local time zone must be set--see zic manual page"
>CONTEXT:  SQL statement "insert into "_sql_cluster6".sl_confirm (con_origin,
>con_received, con_seqno) select no_id,  $1 , 0 from "_sql_cluster6".sl_node
>where no_id !=  $2  and no_active"
>        PL/pgSQL function "enablenode_int" line 32 at SQL statement
>
>
>I don't have any idea why. Anyone of you can help me? How do I use ZIC (man
>zic doesn't say me anything)?
>  
>
I'm not sure what flavour of Unix you're on; what is seemingly happening
here is that there is some confusion as to what timezone you're in.

The "best practice" that we have found has been to set PGTZ and TZ to
either GMT or UTC; it seems clear that that is NOT what you're using.

This isn't a Slony-I problem per se; you'll find it the case any time
you grab a timestamp via current_timestamp if you're using a timezone
that PostgreSQL doesn't recognize.