Re: backend closed the channel unexpectedly?!? - Mailing list pgsql-bugs

From Tom Lane
Subject Re: backend closed the channel unexpectedly?!?
Date
Msg-id 26528.973695787@sss.pgh.pa.us
Whole thread Raw
In response to backend closed the channel unexpectedly?!?  (Martti Hertzen <hertzma@sqc.fi>)
List pgsql-bugs
Martti Hertzen <hertzma@sqc.fi> writes:
> I have a table with a field called 'id'
> (primary key) that is referenced from other tables. Today I tried to
> delete one of the rows in this table with the following command (worked
> fine a few weeks ago) and there's the output.

> testsqc=> DELETE FROM henkilo WHERE id = 12;
> pqReadData() -- backend closed the channel unexpectedly.

Did you rename this table, or another one associated with it via a
foreign key reference?  If so, undo the rename.  The foreign-key stuff
doesn't track table renames, and doesn't error out gracefully either :-(
(the latter bug is fixed for 7.0.3, at least)

            regards, tom lane

pgsql-bugs by date:

Previous
From: Martti Hertzen
Date:
Subject: backend closed the channel unexpectedly?!?
Next
From: Kate Collins
Date:
Subject: Re: to_date problems (Re: Favor for Postgres User at WSI)