On Fri, 27 Feb 2009 09:34:08 +0000
Richard Huxton <dev@archonet.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.