Re: [COMMITTERS] pgsql: Logical replication

2017-01-20 Thread Pavel Stehule
2017-01-21 6:56 GMT+01:00 Amit Langote : > On Sat, Jan 21, 2017 at 1:19 PM, Amit Kapila > wrote: > > On Fri, Jan 20, 2017 at 7:36 PM, Peter Eisentraut > wrote: > >> Logical replication > >> > >> - Add PUBLICATION catalogs and DDL > >> - Add SUBSCRIPTION catalog and DDL > >> - Define logical repl

Re: [COMMITTERS] pgsql: Simplify LWLock tranche machinery by removing array_base/array_s

2016-12-20 Thread Pavel Stehule
Hi Is there some help for extensions developers, how to fix extensions after this change? Orafce hits this change. Regards Pavel 2016-12-16 17:41 GMT+01:00 Robert Haas : > Simplify LWLock tranche machinery by removing array_base/array_stride. > > array_base and array_stride were added so that

Re: [COMMITTERS] pgsql: Provide much better wait information in pg_stat_activity.

2016-03-10 Thread Pavel Stehule
Hi 2016-03-10 19:55 GMT+01:00 Robert Haas : > Provide much better wait information in pg_stat_activity. > > When a process is waiting for a heavyweight lock, we will now indicate > the type of heavyweight lock for which it is waiting. Also, you can > now see when a process is waiting for a light

Re: [COMMITTERS] pgsql: Add pg_size_bytes() to parse human-readable size strings.

2016-02-20 Thread Pavel Stehule
al_relation_size(oid) > pg_size_bytes('10 GB')". > > Author: Pavel Stehule with various improvements by Vitaly Burovoy > Discussion: > http://www.postgresql.org/message-id/cafj8prd-tgodknxdygecza4on01_urqprwf-8ldkse-6bdh...@mail.gmail.com > Reviewed-by: Vitaly Burovoy, Oleksandr

Re: [COMMITTERS] pgsql: Code and docs review for multiple -c and -f options in psql.

