Re: closed connection unexpectedly

Robert D Oden <roden@dbasetek.com> writes:
> I am trying to execute the following SQL:
> create table rdo_tmp0 as
> select distinct *
> from rp_na_mm
> where acct_no like '1%'
> and acct_no >= '13873365'

> This is the result I get:

> DBD::Pg::db do failed: server closed the connection unexpectedly

Apparently you've got some corrupted data in the rp_na_mm table.
See the mail list archives concerning methods for tracking down
corrupted data.

            regards, tom lane