Date: Mon, 11 Aug 2014 09:13:27 -0700 (PDT)
From: David G Johnston <david.g.johnston@gmail.com>
To: pgsql-sql@postgresql.org
Message-ID: <1407773607813-5814428.post@n5.nabble.com>
In-Reply-To: 
 <CABnqL31_H=UkR1gXMMUN8uGuGyzXsBU3mcA7fPjCVT8FMTK-NQ@mail.gmail.com>
References: 
 <CABnqL31EW-f2jKd=SMi+gwesgYJwwxizwx1q3B+nQxT7hqD2VA@mail.gmail.com>
 <53E0D58E.9040502@aklaver.com>
 <CABnqL30b-cZUJE69QJw0kueiwJ=uBPOLDnbgRWz7hrwo-=Frfw@mail.gmail.com>
 <53E23483.4030906@aklaver.com>
 <CABnqL31_H=UkR1gXMMUN8uGuGyzXsBU3mcA7fPjCVT8FMTK-NQ@mail.gmail.com>
Subject: Re: function call
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

Marcin Krawczyk-2 wrote
>>
>> So it would seem that the issue is with ERP application returning the
>>> information.
>>>
>>
>> This probably hinges on what you are defining as returning?
>>
>> In your function description you note that the function issues documents.
>>
>> Is that what you are using to determine that the function has completed?
>>
> 
> The function makes some calculations, then INSERTs and UPDATEs data (the
> aforementioned documents) then returns 1 row with 3 columns with
> information on whether there were any errors or how many documents were
> created and so on.

Are you positive the pgAdmin and your application are talking to the same
machine?

Is there any variation in run-time for the two clients?

Can you get both of them to run the same query but using EXPLAIN ANALYZE?

David J.


--
View this message in context: http://postgresql.1045698.n5.nabble.com/function-call-tp5813776p5814428.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql