Re: Hello...

On Fri, Feb 11, 2005 at 02:56:09PM -0600, Cristian Prieto wrote:
> Hello, I migrated a database from postgresql 7.4 to postgresql 8.0.1 in a
> Linux Fedora Core 3.
> The tables and objects in the database schema are working ok...
> I was just writing that function:

Here's the function definition:

> CREATE OR REPLACE FUNCTION "public"."sp_insert_users_new" (varchar, varchar,
> varchar, varchar, smallint, date, smallint, smallint, varchar, varchar,
> varchar, varchar, varchar, varchar, varchar) RETURNS integer AS

As here's your error message:

> ERROR: function public.sp_insert_users_new("unknown", "unknown", "unknown",
> "unknown", "unknown", "unknown", integer, "unknown", "unknown", "unknown",
> "unknown", "unknown", "unknown", "unknown", "unknown") does not exist

It's looking for a function which accepts and integer in the 7th column
you havn't define one. Check your function call...

Hope this helps,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.