Skip site navigation (1) Skip section navigation (2)

SQL Status:42883

From: "Andreas Junius" <andreas(at)junius(dot)info>
To: pgsql-novice(at)postgresql(dot)org
Subject: SQL Status:42883
Date: 2008-12-01 17:27:18
Message-ID: 251545216.20081201182718@junius.info (view raw or flat)
Thread:
Lists: pgsql-novice
Hi Postgres professionals,

I hope someone is able to give some advice to the following matter:

I created two plpgsql functions, which appear in pgAdminIII as
expected. The first one works fine, it has only four arguments. The
other one has 10 arguments and I have got the error

FEHLER: Funktion md.insertuser(unknown, unknown, unknown, integer, unknown, unknown, unknown, unknown, integer, timestamp with time zone) existiert nicht
SQL Status:42883
Hinweis:Keine Funktion stimmt mit dem angegebenen Namen und den Argumenttypen überein. Sie müssen möglicherweise ausdrückliche Typumwandlungen hinzufügen.
Zeichen:15

Ok the message seems to be clear, I have to add some casts (why by the
way, the other function didn't need any cast?)

If I try it again, I'll get:

FEHLER: Funktion md.insertuser(character varying, character varying, timestamp without time zone, integer, character varying, character varying, character varying, timestamp without time zone, integer, timestamp with time zone) existiert nicht
SQL Status:42883
Hinweis:Keine Funktion stimmt mit dem angegebenen Namen und den Argumenttypen überein. Sie müssen möglicherweise ausdrückliche Typumwandlungen hinzufügen.
Zeichen:15

I have no idea what to do, because the casts happened, the function
has already been there, it should work, but it don't work? The
argument list matches exactly.  I tried a
lot of things, e.g. creating the function without any function, to be
sure there is no fault within the function body.

I'm grateful for every tip!

Andreas




Responses

pgsql-novice by date

Next:From: Andrej Ricnik-BayDate: 2008-12-01 17:44:48
Subject: Re: SQL Status:42883
Previous:From: Carol CheungDate: 2008-12-01 16:35:09
Subject: unsure of how to query for desired data/output

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group