"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
"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
7.4.2 gives it like this:
testbed=# select replace('test %%400%% result',
'result', 'ok');
replace
-
test %%400%% ok
(1 row)
testbed =# select replace('test %400% result',
'result', 'ok');
replace
---
test %400% ok
(1 row)
Ted
-- Nicolas Bottar
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
(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.
There are a couple of similar (and about rename table itself) reports
for 7.0, 7.1 (as Tom Lane said, rename table is fixed in 7.2), but I
see no more
