Re: [GENERAL] PL/pgSQL problems

2001-04-19 Thread Stephan Szabo
Have you modified the function since making the trigger? If you drop/create the function to make any changes you need to drop/create objects that depend on that function (views, triggers, etc) On Wed, 18 Apr 2001, Keith Menard wrote: > All, > > I am new to pgSQL so here goes. I am hav

RE: [GENERAL] PL/pgSQL problems

2001-04-19 Thread Jeff Eckermann
Have you dropped and recreated the function since creating the trigger? Try dropping and recreating the trigger. Errors like this happen because database objects (tables, functions etc) are referenced by object ids (oids) behind the scenes. Recreating an object (like a function) will give it a