Postgres Pro
Downloads
Home   >   mailing lists

Re: pqReadData() -- backend closed the channel unexpectedly. - Mailing list pgsql-admin

From Tom Lane
Subject Re: pqReadData() -- backend closed the channel unexpectedly.
Date
Msg-id 12678.991063302@sss.pgh.pa.us
Whole thread Raw
In response to pqReadData() -- backend closed the channel unexpectedly.  ("Jeff Barrett" <jbarrett@familynetwork.com>)
List pgsql-admin
Tree view 
"Jeff Barrett" <jbarrett@familynetwork.com> 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

pgsql-admin by date:

Previous
From: "Víctor"
Date:
Subject: Very big problem
Next
From: Martijn de Munnik
Date:
Subject: Large object and migration