Re: Postresql/postgis/qgis : assign privileges only for access/reading tables ?

Two thoughts: 1. Can the user view the tables when connecting through another database program (ie psql or PgAdmin)? 2. Does the user have access to the database schema that has the PostGIS extension (normally public schema)? cheers Ben On Thu, 14 Oct 2021 at 19:00, celati Laurent wrote: > G

Re: "two time periods with only an endpoint in common do not overlap" ???

> David Johnston wrote: > >> Bryn wrote: >> >> This means for instance that two time periods with only an endpoint in >> common do not overlap. > > A range has two endpoints. The one at the later (end) of the range and the > one at the earlier (start). I suppose rewording it to say “boundary

Re: "two time periods with only an endpoint in common do not overlap" ???

"David G. Johnston" writes: > A range has two endpoints. The one at the later (end) of the range and the > one at the earlier (start). I suppose rewording it to say "boundary point" > in common would avoid the ambiguity in the use of the word "end". Hmm, it seems clear to me in the context of t

Re: "two time periods with only an endpoint in common do not overlap" ???

On Thu, Oct 14, 2021, 16:38 Bryn Llewellyn wrote: > . This means for instance that two time periods with only an endpoint in > common do not overlap. > > A range has two endpoints. The one at the later (end) of the range and the one at the earlier (start). I suppose rewording it to say "boundar

Re: "two time periods with only an endpoint in common do not overlap" ???

On 10/14/21 16:38, Bryn Llewellyn wrote: I’m quoting this from “9.9. Date/Time Functions and Operators” in the PG Version 14 doc on the “overlaps” operator, here: www.postgresql.org/docs/14/functions-datetime.html It’s the same in “

Re: "two time periods with only an endpoint in common do not overlap" ???

