Re: [HACKERS] Planning counters in pg_stat_statements

ught. Perhaps we could change planner() so that it would 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] Planning counters in pg_stat_statements

later be passed 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: new function for tsquery creartion

hile, and it seems that this should be fixed somewhere near parsetext(). Perhaps 'pg' and 'class' should share the same position. After all, somebody could implement a parser which would split some words using an arbitrary set of rules, for instance "split all words contai

Re: new function for tsquery creartion

lcome. 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/do

Re: new function for tsquery creartion

. Any 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 +96

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

Re: new function for tsquery creartion

t gettoken_query() returns ts_tokentype, 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/s

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

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

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/back

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 Rus

Re: new function for tsquery creartion

. A few gotchas: I haven't touched gettoken_tsvector() yet. As a result, the following queries produce errors: select websearch_to_tsquery('simple', ''''); ERROR: syntax error in tsquery: "'" select websearch_to_tsquery('simple',

Re: new function for tsquery creartion

x27;t contain lexemes, ignored"))); But 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

x27;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

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

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

e waiting for ALL of them 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