Re: Problems renaming referencing column

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
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 15:08:52
Message-ID: 20040717080749.L16467@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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 connection and restart it, the constraint appears to work.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Theodore Petrosky 2004-07-17 15:39:05 Re: Replace function BUG
Previous Message Alexander M. Pravking 2004-07-17 10:08:34 Problems renaming referencing column