Re: SQL Status:42883

Oh my god! I have found my mistake. I used now() as an argument, which
is a 'timestamp with time zone' type, but my method expects 'timestamp
without time zone'. It's a minor difference, but is one. I'm surprised,
that this didn't happen earlier.

Andreas

am Montag, 1. Dezember 2008 um 20:18 schrieben Sie:

AK> Andreas Junius <andreas(at)junius(dot)info> schrieb:

>> 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