2017-06-08 17:19 GMT+02:00 Robert Haas :
> On Wed, Jun 7, 2017 at 12:30 PM, Pavel Stehule
> wrote:
> > I got strange error message - false message - max connection is less on
> > slave than on master, although these numbers was same. The issue was in
> > wrong connection
2017-06-14 5:53 GMT+02:00 Peter Eisentraut :
> On 6/13/17 17:08, Andres Freund wrote:
> > I wondered before if we shouldn't introduce "information only"
> > unenforced foreign key constraints for the catalogs. We kind of
> > manually do that via oidjoins, it'd be nicer if we'd a function
> > rech
2017-06-14 19:49 GMT+02:00 Andres Freund :
> On 2017-06-14 06:05:24 +0200, Pavel Stehule wrote:
> > 2017-06-14 5:53 GMT+02:00 Peter Eisentraut <
> peter.eisentr...@2ndquadrant.com
> > >:
> >
> > > On 6/13/17 17:08, Andres Freund wrote:
> > &g
2017-06-15 5:02 GMT+02:00 Andres Freund :
>
>
> On June 14, 2017 7:53:05 PM PDT, Pavel Stehule
> wrote:
> >2017-06-14 19:49 GMT+02:00 Andres Freund :
> >
> >> On 2017-06-14 06:05:24 +0200, Pavel Stehule wrote:
> >> > 2017-06-14 5:53 GM
2017-06-15 5:06 GMT+02:00 Andres Freund :
> On 2017-06-14 20:02:27 -0700, Andres Freund wrote:
> > On June 14, 2017 7:53:05 PM PDT, Pavel Stehule
> wrote:
> > >2017-06-14 19:49 GMT+02:00 Andres Freund :
> > >> > These constraints can slowdown creating/dropp
2017-06-14 19:56 GMT+02:00 Andres Freund :
> On 2017-06-12 10:32:57 -0400, Tom Lane wrote:
> > "Daniel Verite" writes:
> > > PGC_POSTMASTER implies that it's an instance-wide setting.
> > > Is is intentional? I can understand that it's more secure for this not
> to
> > > be changeable in an exist
Hi
I am thinking about printing graphs in psql (mainly some histograms). I
found so gnuplot is able do very good graphs in console. The one issue is
user friendly (with less steps) generating data in good format for this
application.
One my idea is introduction new simple output format and execut
2017-08-22 10:46 GMT+02:00 Fabien COELHO :
>
> Hello Pavel,
>
> One my idea is introduction new simple output format and execution command
>> with result in this format.
>>
>> It should work something like
>>
>> \setenv GNUPLOT_OPTION '..'
>> SELECT * FROM data
>> \graw | gnuplot ...
>>
>
> I
2017-08-22 10:36 GMT+02:00 Aleksander Alekseev :
> Hi Pavel,
>
> > I am thinking about printing graphs in psql (mainly some histograms). I
> > found so gnuplot is able do very good graphs in console. The one issue is
> > user friendly (with less steps) generating data in good format for this
> > a
Hi
2017-08-22 11:22 GMT+02:00 Pavel Stehule :
>
>
> 2017-08-22 10:46 GMT+02:00 Fabien COELHO :
>
>>
>> Hello Pavel,
>>
>> One my idea is introduction new simple output format and execution command
>>> with result in this format.
>>
Hi
2017-08-24 5:50 GMT+02:00 Fabien COELHO :
>
> Hello Pavel,
>
> I have added the patch to the next commitfest.
>
> Patch applies, compiles, works.
>
> I'm okay with the names graw/graw+, and for having such short-hands.
>
> Missing break in switch, even if last item and useless, because other
>
2017-08-24 8:53 GMT+02:00 Fabien COELHO :
>
> "column_header" is somehow redundant with "tuples_only". Use the
>>> existing one instead of adding a new one?
>>>
>>
>> It is different - a result of tuples_only is just tuples - not column
>> names, not title, footer. I needed new special flag for en
2017-08-24 17:27 GMT+02:00 Fabien COELHO :
>
> Hello,
>
> I'll wait to winter commitfest
>>
>
> Argh, sorry, I put it in the September commitfest, and it seems that it
> cannot be changed afterwards.
>
> Maybe you can close it and redeclare it in the commitfest you want?
>
It can be moved
>
> f
2017-08-26 8:54 GMT+02:00 Fabien COELHO :
>
> Hello,
>
> As a follow-up to the \if patch by Corey Huinker, here is a proposal to
> allow testing whether a client-side variable exists in psql.
>
> The syntax is as ugly as the current :'var' and :"var" things, but ISTM
> that this is the only simple
2017-08-26 19:55 GMT+02:00 Fabien COELHO :
>
> Any colon prefixed syntax can be made to work because it is enough for the
>> lexer to detect and handle... so
>>
>> :{defined varname}
>>
>> may be an option, although I do not like the space much because it adds
>> some fuzzyness in the lexer which
Hi
2017-08-24 19:24 GMT+02:00 Alexander Kuzmenkov :
> Hi Pavel,
>
> I tried applying your patch, it applies and compiles fine, check and
> checkworld pass.
>
> I ran a simple performance test, select concat(generate_series(1,10),
> ... [x5 total]) vs select generate_series(1,10)::text ||
2017-08-28 8:56 GMT+02:00 Fabien COELHO :
>
> I find myself regurgitating the incantation
>>
>> psql -qAtX -v ON_ERRORS_STOP=1
>>
>> quite a bit. It's not ... super friendly.
>>
>> It strikes me that we could possibly benefit from a 'psql --batch' option.
>>
>> Thoughts?
>>
>
> The link between -q
2017-08-28 9:33 GMT+02:00 Fabien COELHO :
>
> ISTM that the real pain is the "-v ON_ERRORS_STOP=1" which I occasionally
>>> encountered as well, the other one letter ones are not too bad. Maybe it
>>> would be enough to have a shortcut for this one, say "-B"?
>>>
>>
>> I agree with last sentence.
2017-08-28 11:05 GMT+02:00 Craig Ringer :
> On 28 August 2017 at 16:23, Fabien COELHO wrote:
>
>>
>> This doesn't really address the original issue though, that it's far from
>>> obvious how to easily and correctly script psql.
>>>
>>
>> That is another interesting argument. I understood that the
configure: using compiler=gcc (GCC) 7.1.1 20170622 (Red Hat 7.1.1-3)
configure: using CFLAGS=-Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
-Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard
-g -O2
configure
2017-09-02 6:15 GMT+02:00 Tom Lane :
> Pavel Stehule writes:
> > ./configure: line 15762: sort: No such file or directory
> > ./configure: line 15759: sed: No such file or directory
>
> /bin not in your PATH, perhaps?
>
I have not, but sed/sort I can use and
export PA
2017-09-02 6:27 GMT+02:00 Pavel Stehule :
>
>
> 2017-09-02 6:15 GMT+02:00 Tom Lane :
>
>> Pavel Stehule writes:
>> > ./configure: line 15762: sort: No such file or directory
>> > ./configure: line 15759: sed: No such file or directory
>>
>> /bin n
2017-09-02 13:28 GMT+02:00 Devrim Gündüz :
>
> Hi,
>
> On Sat, 2017-09-02 at 06:52 +0200, Pavel Stehule wrote:
> > but looks so it is Fedora26 issue - I see these lines elsewhere too.
>
> I cannot reproduce it on my F26 box.
>
I have to do deep research
Thank you f
Hi
2017-09-04 18:31 GMT+02:00 Tom Lane :
> So I thought we were done bikeshedding the variable names for this
> feature, but as I was reviewing the patch with intent to commit,
> I noticed you hadn't updated helpVariables() to mention them.
> Possibly you missed this because it doesn't mention VE
2017-09-04 18:56 GMT+02:00 Tom Lane :
> I wrote:
> > ... Or maybe we should shorten this
> > variable name so it doesn't force reformatting of all this text.
> > Possible ideas include "DB_VERSION_NAME", "SERVER_VER_NAME", or
> > "SERVER_VERSION_STR". (The last saves only one character, whereas
>
2017-09-04 19:08 GMT+02:00 Tom Lane :
> Pavel Stehule writes:
> > 2017-09-04 18:56 GMT+02:00 Tom Lane :
> >> Just had another idea: maybe make the new variable names
> >> SERVER_VERSION_S
> >> SERVER_VERSION_N
> >> VERSION_S
> >> VERSION_N
2017-09-04 19:35 GMT+02:00 Tom Lane :
> "Daniel Verite" writes:
> > The two-space left margin on the entire block does not add that
> > much to readability, IMV, so maybe we could reclaim these
> > two characters.
>
> Well, it's a sub-list of the entire output of helpVariables(), so
> I think som
2017-09-05 18:06 GMT+02:00 Tom Lane :
> Pavel Stehule writes:
> > [ psql-psql-pager-env-2.patch ]
>
> Pushed, with some fooling with the documentation (notably,
> re-alphabetizing relevant lists).
>
> Grepping turned up an additional place that's examining the
2017-09-05 15:01 GMT+02:00 Daniel Gustafsson :
> > On 08 Apr 2017, at 09:42, Pavel Stehule wrote:
> >
> > 2017-04-08 2:30 GMT+02:00 Peter Eisentraut <
> peter.eisentr...@2ndquadrant.com <mailto:peter.eisentr...@2ndquadrant.com
> >>:
> > On 4/6/17 14:32
2017-09-05 19:38 GMT+02:00 Tom Lane :
> Pavel Stehule writes:
> > 2. what syntax we should to use (if we accept this feature)? There was
> not
> > another proposal if I remember well - The PRAGMA syntax is strong because
> > we can very well specify to range where t
2017-09-06 0:18 GMT+02:00 Tom Lane :
> Fabien COELHO writes:
> > I did yet another rebase of your patch after Tom alphabetically ordered
> > backslash commands. Here is the result.
>
> Pushed with some massaging.
>
Thank you very much
>
> regards, tom lane
>
>
>
> I think a GUC is a decent, though not perfect, mechanism for this.
> This problem isn't restricted to PL/pgsql; indeed, the cases I've seen
> have come via prepared queries, not PL/pgsql functions. Even without
> that, one advantage of a GUC is that they are fairly broadly
> understood and e
2017-09-07 8:08 GMT+02:00 Anthony Bykov :
> The following review has been posted through the commitfest application:
> make installcheck-world: not tested
> Implements feature: not tested
> Spec compliant: not tested
> Documentation:not tested
>
> I'm afraid this patch
2017-09-07 19:48 GMT+02:00 Pavel Stehule :
>
>
> 2017-09-07 8:08 GMT+02:00 Anthony Bykov :
>
>> The following review has been posted through the commitfest application:
>> make installcheck-world: not tested
>> Implements feature: not tested
>>
Hi
2017-09-06 11:14 GMT+02:00 Fabien COELHO :
>
> Here is a version 6.
>>
>
> Small v7 update, sorry for the noise.
>
> Add testing the initial state of all variables.
>
> Fix typos in a comment in tests.
>
> Fix the documentation wrt the current implementation behavior.
I rechecked last patch
> >
> > Hmm. I think the core problem here is that we're trying to control
> > the plancache, which is a pretty much behind-the-scenes mechanism.
> > Except in the case of an explicit PREPARE, you can't even see from
> > SQL that the cache is being used, or when it's used. So part of what
> > nee
Hi
Now the output looks like:
AUTOCOMMIT
if set, successful SQL commands are automatically committed
COMP_KEYWORD_CASE
determines the case used to complete SQL key words
[lower, upper, preserve-lower, preserve-upper]
DBNAME
the currently connected database name
ECHO
co
2017-08-16 14:06 GMT+02:00 Pavel Stehule :
> Hi
>
> 2017-08-15 4:37 GMT+02:00 Peter Eisentraut com>:
>
>> On 3/11/17 07:06, Pavel Stehule wrote:
>> > I am sending a updated version with separated sort direction in special
>> > variable
>>
>>
2017-09-08 6:36 GMT+02:00 Erik Rijkers :
> On 2017-09-08 06:09, Pavel Stehule wrote:
>
>> Hi
>>
>> Now the output looks like:
>>
>> AUTOCOMMIT
>> if set, successful SQL commands are automatically committed
>> COMP_KEYWORD_CASE
>>
2017-09-08 19:14 GMT+02:00 Simon Riggs :
> On 6 September 2017 at 07:43, Robert Haas wrote:
>
> > LET custom_plan_tries = 0 IN SELECT ...
>
> Tom has pointed me at this proposal, since on another thread I asked
> for something very similar. (No need to reprise that discussion, but I
> wanted prep
2017-09-08 21:21 GMT+02:00 Daniel Gustafsson :
> > On 08 Sep 2017, at 19:14, Simon Riggs wrote:
> >
> > On 6 September 2017 at 07:43, Robert Haas wrote:
> >
> >> LET custom_plan_tries = 0 IN SELECT ...
> >
> > Tom has pointed me at this proposal, since on another thread I asked
> > for something
> >
> > SET x = .., y = .. SELECT ... ;
>
> This seems pretty ugly from a syntax perspective.
>
> We already have 'SET LOCAL', which manages scope to the current
> transaction. How about SET BLOCK which would set until you've left
> the current statement block?
>
This is reason why PRAGMA was des
Hi
2017-09-08 9:36 GMT+02:00 Jeevan Chalke :
> Hi Pavel,
>
> On Sat, May 20, 2017 at 11:55 AM, Pavel Stehule
> wrote:
>
>>
>>
>>
>> 2017-05-19 5:48 GMT+02:00 Pavel Stehule :
>>
>>>
>>>
>>> 2017-05-19 3:14 GMT+02:00 Peter Ei
Hi
2017-09-09 1:24 GMT+02:00 Tom Lane :
> Tomas Vondra writes:
> > The translator has exactly the same context in both cases, and the
> > struggle to wrap it at 80 characters will be pretty much the same too.
>
> Really? With the old way, you had something under 60 characters to
> work in, now
Hi
2017-09-09 11:02 GMT+02:00 Fabien COELHO :
>
> Hello Pavel,
>
> Here is a v13. No code changes, but TAP tests added to maintain pgbench
> coverage to green.
>
>
> Summary of patch contents:
>
> This patch extends pgbench expressions syntax while keeping compatibility
> with SQL expressions.
>
2017-09-08 23:09 GMT+02:00 Tom Lane :
> Pavel Stehule writes:
> > personally I prefer syntax without FOR keyword - because following
> keyword
> > must be reserved keyword
>
> > SET x = .., y = .. SELECT ... ;
>
> Nope. Most of the statement-starting keywords
2017-09-11 9:46 GMT+02:00 Jeevan Chalke :
> Hi Pavel,
>
>
> On Sat, Sep 9, 2017 at 11:42 AM, Pavel Stehule
> wrote:
>
>> Hi
>>
>> 2017-09-08 9:36 GMT+02:00 Jeevan Chalke :
>>
>>> Hi Pavel,
>>> I like the idea of using parameter name i
2017-09-11 20:46 GMT+02:00 Fabien COELHO :
>
> I think you're overly optimistic to believe that every failure will
have a SQLSTATE; I don't think that's true for libpq-reported errors,
such as connection loss.
>>>
>> Yep, I thought I was optimistic:-) Can I add a special SQLSTATE fo
2017-09-11 22:28 GMT+02:00 Tom Lane :
> Jeevan Chalke writes:
> [ psql-named-arguments-03-jeevan.patch ]
>
> Pushed with minor simplification of the test case.
>
> I'm not quite as convinced as Pavel that this is an improvement ---
> it will make error messages inconsistent between named and unna
2017-09-12 20:43 GMT+02:00 Robert Haas :
> On Tue, Sep 12, 2017 at 1:23 PM, Fabien COELHO
> wrote:
> > I added two error codes, which is debatable. One is used hardcoded by
> libpq
> > if no diagnostic is found, and the other by psql if libpq returned
> something
> > empty, which might happen if
Hi
I am sending rebased patch
Regards
Pavel
diff --git a/src/pl/plpgsql/src/pl_gram.y b/src/pl/plpgsql/src/pl_gram.y
index 94f1f58593..4b6bf0b5bc 100644
--- a/src/pl/plpgsql/src/pl_gram.y
+++ b/src/pl/plpgsql/src/pl_gram.y
@@ -92,9 +92,10 @@ static char *NameOfDatum(PLwdatum *wdatum);
static
2017-09-09 1:30 GMT+02:00 Alvaro Herrera :
> Tomas Vondra wrote:
>
> > > Finally, as vertical scrolling is mandatory, I would be fine with
> > > skipping lines with entries for readability, but it is just a matter of
> > > taste and I expect there should be half a dozen different opinions on
> > >
2017-09-13 1:42 GMT+02:00 Daniel Gustafsson :
> > On 08 Apr 2017, at 15:46, David Steele wrote:
> >
> >> On 1/13/17 6:55 AM, Marko Tiikkaja wrote:
> >>> On Fri, Jan 13, 2017 at 2:46 AM, Jim Nasby >>> <mailto:jim.na...@bluetreble.com>> wrot
2017-09-13 16:11 GMT+02:00 Tom Lane :
> Fabien COELHO writes:
> >> I'll assign this patch to next commitfest
>
> > Probably it needs some rebase after Tom committed result status
> variables.
>
> > As it is a style thing, ISTM that the patch is ready if most people agree
> > that it is better thi
2017-09-13 23:36 GMT+02:00 Thomas Munro :
> On Wed, Sep 6, 2017 at 4:12 AM, Pavel Stehule
> wrote:
> > 2017-09-05 18:06 GMT+02:00 Tom Lane :
> >> Pushed, with some fooling with the documentation (notably,
> >> re-alphabetizing relevant lists).
> >>
&
Hi
I am sorry for spam - this is just info for not too wide community (I did
pre-release), so I am using this mailing list.
I wrote new pager designed primary for usage as psql pager. It is tested
only on Linux, but it should to work on any ncurses ready platform. It is
experiment - less or more
Hi
2017-09-14 12:33 GMT+02:00 Anthony Bykov :
> The following review has been posted through the commitfest application:
> make installcheck-world: tested, passed
> Implements feature: tested, passed
> Spec compliant: not tested
> Documentation:tested, failed
>
> Hell
2017-09-14 15:17 GMT+02:00 Alvaro Herrera :
> Tom Lane wrote:
> > "David G. Johnston" writes:
> > >If I was going to try and read it like a book I'd want the extra
> > > white-space to make doing so easier (white-space gives the eye a
> breather
> > > when done with a particular concept) - and t
2017-09-14 16:35 GMT+02:00 Pavel Stehule :
>
>
> 2017-09-14 15:17 GMT+02:00 Alvaro Herrera :
>
>> Tom Lane wrote:
>> > "David G. Johnston" writes:
>> > >If I was going to try and read it like a book I'd want the extra
>> > >
2017-09-18 11:44 GMT+02:00 Alvaro Herrera :
> Pavel Stehule wrote:
>
> > I am looking on man pagers - and there are very well readable
> >
> > The rules are simply - when some variables are short - less than 6 chars,
> > then it description and label are on same
2017-09-11 14:44 GMT+02:00 Tom Lane :
> Peter Eisentraut writes:
> > On 9/8/17 13:14, Simon Riggs wrote:
> >> 2. Allow a SET to apply only for a single statement
> >> SET guc1 = x, guc2 = y FOR stmt
> >> e.g. SET max_parallel_workers = 4 FOR SELECT count(*) FROM bigtable
> >> Internally a GUC set
2017-09-19 12:18 GMT+02:00 Alexander Kuzmenkov :
> The following review has been posted through the commitfest application:
> make installcheck-world: tested, passed
> Implements feature: tested, passed
> Spec compliant: tested, passed
> Documentation:tested, passed
>
2017-09-19 11:43 GMT+02:00 Anthony Bykov :
> The following review has been posted through the commitfest application:
> make installcheck-world: tested, passed
> Implements feature: tested, passed
> Spec compliant: tested, passed
> Documentation:tested, passed
>
> Hell
2017-09-19 18:33 GMT+02:00 Robert Haas :
> On Mon, Sep 18, 2017 at 11:46 PM, Pavel Stehule
> wrote:
> > There is possibility to introduce new compile option #option to disable
> plan
> > cache on function scope. Do you think so it is acceptable solution? It is
> >
Hi
2017-09-19 16:14 GMT+02:00 Alexander Korotkov :
> On Fri, Sep 8, 2017 at 7:13 AM, Pavel Stehule
> wrote:
>
>> 2017-08-16 14:06 GMT+02:00 Pavel Stehule :
>>
>>> Hi
>>>
>>> 2017-08-15 4:37 GMT+02:00 Peter Eisentraut <
>>> peter.e
2017-09-19 20:37 GMT+02:00 Robert Haas :
> On Tue, Sep 19, 2017 at 12:45 PM, Pavel Stehule
> wrote:
> >> You can already set a GUC with function scope. I'm not getting your
> >> point.
> >
> > yes, it is true. But implementation of #option is limited
2017-09-19 20:29 GMT+02:00 Tom Lane :
> Pavel Stehule writes:
> > 2017-09-14 12:33 GMT+02:00 Anthony Bykov :
> >> As far as I understand, this patch adds functionality (correct me if I'm
> >> wrong) for users. Shouldn't there be any changes in doc/src/sgm
2017-09-19 21:11 GMT+02:00 Tom Lane :
> Pavel Stehule writes:
> > [ faster-concat-2.patch ]
>
> Pushed with some cosmetic adjustments (mostly better comments).
>
Thank you very much
Pavel
> regards, tom lane
>
2017-09-21 10:19 GMT+02:00 Alexander Korotkov :
> On Thu, Sep 21, 2017 at 1:53 AM, Peter Eisentraut <
> peter.eisentr...@2ndquadrant.com> wrote:
>
>> On 9/8/17 00:13, Pavel Stehule wrote:
>> > I am sending rebased patch
>> >
>> > rebased again
2017-09-21 15:30 GMT+02:00 Peter Eisentraut <
peter.eisentr...@2ndquadrant.com>:
> On 9/21/17 04:27, Pavel Stehule wrote:
> > yes. It was designed for + commands only. Can be enhanced to all
> > commands - then VERBOSE prefix should be removed - not sure if it is
> > ne
2017-09-21 20:20 GMT+02:00 Peter Eisentraut <
peter.eisentr...@2ndquadrant.com>:
> On 9/21/17 13:54, Pavel Stehule wrote:
> > I see where you are coming from, but there is no association in the
> > existing UI that equates "+" to the word "verbose&
ideshare.net/CraigBaumunk/temporal-extensions-tosql20112012010438
Regards
Pavel Stehule
2017-09-22 10:15 GMT+02:00 Peter Moser :
> 2017-09-22 10:06 GMT+02:00 Pavel Stehule :
> > ANSI SQL 2011 has temporal data support
> >
> > https://www.slideshare.net/CraigBaumunk/temporal-
> extensions-tosql20112012010438
>
> As operations it only supports temporal
2017-09-21 20:30 GMT+02:00 Pavel Stehule :
>
>
> 2017-09-21 20:20 GMT+02:00 Peter Eisentraut com>:
>
>> On 9/21/17 13:54, Pavel Stehule wrote:
>> > I see where you are coming from, but there is no association in the
>> > existing UI that equates &
2017-09-22 21:12 GMT+02:00 Peter Eisentraut <
peter.eisentr...@2ndquadrant.com>:
> On 9/22/17 09:16, Pavel Stehule wrote:
> > Example: somebody set SORT_COLUMNS to schema_name value. This is
> > nonsense for \l command
> >
> > Now, I am thinking so more correct
2017-09-23 5:45 GMT+02:00 Fabien COELHO :
>
> Minor code enhancement.
>
> While having a look at adding if/elif/else/endif to pgbench, and given the
> current gset/cset added meta commands in cf queue, it occured to me that
> repeated string comparisons to check for the various meta commands is
>
Hi
I did trivial example of logical replication (one table, one publication,
one subscription)
I am little bit surprised so after some work - the replication is working,
the statistics are empty
#master
postgres=# select * from pg_stat_replication ;
(0 rows)
#slave
postgres=# select * from pg_s
2017-09-25 13:12 GMT+02:00 Masahiko Sawada :
> On Mon, Sep 25, 2017 at 12:58 AM, Pavel Stehule
> wrote:
> > Hi
> >
> > I did trivial example of logical replication (one table, one publication,
> > one subscription)
> >
> > I am little bit surpris
2017-09-25 18:30 GMT+02:00 Petr Jelinek :
> On 25/09/17 13:33, Pavel Stehule wrote:
> >
> >
> > 2017-09-25 13:12 GMT+02:00 Masahiko Sawada > <mailto:sawada.m...@gmail.com>>:
> >
> > On Mon, Sep 25, 2017 at 12:58 AM, Pavel Stehule
> > m
2017-09-25 19:23 GMT+02:00 Petr Jelinek :
> On 25/09/17 19:19, Tom Lane wrote:
> > Pavel Stehule writes:
> >> I had two instances on one server with different port. I am sure, so
> >> replication was functional. Only one issue is statistics
> >
> >>
2017-09-26 11:51 GMT+02:00 Masahiko Sawada :
> On Tue, Sep 26, 2017 at 2:50 AM, Pavel Stehule
> wrote:
> >
> >
> > 2017-09-25 19:23 GMT+02:00 Petr Jelinek :
> >>
> >> On 25/09/17 19:19, Tom Lane wrote:
> >> > Pavel Stehule writes:
> >&
2017-09-26 11:56 GMT+02:00 Pavel Stehule :
>
>
> 2017-09-26 11:51 GMT+02:00 Masahiko Sawada :
>
>> On Tue, Sep 26, 2017 at 2:50 AM, Pavel Stehule
>> wrote:
>> >
>> >
>> > 2017-09-25 19:23 GMT+02:00 Petr Jelinek :
>> >>
>>
Hi
I did recheck and now it looks like it is expected.
Probably I did some wrong
Sorry for noise
Regards
Pavel
Hi
2017-09-25 13:25 GMT+02:00 Kyotaro HORIGUCHI <
horiguchi.kyot...@lab.ntt.co.jp>:
> Hello, this patch have been ignored for a long time since its proposal...
>
> At Sat, 11 Mar 2017 20:44:31 +0100, Pavel Stehule
> wrote in com>
> > Hi
> >
> > This pr
Hi
now xpath and xpath_exists supports default namespace too
updated doc,
fixed all variants of expected result test file
Regards
Pavel
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index 2f036015cc..610f709933 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -
Hi
The plpgsql_check is mature project now, and I am would to start discussion
about future of this project. It is still private project, although it is
important for one from key PostgreSQL feature - PLpgSQL. I would be happy
if the community can take some responsibility for this project. This
pr
Hi
2017-09-16 1:31 GMT+02:00 Nikita Glukhov :
> On 15.09.2017 22:36, Oleg Bartunov wrote:
>
> On Fri, Sep 15, 2017 at 7:31 PM, Robert Haas
>> wrote:
>>
>>> On Fri, Sep 15, 2017 at 10:10 AM, Daniel Gustafsson
>>> wrote:
>>>
Can we expect a rebased version of this patch for this commitfest?
2017-09-29 12:09 GMT+02:00 Nikita Glukhov :
>
>
> I have some free time now. Is it last version?
>
> Regards
>
> Pavel
>
> Yes, this is still the latest version. Now I am working only on unfinished
> WIP
> patch no. 9, but I think it should be reviewed the last.
>
>
ok
Thank you
Pavel
--
> Ni
2017-09-29 12:15 GMT+02:00 Pavel Stehule :
>
>
> 2017-09-29 12:09 GMT+02:00 Nikita Glukhov :
>
>>
>>
>> I have some free time now. Is it last version?
>>
>> Regards
>>
>> Pavel
>>
>> Yes, this is still the latest version. Now I a
2017-09-30 1:06 GMT+02:00 Nikita Glukhov :
> On 29.09.2017 20:07, Pavel Stehule wrote:
>
> 2017-09-29 12:15 GMT+02:00 Pavel Stehule :
>
>>
>> 2017-09-29 12:09 GMT+02:00 Nikita Glukhov :
>>
>>>
>>>
>>> I have some free time now. Is it last
Hi
There is new, not well solved dependency. I have not any problem to build
extension with PostgreSQL 9.6 there
[oracle@ora2pg plpgsql_check]$ make
gcc -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
-Wformat-security -fno-strict
2017-09-30 7:54 GMT+02:00 Pavel Stehule :
> Hi
>
> There is new, not well solved dependency. I have not any problem to build
> extension with PostgreSQL 9.6 there
>
> [oracle@ora2pg plpgsql_check]$ make
> gcc -Wall -Wmissing-prototypes -Wpointer-arith
> -Wdeclaration
2017-09-30 8:18 GMT+02:00 Tom Lane :
> Pavel Stehule writes:
> > /usr/pgsql-10/include/server/utils/pg_locale.h:19:26: error:
> > unicode/ucol.h: Adresář nebo soubor neexistuje
>
> > This mean not optional dependency on ICU.
>
> Really? That file has
>
>
Hi
I have some strange slow queries based on usage "view" functions
one function looks like this:
CREATE OR REPLACE FUNCTION
ides_funcs.najdatsplt_cislo_exekuce(mid_najdatsplt bigint)
RETURNS character varying
LANGUAGE sql
STABLE
AS $function$
select CISLOEXEKUCE
from najzalobpr MT, naj
2017-10-01 4:55 GMT+02:00 Devrim Gündüz :
>
> Hi,
>
> On Sat, 2017-09-30 at 11:15 -0400, Tom Lane wrote:
> > So the point is that postgresql-devel now needs to have a dependency
> > on icu-devel.
>
> Oh, I see. Ack, added. Will appear in 10.0 RPMs.
>
Thank you
Pavel
>
> Regards,
> --
> Devrim G
2017-09-30 23:23 GMT+02:00 Pavel Stehule :
> Hi
>
> I have some strange slow queries based on usage "view" functions
>
> one function looks like this:
>
> CREATE OR REPLACE FUNCTION ides_funcs.najdatsplt_cislo_exekuce(mid_najdatsplt
> bigint)
> RETURNS charac
2017-10-01 12:45 GMT+02:00 Sokolov Yura :
> 1 октября 2017 г. 12:42:14 GMT+03:00, Pavel Stehule <
> pavel.steh...@gmail.com> пишет:
> >2017-09-30 23:23 GMT+02:00 Pavel Stehule :
> >
> >> Hi
> >>
> >> I have some strange slow queries based on
2017-09-30 23:23 GMT+02:00 Pavel Stehule :
> Hi
>
> I have some strange slow queries based on usage "view" functions
>
> one function looks like this:
>
> CREATE OR REPLACE FUNCTION ides_funcs.najdatsplt_cislo_exekuce(mid_najdatsplt
> bigint)
> RETURNS charac
2017-09-30 1:06 GMT+02:00 Nikita Glukhov :
> On 29.09.2017 20:07, Pavel Stehule wrote:
>
> 2017-09-29 12:15 GMT+02:00 Pavel Stehule :
>
>>
>> 2017-09-29 12:09 GMT+02:00 Nikita Glukhov :
>>
>>>
>>>
>>> I have some free time now. Is it last
2017-10-02 12:22 GMT+02:00 Kyotaro HORIGUCHI <
horiguchi.kyot...@lab.ntt.co.jp>:
> Hi, thanks for the new patch.
>
> # The patch is missing xpath_parser.h. That of the first patch was usable.
>
> At Thu, 28 Sep 2017 07:59:41 +0200, Pavel Stehule
> wrote in mail.gmail
701 - 800 of 5142 matches
Mail list logo
