Checked that out, every row has a value and the values are properly formatted. Seems like this may be an issue of not enough ram in the server. The only problem I have with that diagnosis is that I do not get an out of memory error, I just loose the back end. Thanks, Jeff "Tom Lane" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > "Jeff Barrett" <[EMAIL PROTECTED]> writes: > > I get a success on testtime and a failure of "pqReadData() -- backend > > closed the channel unexpectedly on logs2". > > > update <either tablename> set time2 = to_timestamp(time, 'HH24:MI:SS'); > > Any NULL values in the time column? ISTR to_timestamp fails on NULLs in > pre-7.1 releases. Try upgrading. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
