Re: Question about no unchanging update rule + ALTER

[Josh Trutwin <josh(at)trutwins(dot)homeip(dot)net>]

On Fri, 27 Feb 2009 09:34:08 +0000
Richard Huxton <dev(at)archonet(dot)com> wrote:

> > CREATE TRIGGER prevent_empty_updates BEFORE UPDATE ON test FOR
> > EACH ROW EXECUTE PROCEDURE prevent_empty_updates();
> > 
> > Actually after writing this, this TOO does not seem to work after
> > an ADD COLUMN.  :/  Any suggestions?  
> 
> Try disconnecting and reconnecting to the database - that should do
> it. The function will be "compiled" the first time it is called in
> a session , so the * is probably getting expanded then. There's
> been a lot of work done to provide automatic re-planning in these
> sort of situations, but maybe you're hitting a corner-case.

Thanks for the info - I'll test out the disconnect and report back.

Josh.