Andreas Pflug pgadmin
Mon Sep 19 15:53:20 PDT 2005
No comment on this bug?

Andreas Pflug wrote:

> con_timestamp should use now() instead of timeofday() as default 
> because correct conversion to timestamp can't be guaranteed.
>
> SELECT timeofday()::timestamp;
> ERROR:  invalid input syntax for type timestamp:
> "Sun Aug 28 17:09:48.284274 2005 MESZ"
>
> Patch attached.
>
> Regards,
> Andreas
>
>------------------------------------------------------------------------
>
>? con_timestamp
>Index: slony1_base.sql
>===================================================================
>RCS file: /usr/local/cvsroot/slony1/slony1-engine/src/backend/slony1_base.sql,v
>retrieving revision 1.27
>diff -u -r1.27 slony1_base.sql
>--- slony1_base.sql	7 Jun 2005 21:51:05 -0000	1.27
>+++ slony1_base.sql	28 Aug 2005 15:12:06 -0000
>@@ -316,7 +316,7 @@
> 	con_origin			int4,
> 	con_received		int4,
> 	con_seqno			int8,
>-	con_timestamp		timestamp DEFAULT timeofday()::timestamp
>+	con_timestamp		timestamp DEFAULT now()
> );
> comment on table @NAMESPACE at .sl_confirm is 'Holds confirmation of replication events.  After a period of time, Slony removes old confirmed events from both this table and the sl_event table.';
> 
>  
>
>------------------------------------------------------------------------
>
>_______________________________________________
>Slony1-general mailing list
>Slony1-general at gborg.postgresql.org
>http://gborg.postgresql.org/mailman/listinfo/slony1-general
>  
>



More information about the Slony1-general mailing list