Re: [HACKERS] SQL/JSON in PostgreSQL

2018-01-09 Thread Pavel Stehule
2018-01-09 21:44 GMT+01:00 Andrew Dunstan : > > > On 01/02/2018 05:23 PM, Andrew Dunstan wrote: > > > > On 01/02/2018 05:04 PM, Nikita Glukhov wrote: > >> I have removed all extra features from the patch set, they can be > >> found in our > >> github repository: > >> https://github.com/postgrespro

Re: CREATE ROUTINE MAPPING

2018-01-12 Thread Pavel Stehule
2018-01-12 10:02 GMT+01:00 Ashutosh Bapat : > On Fri, Jan 12, 2018 at 8:07 AM, Corey Huinker > wrote: > > A few months ago, I was researching ways for formalizing calling > functions > > on one postgres instance from another. RPC, basically. In doing so, I > > stumbled across an obscure part of t

Re: [HACKERS] Re: proposal - psql: possibility to specify sort for describe commands, when size is printed

2018-01-12 Thread Pavel Stehule
Hi 2018-01-12 2:35 GMT+01:00 Thomas Munro : > On Thu, Nov 2, 2017 at 12:44 AM, Pavel Stehule > wrote: > > I am sending updated patch with some basic doc > > Hi Pavel, > > I am not sure what the status of this patch is, but FYI: > > startup.c: In function ‘main’:

polymorphic parameters limits - correct solution?

2018-01-15 Thread Pavel Stehule
Hi I played with introduction of new pair of Polymorphic Parameters - like anyXelement and anyXarray. Now, I don't think so enhancing PP is good way now. Without significant redesign there are not practical append more code there. Why this is a issue? The extension's authors are not able to speci

Re: [HACKERS] proposal: psql command \graw

2018-01-15 Thread Pavel Stehule
2018-01-15 18:40 GMT+01:00 Alexander Korotkov : > Hi! > > On Mon, Dec 4, 2017 at 6:42 PM, Pavel Stehule > wrote: > >> 2017-12-04 9:29 GMT+01:00 Alexander Korotkov : >> >>> On Mon, Dec 4, 2017 at 11:21 AM, Alexander Korotkov < >>> a.korot...@pos

Re: polymorphic parameters limits - correct solution?

2018-01-15 Thread Pavel Stehule
2018-01-16 3:21 GMT+01:00 Alvaro Herrera : > Pavel Stehule wrote: > > Hi > > > > I played with introduction of new pair of Polymorphic Parameters - like > > anyXelement and anyXarray. Now, I don't think so enhancing PP is good way > > now. Without signif

Re: Built-in connection pooling

2018-01-19 Thread Pavel Stehule
When I've been thinking about adding a built-in connection pool, my >> rough plan was mostly "bgworker doing something like pgbouncer" (that >> is, listening on a separate port and proxying everything to regular >> backends). Obviously, that has pros and cons, and probably would not >> work serve t

Re: Built-in connection pooling

2018-01-19 Thread Pavel Stehule
2018-01-19 17:53 GMT+01:00 Konstantin Knizhnik : > > > On 19.01.2018 19:28, Pavel Stehule wrote: > > > > When I've been thinking about adding a built-in connection pool, my >>> rough plan was mostly "bgworker doing something like pgbouncer" (that >

Re: pgbench - add \if support

2018-01-21 Thread Pavel Stehule
2018-01-21 23:31 GMT+01:00 Craig Ringer : > On 16 January 2018 at 06:28, Fabien COELHO wrote: > >> >> Here is a rebase. I made some tests use actual expressions instead of just 0 and 1. No other changes. >>> >>> Sigh. Better with the attachment. Sorry for the noise. >>> >> >> Here is a

Re: pgbench - add \if support

2018-01-22 Thread Pavel Stehule
2018-01-22 10:45 GMT+01:00 Fabien COELHO : > > few scripting features doesn't mean scripting language. \if in psql is nice >> feature that reduce duplicate code, unreadable code, and helps with >> deployment and test scripts. pgbench and psql should to have similar >> environment - and I am thinki

Re: [HACKERS] proposal - Default namespaces for XPath expressions (PostgreSQL 11)

2018-01-23 Thread Pavel Stehule
last > comment from me. > > At Fri, 24 Nov 2017 18:32:43 +0100, Pavel Stehule > wrote in mail.gmail.com> > > 2017-11-24 18:13 GMT+01:00 Pavel Stehule : > > > > > > > > > > > 2017-11-24 17:53 GMT+01:00 Pavel Stehule : > >

Re: [HACKERS] PoC plpgsql - possibility to force custom or generic plan

2018-01-23 Thread Pavel Stehule
2018-01-23 15:35 GMT+01:00 Robert Haas : > On Mon, Jan 22, 2018 at 5:15 PM, Stephen Frost wrote: > > Pavel, > > > > * Pavel Stehule (pavel.steh...@gmail.com) wrote: > >> here is a GUC based patch for plancache controlling. Looks so this code > is > >> wo

Re: [HACKERS] PoC plpgsql - possibility to force custom or generic plan

