Re: [SQL] trigger trouble -- procedure not found

2001-09-13 Thread Kevin Way
Thank you. Later checking showed that these requirements were listed in the first sentence of the relevant page. Everything works like a champ now. I've made a small donation to the EFF and to the Red Cross as a minor thanks for your prompt help. Kevin Way ---(end of b

Re: [SQL] trigger trouble -- procedure not found

2001-09-13 Thread Stephan Szabo
On Fri, 14 Sep 2001, Kevin Way wrote: > I'm having trouble creating a trigger. First i'm creating a function, > add_to_search in PL/pgSQL. > > \df verifies the existance of this function: > smallint | add_to_search | text, text, text, integer > > but when I call: > > C

Re: [SQL] trigger trouble -- procedure not found

2001-09-13 Thread Bhuvan A
On Sep 14, Kevin Way wrote: > I'm having trouble creating a trigger. First i'm creating a function, > add_to_search in PL/pgSQL. > > \df verifies the existance of this function: > smallint | add_to_search | text, text, text, integer > -- We can verify all the functio

[SQL] trigger trouble -- procedure not found

2001-09-13 Thread Kevin Way
I'm having trouble creating a trigger. First i'm creating a function, add_to_search in PL/pgSQL. \df verifies the existance of this function: smallint | add_to_search | text, text, text, integer but when I call: CREATE TRIGGER item_insert_search_add AFTER INSERT ON i