Function created yet not found

From: Fran Fabrizio <ffabrizio(at)mmrd(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Function created yet not found
Date: 2002-03-13 19:28:38
Message-ID: 3C8FA866.2000700@mmrd.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Using PostgreSQL 7.1.3....

I start off without the function....

test=# select findparenttype(10056,'S');
ERROR: Function 'findparenttype(int4, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts

So I create the function....

test=# create function findparenttype(int4, varchar) returns int4 as '
test'# select parent.entity_id from entity parent, entity child where
child.entity_id = $1 and child.lft between parent.lft and parent.rgt and
parent.type = $2;
test'# ' language 'sql';
CREATE

And then I try to use it:

test=# select findparenttype(10056,'S');
ERROR: Function OID 14997123 does not exist
test=#

I've never seen that happen before, what causes something like this? It
recognized that there was supposed to be a function with those
parameters, yet couldn't find it though I'd just created it. Nothing in
the log indicates anything unusual to me. I usually see this error when
the function I'm calling is referencing another function which has since
been dropped or reloaded, but you can see findparenttype doesn't
reference any other functions of mine.

I've been creating and dropping this function from the same script all
day without issues until now.

Thanks,
Fran

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2002-03-13 19:46:00 Re: Zlib vulnerability heads-up.
Previous Message Joel Rodrigues 2002-03-13 18:53:40 Re: spanish characters in postgresql