Joe Maldonado <jmaldonado@xxxxxxxxxxxxxxx> writes: > After a create or replace view, the new view definition is not being > used by plpgsql functions that use the view. Is this a known bug ? Is > there a workaround it ? Start a fresh backend session. The old query plan is presumably being cached by plpgsql. (Yes, this is something we'd like to fix.) regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
