Re: Functions just dont want to work! [hard]

On Wednesday 04 December 2002 11:32, Yonatan Ben-Nes wrote:
> Hi,
>
> I'm having a problem at a code which worked already and now after
> installing the new postgresql version it doesn't work (i didnt check it
> actually for about 2-3 months but i didnt change anything in the
> meanwhile).
>
> the problem occur only with functions which i created and the error which
> it gives me is (all of the functions get the same error) - Warning:
> PostgreSQL query failed: ERROR: Function insert_new_field(integer,
> "unknown", "unknown") does not exist Unable to identify a function that
> satisfies the given argument types You may need to add explicit typecasts.
>
> now i echoed the sql line itself and its -
> SELECT insert_new_field(24, '2', '2');
>

I think the clue to your solution is in the ERROR output.

The database is telling you that the function does not exist. When I attempt
to use the SQL statement in one of my databases ... I get the exact same
error because I do not have that function in my DB either.

When you upgraded versions ... did you re-create your database properly with
output from a pg_dump?

I always keep copies of my table definitions, triggers, and functions I have
written in flat files so I can always re-create everything in the DB.

My guess would be that if you added the function again, all would work
properly.

Andy