bugzilla-daemon at main.slony.info bugzilla-daemon at main.slony.info
Fri May 27 08:10:35 PDT 2011
http://www.slony.info/bugzilla/show_bug.cgi?id=216

           Summary: monitor threads don't work on Win32
           Product: Slony-I
           Version: devel
          Platform: PC
        OS/Version: Linux
            Status: NEW
          Severity: enhancement
          Priority: low
         Component: slon
        AssignedTo: slony1-bugs at lists.slony.info
        ReportedBy: ssinger at ca.afilias.info
                CC: slony1-bugs at lists.slony.info
   Estimated Hours: 0.0


With 2.1.0 beta2 on Win32.

slon keeps complaining about errors inserting into the component_state table:

ie 

Invalid input syntax for timestamp with timezone: 2011-05-27 11:04:25Eastern
Daylight Time

The strftime function on Win32 returns the timezone as "Eastern Daylight Time" 
which Postgresql does not seem to like.

We could
1) Get + pass second since 1970 converted to UTC to postgresql.
2) Get the current timezone offset and pass that to postgresql ie (2011-05-27
11:04:25+04)
3) Find a way to convert the windows timezone names to a postgresql recognized
abbreviation.

I think 1 is the best option

-- 
Configure bugmail: http://www.slony.info/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
You are the assignee for the bug.


More information about the Slony1-bugs mailing list