| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Alexander M(dot) Pravking" <fduch(at)antar(dot)bryansk(dot)ru> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: Problems renaming referencing column |
| Date: | 2004-07-17 16:12:00 |
| Message-ID: | 13124.1090080720@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
"Alexander M. Pravking" <fduch(at)antar(dot)bryansk(dot)ru> writes:
> In 7.4.3, if I rename a column which references another table,
> constraint trigger fails on update or delete from main table.
> The problem goes away after re-creating the foreign key:
Actually all you have to do is start a fresh backend. The problem is
that the "ALTER TABLE slave" fails to force an update of the backend's
relcache entry for "master". AFAICS this problem has always been there.
Certainly your test case yields a failure of some type in every release
back to 7.0 ...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-07-17 17:30:51 | Re: Problems renaming referencing column |
| Previous Message | Theodore Petrosky | 2004-07-17 15:39:05 | Re: Replace function BUG |