Mon Sep 19 15:53:20 PDT 2005
- Previous message: [Slony1-general] Master server reboot
- Next message: [Slony1-general] Monitoring slon processes
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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 > >
- Previous message: [Slony1-general] Master server reboot
- Next message: [Slony1-general] Monitoring slon processes
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list