Re: [GENERAL] Re: Causeless CPU load waves in backend, on windows, 9.5.5 (EDB binary).

2017-02-26 Thread Nikolai Zhubr
15.02.2017 0:06, I wrote: [...] Indeed, such function is available. But essentially, this function is a (kind of) combined login+logout, therefore it would not work for my purpose. (Despite its name, it can not be used to perform some communication "ping" within an established session, such thing

Re: [GENERAL] Configuring ssl_crl_file

2017-02-26 Thread Frazer McLean
I found a solution to the problem, which I’l send here to help those who find the original email via search. The intermediate CRL file must be concatenated to CRL files going back to the root CA. On 26 Feb 2017, at 15:42, Frazer McLean wrote: Hi, I was trying to set up PostgreSQL to use a

Re: [GENERAL] ERROR: functions in index expression must be marked IMMUTABLE

2017-02-26 Thread Adrian Klaver
On 02/26/2017 09:42 AM, Tom Lane wrote: Adrian Klaver writes: On 02/26/2017 08:50 AM, Tom Lane wrote: I'm not entirely sure why the OP feels he needs an index on this expression. If he's willing to restrict the column to have the exact format '-MM-DD', then a regular textual index would s

Re: [GENERAL] ERROR: functions in index expression must be marked IMMUTABLE

2017-02-26 Thread Tom Lane
Adrian Klaver writes: > On 02/26/2017 08:50 AM, Tom Lane wrote: >> I'm not entirely sure why the OP feels he needs an index on this >> expression. If he's willing to restrict the column to have the >> exact format '-MM-DD', then a regular textual index would sort >> the same anyway. Perhaps

Re: [GENERAL] ERROR: functions in index expression must be marked IMMUTABLE

2017-02-26 Thread Adrian Klaver
On 02/26/2017 08:50 AM, Tom Lane wrote: Geoff Winkless writes: On 26 February 2017 at 16:09, Adrian Klaver wrote: On 02/26/2017 07:56 AM, Geoff Winkless wrote: On 26 February 2017 at 10:09, Sven R. Kunze mailto:srku...@mail.de>>wrote: # create index docs_birthdate_idx ON docs using btree ((

Re: [GENERAL] ERROR: functions in index expression must be marked IMMUTABLE

2017-02-26 Thread Adrian Klaver
On 02/26/2017 08:15 AM, Geoff Winkless wrote: On 26 February 2017 at 16:09, Adrian Klaver mailto:adrian.kla...@aklaver.com>>wrote: On 02/26/2017 07:56 AM, Geoff Winkless wrote: > On 26 February 2017 at 10:09, Sven R. Kunze mailto:srku...@mail.de> >

Re: [GENERAL] ERROR: functions in index expression must be marked IMMUTABLE

2017-02-26 Thread Tom Lane
Geoff Winkless writes: > On 26 February 2017 at 16:09, Adrian Klaver > wrote: >> On 02/26/2017 07:56 AM, Geoff Winkless wrote: >>> On 26 February 2017 at 10:09, Sven R. Kunze >> >wrote: # create index docs_birthdate_idx ON docs using btree (((meta->>'birthdate'):

Re: [GENERAL] ERROR: functions in index expression must be marked IMMUTABLE

2017-02-26 Thread Geoff Winkless
On 26 February 2017 at 16:09, Adrian Klaver wrote: > On 02/26/2017 07:56 AM, Geoff Winkless wrote: > > On 26 February 2017 at 10:09, Sven R. Kunze > >wrote: > > > > >>># create index docs_birthdate_idx ON docs using btree > > (((meta->>'birthdate')::date)); > >

Re: [GENERAL] ERROR: functions in index expression must be marked IMMUTABLE

2017-02-26 Thread Adrian Klaver
On 02/26/2017 07:56 AM, Geoff Winkless wrote: > On 26 February 2017 at 10:09, Sven R. Kunze >wrote: > > >>># create index docs_birthdate_idx ON docs using btree > (((meta->>'birthdate')::date)); > ERROR: functions in index expression must be marked IMMUTABLE >

Re: [GENERAL] ERROR: functions in index expression must be marked IMMUTABLE

2017-02-26 Thread Geoff Winkless
On 26 February 2017 at 10:09, Sven R. Kunze wrote: > >>># create index docs_birthdate_idx ON docs using btree > (((meta->>'birthdate')::date)); > ERROR: functions in index expression must be marked IMMUTABLE > > So, what is the problem here? > ​Date functions are inherently not immutable becaus

[GENERAL] Configuring ssl_crl_file

2017-02-26 Thread Frazer McLean
Hi, I was trying to set up PostgreSQL to use a certificate revocation list so I could revoke client certificates, but was unable to get it to work. I was following [this tutorial][1] to create root and intermediate CA certificates, then producing certificates for the PostgreSQL server and cl

Re: [GENERAL] New 9.6.2 installation lacks /usr/lib/postgresql/ [RESOLVED]

2017-02-26 Thread Rich Shepard
On Sat, 25 Feb 2017, Rich Shepard wrote: Just installed postgresql-9.6.2 on Slackware-14.2/x86_64 and initialized the database. However, there's no /usr/lib/postgresql/ directory with its subdirectories. Duh! It's in /usr/lib64/postgresql. Sigh, Rich -- Sent via pgsql-general mailing lis

[GENERAL] Full Text Search combined with Fuzzy

2017-02-26 Thread Nicolas Paris
Hello, AFAIK there is no built-in way to combine full text search and fuzzy matching (https://www.postgresql.org/docs/current/static/fuzzystrmatch.html). By example, phrase searching with tipos in it. First I don't know if postgresql concurrents (lucene based...) are able to do so. Second, is su

[GENERAL] Querying JSON Lists

2017-02-26 Thread Sven R. Kunze
Hello everyone, playing around with jsonb and coming from this SO question http://stackoverflow.com/questions/19925641/check-if-a-postgres-json-array-contains-a-string I wonder why PostgreSQL behaves differently for text and integers on the ? and @> operators. Let's have a look at 4 differe

[GENERAL] ERROR: functions in index expression must be marked IMMUTABLE

2017-02-26 Thread Sven R. Kunze
Hello everybody, I'd like to implement a btree date index from json input data. >>># \d docs Table "public.docs" Column | Type | Modifiers +-+--- id | integer | not null default nextval('docs_id_seq