Re: function call

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.