2018-01-23 Thread Pavel Stehule
2018-01-22 23:15 GMT+01:00 Stephen Frost : > Pavel, > > * Pavel Stehule (pavel.steh...@gmail.com) wrote: > > here is a GUC based patch for plancache controlling. Looks so this code > is > > working. > > This really could use a new thread, imv. This thread is a yea

Re: [HACKERS] proposal - Default namespaces for XPath expressions (PostgreSQL 11)

2018-01-24 Thread Pavel Stehule
last > comment from me. > > At Fri, 24 Nov 2017 18:32:43 +0100, Pavel Stehule > wrote in mail.gmail.com> > > 2017-11-24 18:13 GMT+01:00 Pavel Stehule : > > > > > > > > > > > 2017-11-24 17:53 GMT+01:00 Pavel Stehule : > >

Re: plpgsql function startup-time improvements

2018-01-24 Thread Pavel Stehule
Hi 2017-12-27 21:38 GMT+01:00 Tom Lane : > Attached are patches for two performance-improvement ideas that came > to me while working on > https://www.postgresql.org/message-id/8962.1514399...@sss.pgh.pa.us > The three patches are logically independent and could be committed in > any order. But

Re: plpgsql function startup-time improvements

2018-01-25 Thread Pavel Stehule
Hi 2018-01-25 0:16 GMT+01:00 Tom Lane : > Pavel Stehule writes: > > please, can you rebase all three patches necessary for patching? > > Done. These now need to be applied over > https://www.postgresql.org/message-id/833.1516834...@sss.pgh.pa.us Thank you I checked i

Re: [HACKERS] proposal: psql command \graw

2018-01-27 Thread Pavel Stehule
2018-01-27 15:22 GMT+01:00 Daniel Verite : > Pavel Stehule wrote: > > > We are able to generate html/tex/markdown formats on client side. CSV is > > more primitive, but much more important data format, so it should not be > a > > problem. But I remember some

Re: [HACKERS] MERGE SQL Statement for PG11

2018-01-29 Thread Pavel Stehule
Hi 2018-01-29 15:11 GMT+01:00 Simon Riggs : > On 26 January 2018 at 11:25, Simon Riggs wrote: > > On 24 January 2018 at 04:12, Simon Riggs wrote: > >> On 24 January 2018 at 01:35, Peter Geoghegan wrote: > >>> > >> Please rebase, and post a new version. > >> > >> Will do, though I'm sure that's

Re: [HACKERS] MERGE SQL Statement for PG11

2018-01-29 Thread Pavel Stehule
2018-01-29 15:40 GMT+01:00 Simon Riggs : > On 29 January 2018 at 14:19, Pavel Stehule > wrote: > > >> The concurrency rules are very simple: > >> If a MATCHED row is concurrently updated/deleted > >> 1. We run EvalPlanQual > >> 2. If the updated row i

Re: [HACKERS] MERGE SQL Statement for PG11

2018-01-29 Thread Pavel Stehule
2018-01-29 18:08 GMT+01:00 Simon Riggs : > On 29 January 2018 at 16:23, Chapman Flack wrote: > > On 01/29/2018 11:13 AM, Simon Riggs wrote: > >> On 29 January 2018 at 15:44, Bruce Momjian wrote: > >>> Uh, if we know we are going to get question on this, the patch had > >>> better have an explana

Re: [HACKERS] PoC plpgsql - possibility to force custom or generic plan

