Re: backend closed the channel unexpectedly?!?
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: hertzma@sqc.fi
Cc: pgsql-bugs@postgresql.org
Date: 2000-11-08T15:03:07Z
Lists: 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