2015-12-13 Thread Pavel Stehule
2015-12-14 3:16 GMT+01:00 Michael Paquier : > On Mon, Dec 14, 2015 at 11:16 AM, Michael Paquier wrote: > > - cell = (SimpleActionListCell *) > > - pg_malloc(offsetof(SimpleActionListCell, val) + vallen + 1); > > Thanks! Among all those things this bit is a bit shameful.. > > (I am the one

Re: [COMMITTERS] pgsql: Add pg_audit, an auditing extension

2015-05-15 Thread Pavel Stehule
2015-05-15 12:37 GMT+02:00 Thom Brown : > On 15 May 2015 at 11:20, Pavel Stehule wrote: > > > > > > 2015-05-15 12:14 GMT+02:00 Thom Brown : > >> > >> On 15 May 2015 at 10:56, Pavel Stehule wrote: > >> > Hi > >> > > >>

Re: [COMMITTERS] pgsql: Add pg_audit, an auditing extension

2015-05-15 Thread Pavel Stehule
2015-05-15 12:14 GMT+02:00 Thom Brown : > On 15 May 2015 at 10:56, Pavel Stehule wrote: > > Hi > > > > I am testing it, and output is strange > > > > 2015-05-15 11:49:25.046 CEST pavel postgres: LOG: AUDIT: > > SESSION,1,1,DDL,DROP TABLE,,,drop table foo;,

Re: [COMMITTERS] pgsql: Add pg_audit, an auditing extension

2015-05-15 Thread Pavel Stehule
Hi I am testing it, and output is strange 2015-05-15 11:49:25.046 CEST pavel postgres: LOG: AUDIT: SESSION,1,1,DDL,DROP TABLE,,,drop table foo;, 2015-05-15 11:49:25.046 CEST pavel postgres: STATEMENT: drop table foo; 2015-05-15 11:49:28.291 CEST pavel postgres: LOG: AUDIT: SESSION,2,1,DDL,CREA

Re: [COMMITTERS] pgsql: Additional functions and operators for jsonb

2015-05-12 Thread Pavel Stehule
Hi I did some tests, and I am not sure if this is not bug: postgres=# select '{"x":20}'::jsonb - 'x'::text; ERROR: unknown type of jsonb container --->>> it should be empty jsonb, not error Time: 0.971 ms postgres=# select '{"x":20, "y":30}'::jsonb - 'x'::text; ┌───┐ │ ?column? │ ╞═

Re: [COMMITTERS] pgsql: Add new psql help topics, accessible to both --help and \?.

2014-09-10 Thread Pavel Stehule
2014-09-10 13:15 GMT+02:00 Michael Paquier : > On Wed, Sep 10, 2014 at 10:04 AM, Andres Freund > wrote: > > The best plan after that seems to be to add optional_argument support to > > getopt_long.c - looks easy enough. Do we need a configure test for > > optional_argument? I don't think so, but

Re: [COMMITTERS] pgsql: Add new psql help topics, accessible to both --help and \?.

2014-09-10 Thread Pavel Stehule
their previous topic. > > > > Some further wordsmithing or extending of the added help content might > > be needed; but there seems little benefit delaying the overall feature > > further. > > > > Author: Pavel Stehule, editorialized by many > > > &

Re: [COMMITTERS] pgsql: Add GET DIAGNOSTICS ... PG_CONTEXT in PL/PgSQL

2013-07-25 Thread Pavel Stehule
2013/7/25 Stephen Frost : > Pavel, > > First, please only quote the relevant parts of the email when > responding. > > * Pavel Stehule (pavel.steh...@gmail.com) wrote: >> I used a ErrorContext because I wasn't sure so errcontext and similar >> function can wo

Re: [COMMITTERS] pgsql: Add GET DIAGNOSTICS ... PG_CONTEXT in PL/PgSQL

2013-07-25 Thread Pavel Stehule
Hello 2013/7/25 Tom Lane : > Stephen Frost writes: >> I've just pushed up some much needed improvements to the comments which >> hopefully clarify that this function is using error_context_stack and >> calling the callbacks set up there by callers above on the PG call >> stack. > > Now that I'm a

Re: [COMMITTERS] pgsql: Improve pretty printing of viewdefs.

2012-02-19 Thread Pavel Stehule
Hello nice should be this functionality used for query too? some like pg_pretty_query('SELECT ... ', 80) when we have this functionality. Regards Pavel 2012/2/19 Andrew Dunstan : > Improve pretty printing of viewdefs. > > Some line feeds are added to target lists and from lists to make > th

Re: [COMMITTERS] pgsql: Add string functions: concat(), concat_ws(), left(), right(), and

2010-08-24 Thread Pavel Stehule
left(), right(), and reverse(). > > Pavel Stehule, reviewed by me. > > Modified Files: > -- >    pgsql/doc/src/sgml: >        func.sgml (r1.529 -> r1.530) >         > (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/func.sgml?r1=1.52

Re: [COMMITTERS] pgsql: Allow psql variables to be interpolated with literal or

2010-01-29 Thread Pavel Stehule
2010/1/29 Robert Haas : > Log Message: > --- > Allow psql variables to be interpolated with literal or identifier escaping. > > Loosely based on a patch by Pavel Stehule. thank you very much Pavel > > Modified Files: > -- >    pgsql/doc/src/sgml/

Re: [COMMITTERS] pgsql: Add BETWEEN SYMMETRIC.

2005-06-18 Thread Pavel Stehule
I'll correct it Pavel Stehule On Wed, 15 Jun 2005, Tom Lane wrote: > [EMAIL PROTECTED] (Bruce Momjian) writes: > > Add BETWEEN SYMMETRIC. > > $ make > bison -y -d gram.y > conflicts: 4 shift/reduce > > This is absolutely unacceptable. > >

Re: [COMMITTERS] pgsql: Add PL/pgSQL SQLSTATE and SQLERRM support

2005-06-05 Thread Pavel Stehule
On Thu, 2 Jun 2005, Tom Lane wrote: > Pavel Stehule <[EMAIL PROTECTED]> writes: > > I din't find easy way how append variable only when block contains > > EXCEPTION part. I wilcome any advice > > I was envisioning an action in the beginning of the EXCEPTION c

Re: [COMMITTERS] pgsql: Add PL/pgSQL SQLSTATE and SQLERRM support

2005-06-05 Thread Pavel Stehule
On Thu, 2 Jun 2005, Tom Lane wrote: > Neil Conway <[EMAIL PROTECTED]> writes: > > I should have commented on this earlier: I don't think exact Oracle > > compatibility is _at all_ important. > > The results of Pavel's experiments prove that Oracle's behavior is > pretty random --- it looks to me

Re: [COMMITTERS] pgsql: Add PL/pgSQL SQLSTATE and SQLERRM support

2005-06-05 Thread Pavel Stehule
On Fri, 3 Jun 2005, Neil Conway wrote: > Pavel Stehule wrote: > > So we can have only one procedure level scope variable, which is > > initialized on start of exception and zeroized on the end of exception > > block. This behavior is different from my patch, but

Re: [COMMITTERS] pgsql: Add PL/pgSQL SQLSTATE and SQLERRM support

2005-05-31 Thread Pavel Stehule
successful completion 6: 0 -> ORA-: normal, successful completion What it is mean? So we can have only one procedure level scope variable, which is initialized on start of exception and zeroized on the end of exception block. This behavior is different from my patch, but is better for Oracl

Re: [COMMITTERS] pgsql: Add PL/pgSQL SQLSTATE and SQLERRM support

2005-05-31 Thread Pavel Stehule
> > That might be taking the notion of bug-compatibility with PL/SQL > a bit too far. For that matter, did you check whether Oracle > actually treats it as a procedure-scope variable? Try having the > exception block call another function and trap an error inside that. > Does SQLCODE change in t

Re: [COMMITTERS] pgsql: Add PL/pgSQL SQLSTATE and SQLERRM support

2005-05-31 Thread Pavel Stehule
On Thu, 26 May 2005, Neil Conway wrote: > Tom Lane wrote: > > Alternatively we could make them local to any block that contains an > > EXCEPTION clause, which would fix point 3 and also go a long way towards > > addressing the unnecessary-overhead gripe. However that would mean that > > an attemp