Re: citext function overloads for text parameters

2018-05-05 Thread Pavel Stehule
2018-05-06 8:26 GMT+02:00 Shay Rojansky : > Hi hackers. > > The following works well of course: > > test=# select strpos('Aa'::citext, 'a'); > strpos > > 1 > > However, if I pass a typed text parameter for the substring, I get > case-sensitive behavior instead: > > test=# select st

citext function overloads for text parameters

2018-05-05 Thread Shay Rojansky
Hi hackers. The following works well of course: test=# select strpos('Aa'::citext, 'a'); strpos 1 However, if I pass a typed text parameter for the substring, I get case-sensitive behavior instead: test=# select strpos('Aa'::citext, 'a'::text); strpos 2 This see

Re: genbki.pl not quoting keywords in postgres.bki output

2018-05-05 Thread Tom Lane
Mark Dilger writes: > There are not yet any examples in the postgres sources where this > oversight causes problems, but in genbki.pl, where it makes the > decision whether to quote a token: ... > it should also quote anything that is a keyword, such as "open", as > otherwise you get a syntax erro

Re: Python 3.7 support

2018-05-05 Thread Tom Lane
Peter Eisentraut writes: > I have committed this now, since the release of Python 3.7 is soon. > I'll let the build farm have a pass at it, then backport it for the > upcoming minor releases. If you're intending to push this into the back branches before Monday's releases, please do it *today*, t

Compiler warnings with --enable-dtrace

2018-05-05 Thread Thomas Munro
Hi hackers, --enable-dtrace produces compiler warnings about const correctness, except on macOS. That's because Apple's dtrace produces function declarations in probes.h that take strings as const char * whereas AFAIK on all other operating systems they take char * (you can see that possibly rece

Re: Explain buffers wrong counter with parallel plans

2018-05-05 Thread Amit Kapila
On Fri, May 4, 2018 at 10:35 PM, Robert Haas wrote: > On Wed, May 2, 2018 at 11:37 AM, Adrien Nayrat > wrote: >> In 9.6 gather node reports sum of buffers for main process + workers. In 10, >> gather node only reports buffers from the main process. > > Oh, really? Well, that sounds like a bug.

Re: [HACKERS] Clock with Adaptive Replacement

2018-05-05 Thread Yura Sokolov
05.05.2018 09:16, Andrey Borodin пишет: > Hi! > >> 4 мая 2018 г., в 16:05, Юрий Соколов >> написал(а): >> >> I didn't suggest log scale of usages, but rather >> "replacement-period based" increment: usage count could be >> incremented at most once in NBlocks/32 replaced items. Once it is >> incr