Joe Maldonado <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED]