Re: Question about no unchanging update rule + ALTER

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.