Re: [HACKERS] Additional role attributes && superuser review

2016-01-04 Thread Alvaro Herrera
Based on the feedback here, I have returned this patch to Needs Review status. (Waiting on Author would be fairer actually, since we are waiting for an updated version.) As far as I can make it from Noah and Robert's comments, what we would like to see here is a way for pg_dump to output

Re: [HACKERS] Additional role attributes && superuser review

2016-01-04 Thread Stephen Frost
Noah, * Noah Misch (n...@leadboat.com) wrote: > On Tue, Dec 29, 2015 at 08:35:50AM -0500, Stephen Frost wrote: > > * Noah Misch (n...@leadboat.com) wrote: > > > The one argument which you've put forth for adding the complexity of > > dumping catalog ACLs is that we might reduce the number of

Re: [HACKERS] Building pg_xlogdump reproducibly

2016-01-04 Thread Alvaro Herrera
Christoph Berg wrote: > Re: Andres Freund 2016-01-04 <20160104155125.gd28...@awork2.anarazel.de> > > That's probably not the only non-deterministic rule in postgres, given > > nobody paid attention tot that so far? At least transform modules added > > in 9.5 (hstore_plpython et al) look like they

[HACKERS] Accessing non catalog table in backend

2016-01-04 Thread Atri Sharma
Hi All, I wanted to check if it is possible to query a non catalog table in backend. I understand that cql interface is only for catalog querying hence it is not usable for this purpose per se. Please advice. Regards, Atri

Re: [HACKERS] custom function for converting human readable sizes to bytes

2016-01-04 Thread Thom Brown
On 4 January 2016 at 15:17, Pavel Stehule wrote: > Hi > > 2016-01-04 12:46 GMT+01:00 Shulgin, Oleksandr > : >> >> On Wed, Dec 30, 2015 at 8:28 PM, Pavel Stehule >> wrote: >>> >>> >>> >>> 2015-12-30 17:33 GMT+01:00

Re: [HACKERS] Building pg_xlogdump reproducibly

2016-01-04 Thread Christoph Berg
Re: Andres Freund 2016-01-04 <20160104155125.gd28...@awork2.anarazel.de> > That's probably not the only non-deterministic rule in postgres, given > nobody paid attention tot that so far? At least transform modules added > in 9.5 (hstore_plpython et al) look like they might similar issues. I was

Re: [HACKERS] Improved tab completion for FDW DDL

2016-01-04 Thread Andreas Karlsson
On 01/04/2016 07:26 AM, Michael Paquier wrote: You may want to use Matches() instead of TailMatches() for performance reasons. Probably, but if so should we not also change the surrounding rules to also use Matches()? I imitated the surrounding code to keep code consistency and avoid errors.

Re: [HACKERS] Improved tab completion for FDW DDL

2016-01-04 Thread Tom Lane
Andreas Karlsson writes: > I thought I saw some patch from you changing many of the rules from > TailMatches() to Matches(). Perhaps I should just update my patch after > your patch has been applied. Yes, I think it's important to get that set of patches from Michael into

Re: [HACKERS] pglogical - logical replication contrib module

2016-01-04 Thread Shulgin, Oleksandr
On Fri, Jan 1, 2016 at 12:34 AM, Petr Jelinek wrote: > Hi, > > I'd like to submit the replication solution which is based on the > pglogical_output [1] module (which is obviously needed for this to compile). > Hi, Impressive stuff! Apparently this depends on a newer,

Re: [HACKERS] custom function for converting human readable sizes to bytes

2016-01-04 Thread Shulgin, Oleksandr
On Mon, Jan 4, 2016 at 4:51 PM, Robert Haas wrote: > On Mon, Jan 4, 2016 at 10:17 AM, Pavel Stehule > wrote: > > [ new patch ] > > + case '-': > + ereport(ERROR, > +

Re: [HACKERS] custom function for converting human readable sizes to bytes

2016-01-04 Thread Pavel Stehule
2016-01-04 17:48 GMT+01:00 Shulgin, Oleksandr : > On Mon, Jan 4, 2016 at 4:51 PM, Robert Haas wrote: > >> On Mon, Jan 4, 2016 at 10:17 AM, Pavel Stehule >> wrote: >> > [ new patch ] >> >> + case '-': >> +

Re: [HACKERS] pgsql: Further tweaking of print_aligned_vertical().

2016-01-04 Thread Tom Lane
Greg Stark writes: > I used plenty of images I pulled off the net without regard for > copyright so I hesitated to put it up. I suppose that's par for the > course with these kinds of presentations. In any case it was just a > quick lightning talk I threw together to describe a few

Re: [HACKERS] Re: pglogical_output - a general purpose logical decoding output plugin

2016-01-04 Thread Alvaro Herrera
Shulgin, Oleksandr wrote: > A make from an external build dir fails on install, suggested fix: > > install: all > $(MKDIR_P) '$(DESTDIR)$(includedir)'/pglogical_output > - $(INSTALL_DATA) pglogical_output/hooks.h > '$(DESTDIR)$(includedir)'/pglogical_output > + $(INSTALL_DATA) >

<    1   2