agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: David G Johnston <david.g.johnston@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: function call
Date: Mon, 11 Aug 2014 09:13:27 -0700 (PDT)
Message-ID: <1407773607813-5814428.post@n5.nabble.com> (raw)
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>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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.
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
view thread (13+ messages) latest in thread
Message-ID: <1407773607813-5814428.post@n5.nabble.com>
Permalink: ../1407773607813-5814428.post@n5.nabble.com/
Also on: postgresql.org/message-id/1407773607813-5814428.post@n5.nabble.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: david.g.johnston@gmail.com
Subject: Re: function call
In-Reply-To: <1407773607813-5814428.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox