| From: | David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: function call |
| Date: | 2014-08-11 16:13:27 |
| Message-ID: | 1407773607813-5814428.post@n5.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Igor Neyman | 2014-08-11 18:38:14 | Re: How to optimize WHERE column_a IS NOT NULL OR column_b = 'value' |
| Previous Message | Andreas Joseph Krogh | 2014-08-11 16:01:17 | How to optimize WHERE column_a IS NOT NULL OR column_b = 'value' |