Re: closed connection unexpectedly - Mailing list pgsql-admin

From Tom Lane
Subject Re: closed connection unexpectedly
Date
Msg-id 2102.1105977680@sss.pgh.pa.us
Whole thread Raw
In response to closed connection unexpectedly  (Robert D Oden <roden@dbasetek.com>)
Responses Re: closed connection unexpectedly  (Robert D Oden <roden@dbasetek.com>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Robert D Oden
Date:
Subject: closed connection unexpectedly
Next
From: francyX
Date:
Subject: help How i quit of list