Bryn Llewellyn writes: > I tried this obvious test (using Version 13.4): > with c as ( > select > '2000-01-15'::timestamp as start_1, > '2000-02-15'::timestamp as start_2, > '2000-03-15'::timestamp as common_endpoint) > select ( > (start_1, common_endpoint) overlaps > (start_2,

"two time periods with only an endpoint in common do not overlap" ???

I’m quoting this from “9.9. Date/Time Functions and Operators” in the PG Version 14 doc on the “overlaps” operator, here: www.postgresql.org/docs/14/functions-datetime.html It’s the same in “current”—and in the Version 11 doc. « This expression yields true when two time periods (defined by thei

Re: Conditional Tables in Postgres

Hi Mubashir, > ... researching on using databases to implement network control infrastructure. ... > Are there any postgres extensions/features that implement conditional tables like this? https://dl.acm.org/doi/10.1145/3472716.3472848 "Sarasate: a strong representation system for networking

RE: Certificate validity error download.postgresql.org

rpm -q ca-certificates --changelog * Tue Sep 14 2021 Bob Relyea - 2021.2.50-72 - Fix expired certificate. -Removing: - # Certificate "DST Root CA X3" As you can see they just remove the old "DST Root CA X3" in the latest el7 ca-certificate version which correct the problem I had before

Conditional Tables in Postgres

Hi! I am a PhD student, researching on using databases to implement network control infrastructure. For this purpose, I wanted to use conditional tables in databases, which allow representing unknown values in a DB with conditions ove

Re: Certificate validity error download.postgresql.org

Cedric Rey writes: > rpm -q ca-certificates --changelog > * Tue Sep 14 2021 Bob Relyea - 2021.2.50-72 > - Fix expired certificate. > -Removing: > - # Certificate "DST Root CA X3" > As you can see they just remove the old "DST Root CA X3" in the latest el7 > ca-certificate version which

Re: JOB | DBA (Canada)

On Thu, Oct 14, 2021 at 5:37 PM Gavin Flower wrote: > On 15/10/21 02:00, James Tobin wrote: > > Hello, we are working with an employer that is looking to hire someone > > capable of managing Mongo and Sybase databases at their office in > > Canada. Consequently, I had hoped that some members of

Re: JOB | DBA (Canada)

On 15/10/21 02:00, James Tobin wrote: Hello, we are working with an employer that is looking to hire someone capable of managing Mongo and Sybase databases at their office in Canada. Consequently, I had hoped that some members of this list may like to discuss further. Kind regards, James If t

Re: Certificate validity error download.postgresql.org

Christoph Moench-Tegeder writes: > I do know from my own experience that at least the "old" (2020.2.something) > Redhat package is missing the new "ISRG Root X1" certificate, you'll > need version 2021.2.something. Seems unlikely that it changed that recently, for a couple of reasons: * AFAICT,

Re: NOTIFY queue is at 66% and climbing...

On 10/13/21 5:50 PM, Tom Lane wrote: Jeff Ross writes: On 10.15 I'm getting the following on a logically replicated server. 2021-10-13 18:49:39.792 EDT,,,213601,,6143c257.34261,64243,,2021-09-16 18:16:55 EDT,4/3914851,60709901,WARNING,01000,"NOTIFY queue is 66% full","" In the CSV lo

RE: Certificate validity error download.postgresql.org

Hi, It was indeed related to the ca-certificates package. Thanks for your help! Best Regards -Message d'origine- De : Christoph Moench-Tegeder [mailto:c...@burggraben.net] Envoyé : jeudi 14 octobre 2021 15:29 À : Cedric Rey Cc : pgsql-general@lists.postgresql.org Objet : Re: Certifi

Re: JOB | DBA (Canada)

On Thu, Oct 14, 2021 at 3:00 PM James Tobin wrote: > Hello, we are working with an employer that is looking to hire someone > capable of managing Mongo and Sybase databases at their office in > Canada. Consequently, I had hoped that some members of this list may > like to discuss further. Kind

Re: Certificate validity error download.postgresql.org

## Cedric Rey (ce...@groupemutuel.ch): > the certificate on download.postgresql.org has expired : > > openssl s_client -connect download.postgresql.org:443 > CONNECTED(0003) > depth=3 O = Digital Signature Trust Co., CN = DST Root CA X3 > verify error:num=10:certificate has expired > notAfter

Re: Certificate validity error download.postgresql.org

> On 14 Oct 2021, at 14:34, Cedric Rey wrote: > the certificate on download.postgresql.org has expired : Are you perhaps running an old version of OpenSSL? -- Daniel Gustafsson https://vmware.com/

JOB | DBA (Canada)

Hello, we are working with an employer that is looking to hire someone capable of managing Mongo and Sybase databases at their office in Canada. Consequently, I had hoped that some members of this list may like to discuss further. Kind regards, James

Certificate validity error download.postgresql.org

Hi guys, the certificate on download.postgresql.org has expired : openssl s_client -connect download.postgresql.org:443 CONNECTED(0003) depth=3 O = Digital Signature Trust Co., CN = DST Root CA X3 verify error:num=10:certificate has expired notAfter=Sep 30 14:01:15 2021 GMT --- Certificate ch

RE: Duplicate key in UUID primary key index...

It turns out the issue was related to JSON and the UUID. I had a single row of data being inserted from the "source" side, but there were two rows contained in JSON within one of the fields. My extract pattern denormalized the JSON content and caused two records to be insert... with the same UUI

Postresql/postgis/qgis : assign privileges only for access/reading tables ?

Good morning, I work on Postgresql/postgis and Qgis. I had created a superuser account for me. In qgis, I can see the postgis schemas and tables and browse the tables without problem. This time, i created another simple user account just to be able in qgis to access and load the table in qgis.

ask for help：I want to compile a dynamic library file, such as libpsqlodbc w.so

hello! I compile code on linux and find that when I compile it, it is a static library file by default, but I want to compile a dynamic library file, such as libpsqlodbcw.so. How should I set the compilation options，or what should i do?

Re: Duplicate key in UUID primary key index...

On 2021-10-14 03:02:08 +, Eric Tobias wrote: > I have a table with a UUID as the primary key field. I am using a procedure to > insert a parent and child record and using a UUID generated by an external > system (webhook). The UUID insert is generating a “duplicate key” error on > insert, but w

RSYNC YUM Mirror for pg14 not available yet

Hey, we are trying to set up a pg14 yum mirror (as we did with all the former versions) but it is not working: rsync rsync://yum.postgresql.org yum-repoPostgreSQL YUM Repository zypp-repo PostgreSQL ZYPP Repository pgrpm-95PostgreSQL 9.5 YUM Repository pgsrpm-95 Postg