Re: For SELECT statement (just a reading one, no 'FOR UPDATE'), is COMMIT or ROLLBACK preferred?

2019-08-26 Thread Luca Ferrari
On Sun, Aug 25, 2019 at 10:12 PM David Wall wrote: > The main issue is that if > we do a SELECT and get a ResultSet that has no rows, if we do a commit > or a rollback, it seems reasonable that these are identical as no > changes were made. My inclination is to do a Connection.commit() on the > c

flinfo NULL in DirectFunctionCall callee?

2019-08-26 Thread Paul A Jungwirth
Hello, I'm writing a multirange_cmp function which calls range_cmp to compare individual elements. It looks like this: cmp = DatumGetInt32(DirectFunctionCall2( range_cmp, RangeTypePGetDatum(r1), RangeTypePGetDatum(r2))); But I get a segfault when range_cmp tries to reach

Re: flinfo NULL in DirectFunctionCall callee?

2019-08-26 Thread Tom Lane
Paul A Jungwirth writes: > Is it expected for flinfo to be null when using DirectFunctionCall*? Yes, per the comment on those functions: * These are for invocation of a specifically named function with a * directly-computed parameter list. Note that neither arguments nor result * are allowed

import job not working

2019-08-26 Thread Jeremy Thomason
I have been trying to find a reason and a solution for import not working for DBs on Azure, localhost and Aiven. The import dialogue results in a job-created notification and nothing more. It is odd as it used to work and am not sure what has changed.  I am using PGAdmin4.12 on Win10

Re: import job not working

2019-08-26 Thread Adrian Klaver
On 8/26/19 9:00 AM, Jeremy Thomason wrote: I have been trying to find a reason and a solution for import not working for DBs on Azure, localhost and Aiven. The import dialogue results in a job-created notification and nothing more. It is odd as it used to work and am not sure what has changed. 

How to set up PostGIS to support ArcGIS, MapInfo and QGIS desktop users?

2019-08-26 Thread Shaozhong SHI
Hi, I should be grateful if anyone can offer insight into how to set up PostGIS to support ArcGIS, MapInfo and QGIS desktop users. Looking forward to hearing from you. Regards, Shao

Re: flinfo NULL in DirectFunctionCall callee?

2019-08-26 Thread Tom Lane
Paul A Jungwirth writes: > On Mon, Aug 26, 2019 at 8:12 AM Tom Lane wrote: >> Yes, per the comment on those functions: >> * These are for invocation of a specifically named function with a >> * directly-computed parameter list. Note that neither arguments nor result >> * are allowed to be NULL.

Re: flinfo NULL in DirectFunctionCall callee?

2019-08-26 Thread Paul A Jungwirth
On Mon, Aug 26, 2019 at 8:12 AM Tom Lane wrote: > > Paul A Jungwirth writes: > > Is it expected for flinfo to be null when using DirectFunctionCall*? > > Yes, per the comment on those functions: > > * These are for invocation of a specifically named function with a > * directly-computed paramet

Re: Postgres SQLSTATE[08006] [7] timeout expired

2019-08-26 Thread Howard Wells
On my first post, I asked the person in charge of the firewall if 5432 was open and he told me it was. When I checked it myself later, I found out that it wasn't. Before I post to this list again, I'll check all assumptions myself. "Only when I go to the IP address of the server with the Post

Re: import job not working

2019-08-26 Thread Jeremy Thomason
here goes: 1) yes, import/export feature 2) the normal sequence for this process is a job notification, then a progress window, then completion notification. It is not progressing beyond the job notification 3) no idea 4) nothing I could find What I could find elsewhere on google is that p

Re: Postgres SQLSTATE[08006] [7] timeout expired

2019-08-26 Thread Adrian Klaver
On 8/26/19 1:07 PM, Howard Wells wrote: On my first post, I asked the person in charge of the firewall if 5432 was open and he told me it was. When I checked it myself later, I found out that it wasn't. Before I post to this list again, I'll check all assumptions myself. "Only when I go to

Re: import job not working

2019-08-26 Thread Adrian Klaver
On 8/26/19 1:22 PM, Jeremy Thomason wrote: here goes: 1) yes, import/export feature 2) the normal sequence for this process is a job notification, then a progress window, then completion notification. It is not progressing beyond the job notification What does the job notification show?