On Fri, 27 Feb 2009 09:34:08 +0000 Richard Huxton <dev@xxxxxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
