Re: Stored Procedure Problem

Mike Marconi wrote:
> [...]
>
> I have notice that the procedure is in pg_proc, but if
> you refer to it with "Drop Function pagedata_insert"
> it won't find it either.
> If I take out the argument declaration both objects
> are created successfully.

You have to match the functions argument list in DROP
FUNCTION to actually hit it. There could be any number of
functions named the same, as long as their arguments differ
(function overloading).

Trigger procedures don't take arguments. So you have to
CREATE it with empty parens. The arguments you specify in
CREATE TRIGGER will be found in the array TG_ARGV[] then.

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #