Archibald Zimonyi <[EMAIL PROTECTED]> writes: > ERROR: fmgr_info: function 18308: cache lookup failed > I have no idea what this is, can anyone help me?
The aggregate links to the function by OID. You deleted the function and recreated it, which means it's a new function with a new OID and so the aggregate is broken. You'll need to drop and recreate the aggregate too. Next time use CREATE OR REPLACE FUNCTION so you don't need to do that. (With CREATE OR REPLACE, you are just modifying the existing function, so its OID doesn't change.) 7.3 will prevent this sort of mistake... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]