| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | hertzma(at)sqc(dot)fi |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: backend closed the channel unexpectedly?!? |
| Date: | 2000-11-08 15:03:07 |
| Message-ID: | 26528.973695787@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Martti Hertzen <hertzma(at)sqc(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kate Collins | 2000-11-08 15:16:59 | Re: to_date problems (Re: Favor for Postgres User at WSI) |
| Previous Message | Martti Hertzen | 2000-11-08 14:54:40 | backend closed the channel unexpectedly?!? |