Re: [GENERAL] Stored Proc error after modifying field type

2003-07-02 Thread Együd Csaba
Tom, what do you think about the folowing: I updated the server field of my DSN to point to the postgres runniong under cygwin on the localhost. The error does not appear at all. -- 1 06:29:42 SQL Prepare: PostgreSQL - { call "addincominginvoice" (?,?,?,?,?,?

Re: [GENERAL] Stored Proc error after modifying field type

2003-07-02 Thread Együd Csaba
MAIL PROTECTED]> Sent: Wednesday, July 02, 2003 6:23 PM Subject: Re: [GENERAL] Stored Proc error after modifying field type > =?iso-8859-2?Q?Egy=FCd_Csaba?= <[EMAIL PROTECTED]> writes: > > alumil=# \df addincominginvoice > >

Re: [GENERAL] Stored Proc error after modifying field type

2003-07-02 Thread Tom Lane
=?iso-8859-2?Q?Egy=FCd_Csaba?= <[EMAIL PROTECTED]> writes: > alumil=# \df addincominginvoice > List of functions > Result data type | Schema |Name| > Argument data types > --+++---

Re: [GENERAL] Stored Proc error after modifying field type

2003-07-02 Thread Együd Csaba
Sorry for posting many times! -- 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 9: the p

Re: [GENERAL] Stored Proc error after modifying field type

2003-07-02 Thread Együd Csaba
- -- This trace is provided by the psqlODBC driver. Can you find anything in this log, which can cause the error? Thank you, -- Csaba - Original Message - From: "Tom Lane" <[EMA

Re: [GENERAL] Stored Proc error after modifying field type

2003-07-02 Thread Tom Lane
=?iso-8859-1?Q?Egy=FCd_Csaba?= <[EMAIL PROTECTED]> writes: > 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

[GENERAL] Stored Proc error after modifying field type

2003-07-02 Thread Együd Csaba
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 ne