| Andreas Pflug 2005-09-19, 11:24 am |
| 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()::timesta
mp;
> 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 time
stamp DEFAULT timeofday()::timesta
mp
> + con_timestamp tim
estamp DEFAULT now()
> );
> comment on table @NAMESPACE@.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- AuKwsB3Fm+ugFIWk8tvy
RWD2FQJk+8+b@public.gmane.org
>http://gborg.postgresql.org/mailman.../slony1-general
>
>
|