2018-01-30 Thread Pavel Stehule
2018-01-30 9:06 GMT+01:00 Tatsuro Yamada : > On 2018/01/24 1:08, Pavel Stehule wrote: > >> >> >> 2018-01-22 23:15 GMT+01:00 Stephen Frost > sfr...@snowman.net>>: >> >> Pavel, >> >> >> * Pavel Stehule (pavel.steh...@gmail.com

Re: csv format for psql

2018-01-30 Thread Pavel Stehule
2018-01-30 9:31 GMT+01:00 Daniel Verite : > Hi, > > > This patch implements csv as an output format in psql > (\pset format csv). It's quite similar to the unaligned format, > except that it applies CSV quoting rules (obviously!) and that > it prints no footer and no title. > As with unaligned, a

Re: csv format for psql

2018-01-31 Thread Pavel Stehule
2018-01-31 13:58 GMT+01:00 Daniel Verite : > Pavel Stehule wrote: > > > This format is too important, so some special short or long option can be > > practical (it will be printed in help) > > > > some like --csv > > I guess -C/--csv could be used, like

CALL stmt, ERROR: unrecognized node type: 113 bug

2018-02-01 Thread Pavel Stehule
Hi I am playing with procedures little bit I found few bugs create procedure test(a int) as $$ begin raise notice '>>>%<<<', a; end; $$ language plpgsql; call test(10); -- ok postgres=# call test((select 10)); ERROR: unrecognized node type: 113 postgres=# \sf test ERROR: cache lookup fail

Re: [HACKERS] proposal: schema variables

2018-02-02 Thread Pavel Stehule
low. > > On Fri, Feb 2, 2018 at 3:06 PM, Pavel Stehule > wrote: > >> Hi >> >> I wrote proof concept of schema variables. The patch is not nice, but the >> functionality is almost complete (for scalars only) and can be good enough >> for playing with this

Re: Regexp named capture groups

2018-02-03 Thread Pavel Stehule
2018-02-03 11:19 GMT+01:00 Joel Jacobson : > Hi hackers, > > Is anyone working on this feature[1] also for PostgreSQL's regex engine? > > I'm thinking it could work something like this: > > joel=# \df regexp_match > List of functions >Schema | Name | Res

Re: csv format for psql

2018-02-04 Thread Pavel Stehule
2018-01-31 14:09 GMT+01:00 Pavel Stehule : > > > 2018-01-31 13:58 GMT+01:00 Daniel Verite : > >> Pavel Stehule wrote: >> >> > This format is too important, so some special short or long option can >> be >> > practical (it will be printed in

Re: csv format for psql

2018-02-05 Thread Pavel Stehule
2018-01-31 13:58 GMT+01:00 Daniel Verite : > Pavel Stehule wrote: > > > This format is too important, so some special short or long option can be > > practical (it will be printed in help) > > > > some like --csv > > I guess -C/--csv could be used, l

Re: CALL stmt, ERROR: unrecognized node type: 113 bug

2018-02-09 Thread Pavel Stehule
Hi 2018-02-09 7:56 GMT+01:00 Michael Paquier : > On Fri, Feb 02, 2018 at 04:07:28PM +0900, Michael Paquier wrote: > > You need to read that as "only a SubPlan can be executed after a SubLink > > has been processed by the planner", so please replace the last "latter" > > by "planner". > > (I forgo

Re: Using scalar function as set-returning: bug or feature?

2018-02-09 Thread Pavel Stehule
ort-sighted. The better way to do this is to complain if > the number of expressions is different from the number of target variables > (and the target variable is not a record-ish type). There's been at least > two patches for this earlier (one my me, and one by, I think Pavel >

Re: CALL stmt, ERROR: unrecognized node type: 113 bug

2018-02-09 Thread Pavel Stehule
2018-02-09 15:15 GMT+01:00 David G. Johnston : > On Fri, Feb 9, 2018 at 6:23 AM, Michael Paquier > wrote: > >> On Fri, Feb 09, 2018 at 12:02:57PM +0100, Pavel Stehule wrote: >> > 2018-02-09 7:56 GMT+01:00 Michael Paquier : >> > > The second problem involves a

Re: csv format for psql

2018-02-12 Thread Pavel Stehule
2018-02-12 15:33 GMT+01:00 Daniel Verite : > Pavel Stehule wrote: > > > some like "\pset format csv , header_off > > If we did that, we'd need to reconsider the interactions > of this with \t on|off and \pset footer on|off > and how to keep things cons

Re: CALL stmt, ERROR: unrecognized node type: 113 bug

2018-02-12 Thread Pavel Stehule
2018-02-12 18:17 GMT+01:00 Peter Eisentraut < peter.eisentr...@2ndquadrant.com>: > On 2/9/18 09:42, Tom Lane wrote: > > Meh. It doesn't look significantly different to me than the restriction > > that you can't have sub-selects in CHECK expressions, index expressions, > > etc. Obviously we need

Re: Selecting fields from a RowExpr

2019-10-27 Thread Pavel Stehule
Hi ne 27. 10. 2019 v 19:47 odesílatel Tom Lane napsal: > At pgconf.eu, someone whose name I've forgotten pointed out to me > that this doesn't work: > > regression=# select (row(1, 2.0)).f1; > ERROR: could not identify column "f1" in record data type > LINE 1: select (row(1, 2.0)).f1; >

Re: Proposition to use '==' as synonym for 'IS NOT DISTINCT FROM'

2019-10-28 Thread Pavel Stehule
po 28. 10. 2019 v 12:39 odesílatel Eugen Konkov napsal: > > x IS NOT DISTINCT FROM y > > > I'm vaguely imagining > > > x = {magic} y > > > where unlike Eugen's suggestion, "=" is the real name of the underlying > > comparison operator. For dump/restore this could be spelled verbo

Re: [Proposal] Add accumulated statistics

2019-10-30 Thread Pavel Stehule
út 15. 1. 2019 v 2:14 odesílatel Tsunakawa, Takayuki < tsunakawa.ta...@jp.fujitsu.com> napsal: > From: Pavel Stehule [mailto:pavel.steh...@gmail.com] > > the cumulated lock statistics maybe doesn't help with debugging - but it > > is very good indicator of database (i

Re: Adding percentile metrics to pg_stat_statements module

2019-10-31 Thread Pavel Stehule
čt 31. 10. 2019 v 16:51 odesílatel Igor Calabria napsal: > Hi everyone, > > I was taking a look at pg_stat_statements module and noticed that it does > not collect any percentile metrics. I believe that It would be really handy > to have those available and I'd love to contribute with this featur

idea - proposal - defining own psql commands

2019-10-31 Thread Pavel Stehule
Hi long time we are think how to allow add some custom commands in psql. I had a following idea 1. psql can has special buffer for custom queries. This buffer can be filled by special command \gdefq. This command will have two parameters - name and number of arguments. some like select * from p

Re: 64 bit transaction id

2019-11-01 Thread Pavel Stehule
Hi pá 1. 11. 2019 v 10:11 odesílatel Павел Ерёмин napsal: > Hi. > sorry for my English. > I want to once again open the topic of 64 bit transaction id. I did not > manage to find in the archive of the option that I want to discuss, so I > write. If I searched poorly, then please forgive me. > Th

Re: [Proposal] Global temporary tables

2019-11-01 Thread Pavel Stehule
pá 1. 11. 2019 v 17:09 odesílatel Konstantin Knizhnik < k.knizh...@postgrespro.ru> napsal: > > > On 01.11.2019 18:26, Robert Haas wrote: > > On Fri, Nov 1, 2019 at 11:15 AM Konstantin Knizhnik > > wrote: > >> It seems to me that I have found quite elegant solution for per-backend > statistic for

Re: [Proposal] Global temporary tables

2019-11-02 Thread Pavel Stehule
so 2. 11. 2019 v 8:18 odesílatel Julien Rouhaud napsal: > On Sat, Nov 2, 2019 at 6:31 AM Pavel Stehule > wrote: > > > > pá 1. 11. 2019 v 17:09 odesílatel Konstantin Knizhnik < > k.knizh...@postgrespro.ru> napsal: > >> > >> On 01.11.2019 18:26, Robert

Re: [Proposal] Global temporary tables

2019-11-02 Thread Pavel Stehule
so 2. 11. 2019 v 8:23 odesílatel Pavel Stehule napsal: > > > so 2. 11. 2019 v 8:18 odesílatel Julien Rouhaud > napsal: > >> On Sat, Nov 2, 2019 at 6:31 AM Pavel Stehule >> wrote: >> > >> > pá 1. 11. 2019 v 17:09 odesílatel Konstantin Kn

Re: dropdb --force

2019-11-02 Thread Pavel Stehule
pá 25. 10. 2019 v 4:55 odesílatel Amit Kapila napsal: > On Thu, Oct 24, 2019 at 8:22 PM Pavel Stehule > wrote: > > > > čt 24. 10. 2019 v 11:10 odesílatel Amit Kapila > napsal: > >> > >> While making some changes in the patch, I noticed that in > &g

Re: [Proposal] Global temporary tables

2019-11-02 Thread Pavel Stehule
And pg_catalog.pg_statistics_gtt() is set returning functions? > yes I afraid that it is not acceptable solution from performance point of view: > pg_statictic table is accessed by keys (,,) > I don't think so it is problem. The any component, that needs to use fast access can use some special f

Re: dropdb --force

2019-11-02 Thread Pavel Stehule
Hi so 2. 11. 2019 v 17:18 odesílatel Pavel Stehule napsal: > > > pá 25. 10. 2019 v 4:55 odesílatel Amit Kapila > napsal: > >> On Thu, Oct 24, 2019 at 8:22 PM Pavel Stehule >> wrote: >> > >> > čt 24. 10. 2019 v 11:10 odesílatel Amit Kapila >&g

Re: dropdb --force

2019-11-02 Thread Pavel Stehule
> I am sending patch where kill was replaced by SendProcSignal. I tested it > on pg_bench with 400 connections, and it works without problems. > I tested it under high load and it is works. But it is slower than just kill - under load the killing 400 connections needs about 1.5 sec. Maybe for for

Re: The flinfo->fn_extra question, from me this time.

2019-11-03 Thread Pavel Stehule
Hi ne 3. 11. 2019 v 12:51 odesílatel Dent John napsal: > (And here’s aforementioned attachment… doh.) > can be nice, if patch has some regress tests - it is good for memory refreshing what is target of patch. Regards Pavel

Re: [HACKERS] proposal: schema variables

2019-11-03 Thread Pavel Stehule
čt 10. 10. 2019 v 11:41 odesílatel Pavel Stehule napsal: > Hi > > minor change - replace heap_tuple_fetch_attr by detoast_external_attr. > > similar update - heap_open, heap_close was replaced by table_open, table_close Regards Pavel schema_variables-20191103.patch

Re: Getting psql to redisplay command after \e

2019-11-03 Thread Pavel Stehule
ne 3. 11. 2019 v 20:58 odesílatel Fabien COELHO napsal: > > Hello Tom, > > >> I was suggesting something much simpler than rethinking readline > handling. > >> Does not mean that it is a good idea, but while testing the patch I > would > >> have liked the unfinished line to be in the current edit

Re: patch: psql - enforce constant width of last column

2019-11-04 Thread Pavel Stehule
Hi po 4. 11. 2019 v 21:55 odesílatel Tom Lane napsal: > Pavel Stehule writes: > > st 18. 9. 2019 v 12:52 odesílatel Ahsan Hadi > napsal: > >> does this patch have any value for psql without pspg? > > > The benefit of this patch is just for pspg users today. &

Re: Why overhead of SPI is so large?

2019-11-05 Thread Pavel Stehule
Hi pá 23. 8. 2019 v 16:32 odesílatel Konstantin Knizhnik < k.knizh...@postgrespro.ru> napsal: > > > On 23.08.2019 14:42, Pavel Stehule wrote: > > > In reality it is not IMMUTABLE function. On second hand, there are lot of > application that depends on this behave. &g

Re: Checking return value of SPI_execute

2019-11-05 Thread Pavel Stehule
st 6. 11. 2019 v 5:28 odesílatel Michael Paquier napsal: > On Tue, Nov 05, 2019 at 05:21:25PM -0800, Mark Dilger wrote: > > please find attached a patch fixing a problem previously discussed [1] > about > > the code inappropriately ignoring the return value from SPI_execute. > > > > I will be add

Re: Checking return value of SPI_execute

2019-11-06 Thread Pavel Stehule
st 6. 11. 2019 v 8:56 odesílatel Michael Paquier napsal: > On Wed, Nov 06, 2019 at 06:54:16AM +0100, Pavel Stehule wrote: > > Is generic question if this exception should not be raised somewhere in > > spi.c - maybe at SPI_execute. > > > > When you look to SPI_execut

Re: Checking return value of SPI_execute

2019-11-06 Thread Pavel Stehule
st 6. 11. 2019 v 16:38 odesílatel Mark Dilger napsal: > > > On 11/5/19 9:54 PM, Pavel Stehule wrote: > > > > > > st 6. 11. 2019 v 5:28 odesílatel Michael Paquier > <mailto:mich...@paquier.xyz>> napsal: > > > > On Tue, Nov 05, 2019 at 05:

Re: dropdb --force

2019-11-06 Thread Pavel Stehule
st 6. 11. 2019 v 14:59 odesílatel Tom Lane napsal: > Amit Kapila writes: > > I think there is still a window where the same problem can happen, say > > the signal has been sent by SendProcSignal to the required process and > > it releases the ProcArrayLock. Now, the target process exits and a >

Re: dropdb --force

2019-11-06 Thread Pavel Stehule
čt 7. 11. 2019 v 3:42 odesílatel Amit Kapila napsal: > On Wed, Nov 6, 2019 at 11:46 PM Pavel Stehule > wrote: > > > > st 6. 11. 2019 v 14:59 odesílatel Tom Lane napsal: > >> > >> Amit Kapila writes: > >> > I think there is still a window w

Re: dropdb --force

2019-11-06 Thread Pavel Stehule
čt 7. 11. 2019 v 6:56 odesílatel Amit Kapila napsal: > On Thu, Nov 7, 2019 at 10:46 AM Pavel Stehule > wrote: > > > > čt 7. 11. 2019 v 3:42 odesílatel Amit Kapila > napsal: > >> > >> On Wed, Nov 6, 2019 at 11:46 PM Pavel Stehule > wrote: > >

Re: [Proposal] Global temporary tables

2019-11-07 Thread Pavel Stehule
čt 7. 11. 2019 v 10:30 odesílatel 曾文旌(义从) napsal: > > > > 2019年11月7日 上午12:08,Konstantin Knizhnik 写道: > > > > > > > > On 06.11.2019 16:24, 曾文旌(义从) wrote: > >> Dear Hackers > >> > >> > >> I attached the patch of GTT implementationI base on PG12. > >> The GTT design came from my first email. > >> S

Re: Why overhead of SPI is so large?

2019-11-07 Thread Pavel Stehule
čt 7. 11. 2019 v 13:03 odesílatel Kyotaro Horiguchi napsal: > Hello. > > At Tue, 5 Nov 2019 22:14:40 +0100, Pavel Stehule > wrote in > > Hi > > > > pá 23. 8. 2019 v 16:32 odesílatel Konstantin Knizhnik < > > k.knizh...@postgrespro.ru> napsal: > &

Re: [Proposal] Global temporary tables

2019-11-07 Thread Pavel Stehule
čt 7. 11. 2019 v 13:17 odesílatel 曾文旌(义从) napsal: > > > 2019年11月7日 下午5:40,Pavel Stehule 写道: > > > > čt 7. 11. 2019 v 10:30 odesílatel 曾文旌(义从) > napsal: > >> >> >> > 2019年11月7日 上午12:08,Konstantin Knizhnik 写道: >> > >> >

Re: dropdb --force

2019-11-07 Thread Pavel Stehule
pá 8. 11. 2019 v 6:39 odesílatel Amit Kapila napsal: > On Thu, Nov 7, 2019 at 11:29 AM Pavel Stehule > wrote: > > čt 7. 11. 2019 v 6:56 odesílatel Amit Kapila > napsal: > >> > >> Okay, no problem. I will pick the previous version and do this. I > >&

Re: SPI refactoring

2019-11-07 Thread Pavel Stehule
pá 8. 11. 2019 v 0:39 odesílatel Mark Dilger napsal: > Hackers, > > As discussed with Tom in [1] and again with Pavel and Alvaro in [2], > here is a partial WIP refactoring of the SPI interface. The goal is to > remove as many of the SPI_ERROR_xxx codes as possible from the > interface, replacin

Re: Refactor parse analysis of EXECUTE command

2019-11-07 Thread Pavel Stehule
út 5. 11. 2019 v 11:28 odesílatel Kyotaro Horiguchi napsal: > Hello. > > At Mon, 4 Nov 2019 08:53:18 +0100, Peter Eisentraut < > peter.eisentr...@2ndquadrant.com> wrote in > > On 2019-11-02 16:00, Tom Lane wrote: > > > Peter Eisentraut writes: > > >> This patch moves the parse analysis component

Re: Refactor parse analysis of EXECUTE command

2019-11-07 Thread Pavel Stehule
po 4. 11. 2019 v 8:53 odesílatel Peter Eisentraut < peter.eisentr...@2ndquadrant.com> napsal: > On 2019-11-02 16:00, Tom Lane wrote: > > Peter Eisentraut writes: > >> This patch moves the parse analysis component of ExecuteQuery() and > >> EvaluateParams() into a new transformExecuteStmt() that i

Re: Refactor parse analysis of EXECUTE command

2019-11-08 Thread Pavel Stehule
pá 8. 11. 2019 v 8:54 odesílatel Peter Eisentraut < peter.eisentr...@2ndquadrant.com> napsal: > On 2019-11-08 08:13, Pavel Stehule wrote: > > I dug into repository and found that transformExecuteStmt existed at > > the time of implementing PREPARE-EXECUTE state

Re: dropdb --force

2019-11-08 Thread Pavel Stehule
pá 8. 11. 2019 v 6:40 odesílatel Pavel Stehule napsal: > > > pá 8. 11. 2019 v 6:39 odesílatel Amit Kapila > napsal: > >> On Thu, Nov 7, 2019 at 11:29 AM Pavel Stehule >> wrote: >> > čt 7. 11. 2019 v 6:56 odesílatel Amit Kapila >> napsal: >> >

Re: dropdb --force

2019-11-08 Thread Pavel Stehule
pá 8. 11. 2019 v 11:50 odesílatel Amit Kapila napsal: > On Fri, Nov 8, 2019 at 4:13 PM Pavel Stehule > wrote: > > > >>> Did you get a chance to look at the other related patch posted by me > >>> [1]? I have asked it before as well because I think that need

Re: Refactor parse analysis of EXECUTE command

2019-11-08 Thread Pavel Stehule
pá 8. 11. 2019 v 13:34 odesílatel Peter Eisentraut < peter.eisentr...@2ndquadrant.com> napsal: > On 2019-11-08 09:03, Pavel Stehule wrote: > > Parse analysis of EXECUTE does not access any tables, so if I > > understood > > this correctly, this

Re: Why overhead of SPI is so large?

2019-11-08 Thread Pavel Stehule
pá 8. 11. 2019 v 14:31 odesílatel Konstantin Knizhnik < k.knizh...@postgrespro.ru> napsal: > > > On 07.11.2019 15:09, Pavel Stehule wrote: > > > > čt 7. 11. 2019 v 13:03 odesílatel Kyotaro Horiguchi < > horikyota@gmail.com> napsal: > >> Hello. &

proposal: minscale, rtrim, btrim functions for numeric

2019-11-09 Thread Pavel Stehule
Hi, four years ago Marko Tiikkaja send a patch for numeric_trim functions. This functions removed ending zeroes from numeric value. This is useful feature, but there was not any progress on this patch. I think so this feature can be interesting, so I would to revitalize this patch. Original discu

Re: proposal: minscale, rtrim, btrim functions for numeric

2019-11-09 Thread Pavel Stehule
so 9. 11. 2019 v 21:34 odesílatel Tom Lane napsal: > Pavel Stehule writes: > > four years ago Marko Tiikkaja send a patch for numeric_trim functions. > This > > functions removed ending zeroes from numeric value. This is useful > feature, > > but there was not an

Re: proposal: minscale, rtrim, btrim functions for numeric

2019-11-11 Thread Pavel Stehule
ne 10. 11. 2019 v 7:35 odesílatel Pavel Stehule napsal: > > > so 9. 11. 2019 v 21:34 odesílatel Tom Lane napsal: > >> Pavel Stehule writes: >> > four years ago Marko Tiikkaja send a patch for numeric_trim functions. >> This >> > functions removed

Re: SQL/JSON: JSON_TABLE

2019-11-11 Thread Pavel Stehule
út 12. 11. 2019 v 1:13 odesílatel Nikita Glukhov napsal: > Attached 40th version of the patches. > > > On 19.10.2019 18:31, Pavel Stehule wrote: > > This patch is still pretty big - it is about 6000 lines (without any > documentation). I checked the standard - and this p

Re: SQL/JSON: JSON_TABLE

2019-11-12 Thread Pavel Stehule
Hi please, can you rebase 0001-SQL-JSON-functions-v40.patch. I have a problem with patching Pavel

Re: Invisible PROMPT2

2019-11-12 Thread Pavel Stehule
st 13. 11. 2019 v 4:15 odesílatel Thomas Munro napsal: > Hello hackers, > > From the advanced bikeshedding department: I'd like my psql > transcripts to have the usual alignment, but be easier to copy and > paste later without having weird prompt stuff in the middle. How > about a prompt format

Re: dropdb --force

2019-11-12 Thread Pavel Stehule
st 13. 11. 2019 v 7:12 odesílatel Amit Kapila napsal: > On Tue, Nov 12, 2019 at 11:17 AM Amit Kapila > wrote: > > > > I am planning to commit this patch tomorrow unless I see more comments > > or interest from someone else to review this. > > > > Pushed. Pavel, feel free to submit dropdb utilit

Re: BUG #16109: Postgres planning time is high across version - 10.6 vs 10.10

2019-11-13 Thread Pavel Stehule
st 13. 11. 2019 v 11:39 odesílatel Julien Rouhaud napsal: > (moved to -hackers) > > On Tue, Nov 12, 2019 at 9:55 PM Andres Freund wrote: > > > > This last point is more oriented towards other PG developers: I wonder > > if we ought to display buffer statistics for plan time, for EXPLAIN > > (BUF

Re: dropdb --force

2019-11-13 Thread Pavel Stehule
st 13. 11. 2019 v 7:13 odesílatel Pavel Stehule napsal: > > > st 13. 11. 2019 v 7:12 odesílatel Amit Kapila > napsal: > >> On Tue, Nov 12, 2019 at 11:17 AM Amit Kapila >> wrote: >> > >> > I am planning to commit this patch tomorrow unless I see mor

Re: dropdb --force

2019-11-13 Thread Pavel Stehule
st 13. 11. 2019 v 15:34 odesílatel Pavel Stehule napsal: > > > st 13. 11. 2019 v 7:13 odesílatel Pavel Stehule > napsal: > >> >> >> st 13. 11. 2019 v 7:12 odesílatel Amit Kapila >> napsal: >> >>> On Tue, Nov 12, 2019 at 11:17 AM Amit Kapil

Re: dropdb --force

2019-11-13 Thread Pavel Stehule
čt 14. 11. 2019 v 7:44 odesílatel Amit Kapila napsal: > On Thu, Nov 14, 2019 at 11:43 AM Pavel Stehule > wrote: > > > > st 13. 11. 2019 v 15:34 odesílatel Pavel Stehule < > pavel.steh...@gmail.com> napsal: > >> > >> > >> here it is. I

Re: dropdb --force

2019-11-14 Thread Pavel Stehule
čt 14. 11. 2019 v 12:12 odesílatel vignesh C napsal: > On Wed, Nov 13, 2019 at 8:05 PM Pavel Stehule > wrote: > > > > > > > > st 13. 11. 2019 v 7:13 odesílatel Pavel Stehule > napsal: > >> > >> > >> > >> st 13. 11. 2019 v 7:

Re: SQL/JSON: JSON_TABLE

2019-11-15 Thread Pavel Stehule
Hi út 12. 11. 2019 v 22:51 odesílatel Nikita Glukhov napsal: > On 12.11.2019 20:54, Pavel Stehule wrote: > > > Hi > > > > please, can you rebase 0001-SQL-JSON-functions-v40.patch. I have a > > problem with patching > > > > Pavel > > Attached

Re: jsonb_set() strictness considered harmful to data

2019-11-15 Thread Pavel Stehule
Hi > For release 13+, I have given some more thought to what should be done. > I think the bar for altering the behaviour of a function should be > rather higher than we have in the present case, and the longer the > function has been sanctioned by time the higher the bar should be. > However, I

Re: jsonb_set() strictness considered harmful to data

2019-11-15 Thread Pavel Stehule
pá 15. 11. 2019 v 21:01 odesílatel Andrew Dunstan < andrew.duns...@2ndquadrant.com> napsal: > > On 11/15/19 2:14 PM, Pavel Stehule wrote: > > Hi > > > > > > > > For release 13+, I have given some more thought to what should be > > done. &g

Re: dropdb --force

2019-11-15 Thread Pavel Stehule
so 16. 11. 2019 v 1:10 odesílatel vignesh C napsal: > On Fri, Nov 15, 2019 at 1:23 PM Pavel Stehule > wrote: > > > > updated patch attached > > > > Thanks Pavel for providing updated version. > Few comments: > I felt the help text seems incomplete: &

Re: SQL/JSON: JSON_TABLE

2019-11-17 Thread Pavel Stehule
Hi út 12. 11. 2019 v 22:51 odesílatel Nikita Glukhov napsal: > On 12.11.2019 20:54, Pavel Stehule wrote: > > > Hi > > > > please, can you rebase 0001-SQL-JSON-functions-v40.patch. I have a > > problem with patching > > > > Pavel > > Attached

Re: dropdb --force

2019-11-17 Thread Pavel Stehule
po 18. 11. 2019 v 4:43 odesílatel vignesh C napsal: > On Sat, Nov 16, 2019 at 1:25 PM Pavel Stehule > wrote: > >> > > >> > updated patch attached > >> > > >> > >> Thanks Pavel for providing updated version. > >> Few comment

Re: dropdb --force

2019-11-17 Thread Pavel Stehule
po 18. 11. 2019 v 6:24 odesílatel Amit Kapila napsal: > On Mon, Nov 18, 2019 at 10:33 AM Pavel Stehule > wrote: > > > > po 18. 11. 2019 v 4:43 odesílatel vignesh C > napsal: > >> > >> > >> When we don't specify -e option, the quer

Re: dropdb --force

2019-11-17 Thread Pavel Stehule
po 18. 11. 2019 v 7:37 odesílatel Amit Kapila napsal: > On Mon, Nov 18, 2019 at 10:59 AM Pavel Stehule > wrote: > > po 18. 11. 2019 v 6:24 odesílatel Amit Kapila > napsal: > >> > >> On Mon, Nov 18, 2019 at 10:33 AM Pavel Stehule > wrote: > >> >

Re: dropdb --force

2019-11-18 Thread Pavel Stehule
po 18. 11. 2019 v 7:39 odesílatel Pavel Stehule napsal: > > > po 18. 11. 2019 v 7:37 odesílatel Amit Kapila > napsal: > >> On Mon, Nov 18, 2019 at 10:59 AM Pavel Stehule >> wrote: >> > po 18. 11. 2019 v 6:24 odesílatel Amit Kapila >> napsal: >>

Re: [HACKERS] proposal: schema variables

2019-11-18 Thread Pavel Stehule
ne 3. 11. 2019 v 17:27 odesílatel Pavel Stehule napsal: > > > čt 10. 10. 2019 v 11:41 odesílatel Pavel Stehule > napsal: > >> Hi >> >> minor change - replace heap_tuple_fetch_attr by detoast_external_attr. >> >> > similar update - heap_open, heap

Re: range_agg

2019-11-19 Thread Pavel Stehule
Hi čt 7. 11. 2019 v 3:36 odesílatel Paul A Jungwirth < p...@illuminatedcomputing.com> napsal: > On Wed, Nov 6, 2019 at 3:02 PM Paul A Jungwirth > wrote: > > On Thu, Sep 26, 2019 at 2:13 PM Alvaro Herrera > wrote: > > > Hello Paul, I've started to review this patch. Here's a few minor > > > thi

Re: Internal function returning pg_statistic

2019-11-20 Thread Pavel Stehule
Hi st 20. 11. 2019 v 10:59 odesílatel Konstantin Knizhnik < k.knizh...@postgrespro.ru> napsal: > Hi hackers, > > Working on global temporary table I need to define function which > returns set of pg_statistic records. > Unfortunately I failed to declare such function! > Type pg_statistic is defin

Re: dropdb --force

2019-11-20 Thread Pavel Stehule
st 20. 11. 2019 v 12:40 odesílatel Amit Kapila napsal: > On Mon, Nov 18, 2019 at 10:59 AM Pavel Stehule > wrote: > > po 18. 11. 2019 v 6:24 odesílatel Amit Kapila > napsal: > >> > >> > >> I have slightly modified the main patch and attached is the re

Re: range_agg

2019-11-21 Thread Pavel Stehule
st 20. 11. 2019 v 20:32 odesílatel Paul A Jungwirth < p...@illuminatedcomputing.com> napsal: > On Tue, Nov 19, 2019 at 9:49 PM Paul A Jungwirth > wrote: > > > > On Tue, Nov 19, 2019 at 1:17 AM Pavel Stehule > wrote: > > > Hi > > > I tested last patch

Re: SQL/JSON: JSON_TABLE

2019-11-21 Thread Pavel Stehule
čt 21. 11. 2019 v 17:31 odesílatel Nikita Glukhov napsal: > On 17.11.2019 13:35, Pavel Stehule wrote: > > Hi > > út 12. 11. 2019 v 22:51 odesílatel Nikita Glukhov > napsal: > >> On 12.11.2019 20:54, Pavel Stehule wrote: >> >> > Hi >> > >

Re: dropdb --force

2019-11-21 Thread Pavel Stehule
čt 21. 11. 2019 v 6:33 odesílatel vignesh C napsal: > On Mon, Nov 18, 2019 at 6:30 PM Pavel Stehule > wrote: > >> > >> I'll send this test today > > > > > > here is it > > > > Thanks for adding the test. > Few comments: > Thi

Re: Why overhead of SPI is so large?

2019-11-21 Thread Pavel Stehule
čt 21. 11. 2019 v 10:31 odesílatel Konstantin Knizhnik < k.knizh...@postgrespro.ru> napsal: > > > I've set the CF entry to "Waiting on Author" pending a new patch > > that does it like that. > > With contain_mutable_functions the patch becomes trivial. > Stable functions doesn't need own snapshot

obsolete example

2019-11-21 Thread Pavel Stehule
Hi isn't src/tutorial/func.c obsolete? There is not any benefit for users. Regards Pavel

Re: obsolete example

2019-11-21 Thread Pavel Stehule
pá 22. 11. 2019 v 1:13 odesílatel Michael Paquier napsal: > On Thu, Nov 21, 2019 at 08:19:56PM -0300, Euler Taveira wrote: > > Em qui., 21 de nov. de 2019 às 15:59, Pavel Stehule > > escreveu: > >> > >> isn't src/tutorial/func.c obsolete? There is not an

<    2   3   4   5   6   7   8   9   10   11   >