Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist"

From: Michael Glaesemann <grzm(at)myrealbox(dot)com>
To: Juris <bubliks(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist"
Date: 2006-01-19 12:48:30
Message-ID: 324930EE-FCBC-4408-8534-01A00890FB2C@myrealbox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


On Jan 19, 2006, at 21:39 , Juris wrote:

> == sql begin ==
> CREATE OR REPLACE FUNCTION "InventGroups_GetAllParents"(int8)

> select * from InventGroups_GetAllParents(0::int8)
> =======
> ERROR: function inventgroups_getallparents(bigint) does not exist
> HINT: No function matches the given name and argument types. You may
> need to add explicit type casts.

If you double-quote your function name (or any identifier) when you
create it, you'll need to double-quote them when you call the
function as well. Try:

select * from "InventGroups_GetAllParents"(0::int8)

Michael Glaesemann
grzm myrealbox com

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Juris 2006-01-19 13:06:05 Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist"
Previous Message Juris 2006-01-19 12:39:47 Error calling self-made plpgsql function "function XYZ(bigint) does not exist"