Re: [HACKERS] Planning counters in pg_stat_statements

to QueryDesc via PortalDefineQuery(). Of course, this requires more changes, but the result might be worth it. What do you think? -- Dmitry Ivanov Postgres Professional: http://www.postgrespro.com The Russian Postgres Company

Re: [HACKERS] Planning counters in pg_stat_statements

uld return pointer to some struct holding PlannedStmt and a List of some nodes or structs for accounting. -- Dmitry Ivanov Postgres Professional: http://www.postgrespro.com The Russian Postgres Company

Re: [HACKERS] make async slave to wait for lsn to be replayed

to trigger, or just one will suffice (ANY). IMO the syntax could be extended to something like: WAIT FOR [ANY | ALL] event [, event ...] options, with ANY being the default variant. -- Dmitry Ivanov Postgres Professional: http://www.postgrespro.com The Russian Postgres Company

Re: new function for tsquery creartion

. I'm sorry, I totally forgot to fix a few more things, the patch is attached below. -- Dmitry Ivanov Postgres Professional: http://www.postgrespro.com The Russian Postgres Companydiff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 5abb1c46fb..c3b7be6e4e 100644 --- a/doc/src/sgml

Re: new function for tsquery creartion

feedback is very welcome. -- Dmitry Ivanov Postgres Professional: http://www.postgrespro.com The Russian Postgres Companydiff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 5abb1c46fb..c3b7be6e4e 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -9609,6 +9609,18

Re: new function for tsquery creartion

of rules, for instance "split all words containing digits". I propose merging this patch provided that there are no objections. -- Dmitry Ivanov Postgres Professional: http://www.postgrespro.com The Russian Postgres Companydiff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml inde

Re: new function for tsquery creartion

select websearch_to_tsquery('simple', 'abc or!def'); websearch_to_tsquery -- 'abc' | 'def' (1 row) This is wrong ofc, I've attached the fixed version. -- Dmitry Ivanov Postgres Professional: http://www.postgrespro.com The Russian Postgres Companydiff --git a/src/backend

Re: new function for tsquery creartion

y('simple', '\'); ERROR: there is no escaped character: "\" Maybe there's more. The question is: should we fix those, or it's fine as it is? I don't have a strong opinion about this. -- Dmitry Ivanov Postgres Professional: http://www.postgrespro.com The Russian Postgres Companydiff --git

Re: new function for tsquery creartion

n it's committed. The following version of patch won't support AROUND(N). I have to fix a few more questionable things, though. -- Dmitry Ivanov Postgres Professional: http://www.postgrespro.com The Russian Postgres Company

Re: new function for tsquery creartion

ntype, so I decided to use this naming scheme. -- Dmitry Ivanov Postgres Professional: http://www.postgrespro.com The Russian Postgres Companydiff --git a/src/backend/tsearch/to_tsany.c b/src/backend/tsearch/to_tsany.c index ea5947a3a8..6055fb6b4e 100644 --- a/src/backend/tsearch/to_tsany.c +++ b/src/

Re: new function for tsquery creartion

the old test still appears in an example in doc/src/sgml/textsearch.sgml. Will fix this. -- Dmitry Ivanov Postgres Professional: http://www.postgrespro.com The Russian Postgres Company

Re: new function for tsquery creartion

I've fixed a bug and added some tests and documentation. -- Dmitry Ivanov Postgres Professional: http://www.postgrespro.com The Russian Postgres Companydiff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 5abb1c46fb..c3b7be6e4e 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml

Re: [HACKERS] GSoC 2017: weekly progress reports (week 6)

I'd like to see fastupdate=on in test too, now tests cover only case without fastupdate. Please, add them. Here's a couple of tests for pending list (fastupdate = on). -- Dmitry Ivanov Postgres Professional: http://www.postgrespro.com The Russian Postgres Companydiff --git a/src/backend/access

Re: [HACKERS] GSoC 2017: weekly progress reports (week 6)

"c1" "wy4" "c2" doesn't produce an ERROR? -- Dmitry Ivanov Postgres Professional: http://www.postgrespro.com The Russian Postgres Company

Re: new function for tsquery creartion

Hi David, I'd like to take over from Victor. I'll post a revised version of the patch in a couple of days. -- Dmitry Ivanov Postgres Professional: http://www.postgrespro.com The Russian Postgres Company