Re: [BUGS] Problems renaming referencing column

2004-07-17 Thread Tom Lane
"Alexander M. Pravking" <[EMAIL PROTECTED]> 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 following patch (against 7.4.*) appears to fix this problem. regards, tom lane Index: t

Re: [BUGS] Problems renaming referencing column

2004-07-17 Thread Tom Lane
"Alexander M. Pravking" <[EMAIL PROTECTED]> 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. Th

Re: [BUGS] Problems renaming referencing column

2004-07-17 Thread Stephan Szabo
On Sat, 17 Jul 2004, Alexander M. Pravking wrote: > (sorry if it's a dup) > > In 7.4.3, if I rename a column which references another table, > constraint trigger fails on update or delete from main table. I think this probably has to do with the fact that the plan gets cached. If I close the con