Re: bad url in docs

2018-09-06 Thread Rob Sargent
Sorry.  I didn't see the specific form for documentations issues. On 09/06/2018 04:52 PM, Rob Sargent wrote: Version 10 33.18. SSL Support The pointers off to hp.com seem to have gone away on or about 28Aug2018.  They also fall under the heading of HP OpenVMS Systems Doc which may explain

bad url in docs

2018-09-06 Thread Rob Sargent
Version 10 33.18. SSL Support The pointers off to hp.com seem to have gone away on or about 28Aug2018.  They also fall under the heading of HP OpenVMS Systems Doc which may explain why they've disappeared.

Re: nested query problem

2018-09-06 Thread David Gauthier
Wow, I take that back. I thought there were many recs with "foo" but there wa sonly one. When I ran this against a value that actually had multiple records, it ran fine. Sorry for that. And Thanks for this query ! On Thu, Sep 6, 2018 at 5:15 PM David Gauthier wrote: > Not quite. This

Re: nested query problem

2018-09-06 Thread David Gauthier
Not quite. This returns one value. In the actual "sqf_runs" table, there are many records with user_id = 'foo'. I want one line for each where the fse.p-erl_sub_name and fse.end_datetime values are the latest values found in the flow_step_events_view view where the sqf_ids match. On Thu, Sep 6,

Re: nested query problem

2018-09-06 Thread Paul Jungwirth
On 09/06/2018 01:59 PM, David Gauthier wrote: I'm having trouble with this query... select sr.sqf_id, sr.status, fse.perl_sub_name, fse.end_datetime   from     sqf_runs sr,     (select perl_sub_name, end_datetime from flow_step_events_view where sqf_id = sr.sqf_id order by 2 limit 1) fse  

nested query problem

2018-09-06 Thread David Gauthier
Hi: I'm having trouble with this query... select sr.sqf_id, sr.status, fse.perl_sub_name, fse.end_datetime from sqf_runs sr, (select perl_sub_name, end_datetime from flow_step_events_view where sqf_id = sr.sqf_id order by 2 limit 1) fse where sr.userid='foo'; ERROR: invalid

Re: timestamp arithmetics in C function

2018-09-06 Thread Adrian Klaver
On 09/03/2018 09:11 AM, Lutz Gehlen wrote: Hello all, unfortunately, I have so far not received a reply to my question below. I am well aware that no one has an obligation to reply; I was just wondering whether I phrased my question badly or whether there is anything else I could do to improve

Re: very slow largeobject transfers through JDBC

2018-09-06 Thread Dave Cramer
Hi Mate, Thanks for the detailed response. This will help others in the same situation Dave Cramer da...@postgresintl.com www.postgresintl.com On Thu, 6 Sep 2018 at 05:03, Mate Varga wrote: > Hi, > > summarizing: > we had a table that had an OID column, referencing an object in >

Re: very slow largeobject transfers through JDBC

2018-09-06 Thread Mate Varga
Hi, summarizing: we had a table that had an OID column, referencing an object in pg_largeobject. This was mapped to a (Java) entity with a byte array field, annotated with @Lob. The problem was that we were fetching thousands of these entities in one go, and LOB fetching is not batched by

Re: Re: How to install pgAgent on windows for postresql-bigsql-10.5

2018-09-06 Thread Dave Page
On Thu, Sep 6, 2018 at 9:41 AM, jimmy wrote: > Is EnterpriseDB opensource and free. Has this database some limits and > restrictions ? > The EDB PostgreSQL installers are free, opensource and have no limits or restrictions. They are the very first option at

Re: very slow largeobject transfers through JDBC

2018-09-06 Thread Dave Cramer
Hi Can you be more explicit how you fixed the problem ? Thanks Dave Cramer da...@postgresintl.com www.postgresintl.com On Thu, 6 Sep 2018 at 03:46, Mate Varga wrote: > After inlining the data, performance issues have been solved. Thanks for > the help. > > On Mon, Sep 3, 2018 at 9:57 PM

Re:Re: How to install pgAgent on windows for postresql-bigsql-10.5

2018-09-06 Thread jimmy
Is EnterpriseDB opensource and free. Has this database some limits and restrictions ? At 2018-09-06 15:57:30, "Dave Page" wrote: Hi On Thu, Sep 6, 2018 at 6:23 AM, jimmy wrote: I use PostgreSQL-10.5-1-win64-bigsql.exe to install postgresql database. How to install pgAgent on windows

Re: How to install pgAgent on windows for postresql-bigsql-10.5

2018-09-06 Thread Dave Page
Hi On Thu, Sep 6, 2018 at 6:23 AM, jimmy wrote: > I use PostgreSQL-10.5-1-win64-bigsql.exe to install postgresql database. > How to install pgAgent on windows for postresql-bigsql-10.5. > I have been searching some articles to install pgAgent. > But they do not work. > I found there has not any

Re: very slow largeobject transfers through JDBC

2018-09-06 Thread Mate Varga
After inlining the data, performance issues have been solved. Thanks for the help. On Mon, Sep 3, 2018 at 9:57 PM Mate Varga wrote: > Thanks, > 1) we'll try to move stuff out from LOBs > 2) we might raise a PR for the JDBC driver > > Mate > > On Mon, 3 Sep 2018, 19:35 Dave Cramer, wrote: > >>

Re: PostgreSQL intenal scheduler?

2018-09-06 Thread Thiemo Kellner
Thanks for the hint. Your solution seems to be good. However, I am designing my framework for fun, to give back something to the community and because I think it's time that historisation is not reinvented and reimplemented again and again. Having that said, I think I can get rid of the

Re: Async replication: how to get an alert on failure

2018-09-06 Thread pavan95
Hi Karl, Hope my mail finds you in good time. >I wrote a small program that goes to each of the servers in the replication group and checks its status on the log, computes the difference, and if off by more than "X" bytes prints a notification. Did you configure ssh ?? >If this is run from