470,647 Members | 1,056 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,647 developers. It's quick & easy.

Fw: Stored Proc error after modifying field type

> Hi,
I've a problem with some of my stored procs. My config is: RH7.1, Postgres
7.3.2

I had converted a few fields of a few tables from one type to another and
after this I made all the necessary changes on the functions and recreated
all my types and functions.
It seemd to be all right, but the newly created functions won't work
anymore.

The error message says after running one of them:
-----------------------------------------------------------------------
ERROR: Function addincominginvoice(integer, integer, "unknown", "unknown", "unknown", "unknown", integer, "unknown", "unknown", "unknown", "unknown",
double precision) does not exist
Unable to identify a function that satisfies the given argument types
You may need to add explicit typecasts
-----------------------------------------------------------------------

This error rises only with newly created functions, old functions are workig fine.

Should anybody suggest me something to avoid this problem.

Thanks a lot,

-- Csaba


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.491 / Virus Database: 290 - Release Date: 2003. 06. 18.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 11 '05 #1
0 1102

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Nyul | last post: by
4 posts views Thread by Rhino | last post: by
11 posts views Thread by ColdCanuck | last post: by
5 posts views Thread by Rob Wire | last post: by
reply views Thread by mirandacascade | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.