Re: [HACKERS] Possible fix for occasional failures on castoroides etc

2014-05-03 Thread Andres Freund
On 2014-05-03 13:25:32 -0400, Tom Lane wrote: > Andres Freund writes: > > On 2012-09-17 08:23:01 -0400, Dave Page wrote: > >> I've added MAX_CONNECTIONS=5 to both Castoroides and Protosciurus. > > > I've just noticed (while checking whether backporting 4c8aa8b5aea caused > > problems) that this d

Re: [HACKERS] Possible fix for occasional failures on castoroides etc

2014-05-03 Thread Tom Lane
I wrote: > Unfortunately, it seems the Solaris implementors didn't read Stevens, > because it looks to me like they *do* return ECONNREFUSED on accept queue > overflow. Still, it's hard to see how that would be the issue if we're > still seeing this failure with only five clients. Also, after fur

[HACKERS] pgindent run

2014-05-03 Thread Bruce Momjian
I am planning to run pgindent in a few days to prepare for beta. Does anyone have major patches that you are planning to apply soon? If so, I can delay pgindent until you are done. This run will also have a tabs-in-comments removal phase which will also be run on supported back branches. --

Re: [HACKERS] Possible fix for occasional failures on castoroides etc

2014-05-03 Thread Tom Lane
Andres Freund writes: > On 2012-09-17 08:23:01 -0400, Dave Page wrote: >> I've added MAX_CONNECTIONS=5 to both Castoroides and Protosciurus. > I've just noticed (while checking whether backporting 4c8aa8b5aea caused > problems) that this doesn't seem to have fixed the issue. One further > thing t

Re: [HACKERS] Sending out a request for more buildfarm animals?

2014-05-03 Thread Andrew Dunstan
On 05/03/2014 12:42 PM, Tomas Vondra wrote: On 3.5.2014 03:07, Noah Misch wrote: More coverage of non-gcc compilers would be an asset to the buildfarm. Does that include non-gcc compilers on Linux/x86 platforms? Magpie is pretty much dedicated to the buildfarm, and it's pretty much doing noth

Re: [HACKERS] Sending out a request for more buildfarm animals?

2014-05-03 Thread Tom Lane
Tomas Vondra writes: > Magpie is pretty much dedicated to the buildfarm, and it's pretty much > doing nothing most of the time, so running the tests with other > compilers (llvm/ic/...) would be just fine. Not sure how to do that, > though. Should I run the tests with multiple configurations, or

Re: [HACKERS] Sending out a request for more buildfarm animals?

2014-05-03 Thread Tomas Vondra
On 3.5.2014 03:07, Noah Misch wrote: > More coverage of non-gcc compilers would be an asset to the buildfarm. Does that include non-gcc compilers on Linux/x86 platforms? Magpie is pretty much dedicated to the buildfarm, and it's pretty much doing nothing most of the time, so running the tests wit

Re: [HACKERS] Sending out a request for more buildfarm animals?

2014-05-03 Thread Noah Misch
On Sat, May 03, 2014 at 10:09:56AM +0200, Andres Freund wrote: > On 2014-05-02 21:07:55 -0400, Noah Misch wrote: > > +1 for sending a call for help to -announce. I agree with your importance > > estimates, particularly on the OS side. -1 for making code-level changes to > > "desupport" a platform

Re: [HACKERS] Possible fix for occasional failures on castoroides etc

2014-05-03 Thread Andres Freund
On 2012-09-17 08:23:01 -0400, Dave Page wrote: > On Sun, Sep 16, 2012 at 12:44 PM, Andrew Dunstan wrote: > > > > On 09/16/2012 12:04 PM, Tom Lane wrote: > >> > >> It's annoying that the buildfarm animals running on older versions of > >> Solaris randomly fail with "Connection refused" errors, such

Re: [HACKERS] need of anonymous record

2014-05-03 Thread Andrew Dunstan
On 05/03/2014 09:55 AM, Peter Krauss wrote: My notion of "anonymous record", and the need of this kind of "higher-order type", are discussed in the links below, http://stackoverflow.com/q/23439240 "Functions can not to /return individual items of a record/" http://stackoverflow.com/q/212462

Re: [HACKERS] need of anonymous record

2014-05-03 Thread David G Johnston
Peter Padua Krauss wrote > The first question is about performance: "*returns table*" have the same > performance than "*returns record*"?? > If "yes", the *record* datatype is somewhat outdated? Table defines the possibility to return a set while record can only ever return a single value; so lik

Re: [HACKERS] Sending out a request for more buildfarm animals?

2014-05-03 Thread Bernd Helmle
It's a POWER 7 machine. On 3. Mai 2014 10:31:34 MESZ, Dave Page wrote: >Hamid@EDB; Can you please have someone configure anole to build git >head as well as the other branches? Thanks. > >Andres, Andrew; I think the only other gap EDB could fill at the >moment is RHEL6 on Power7 (though we do ha

[HACKERS] need of anonymous record

2014-05-03 Thread Peter Krauss
My notion of "anonymous record", and the need of this kind of "higher-order type", are discussed in the links below, http://stackoverflow.com/q/23439240 "Functions can not to *return individual items of a record*" http://stackoverflow.com/q/21246201 "PostgreSQL v9.X have real '*array of recor

Re: [HACKERS] pg_get_viewdefs() indentation considered harmful

2014-05-03 Thread Andrew Dunstan
On 05/03/2014 09:17 AM, Marko Tiikkaja wrote: Hi all, Now that we're on the topic of view deparsing, what are your thoughts on making this less painful? local:marko=#* create view foov as select exists(select * from foo); CREATE VIEW local:marko=#* \d+ foov View "public.foo

Re: [HACKERS] pg_get_viewdefs() indentation considered harmful

2014-05-03 Thread Marko Tiikkaja
Hi all, Now that we're on the topic of view deparsing, what are your thoughts on making this less painful? local:marko=#* create view foov as select exists(select * from foo); CREATE VIEW local:marko=#* \d+ foov View "public.foov" Column | Type | Modifiers | Storage | Des

Re: [HACKERS] Supporting multiple column assignment in UPDATE (9.5 project)

2014-05-03 Thread Marko Tiikkaja
On 5/2/14, 10:10 PM, Merlin Moncure wrote: On Fri, May 2, 2014 at 3:03 PM, Tom Lane wrote: Meh. Then you could have a query that works fine until you add a column to the table, and it stops working. If nobody ever used column names identical to table names it'd be all right, but unfortunately

Re: [HACKERS] Sending out a request for more buildfarm animals?

2014-05-03 Thread Dave Page
Hamid@EDB; Can you please have someone configure anole to build git head as well as the other branches? Thanks. Andres, Andrew; I think the only other gap EDB could fill at the moment is RHEL6 on Power7 (though we do have a couple of Power8 boxes on order that should be here pretty soon). Dotterel

Re: [HACKERS] quiet inline configure check misses a step for clang

2014-05-03 Thread Andres Freund
On 2014-05-01 16:17:17 -0400, Tom Lane wrote: > Andres Freund writes: > > Patch attached. > > Committed with minor comment-smithing. Interestingly this seems to have allowed the quiet inline test to succeedd on HP-UX ac++ as well: http://buildfarm.postgresql.org/cgi-bin/show_stage_log.pl?nm=anol

Re: [HACKERS] tab completion for setting search_path

2014-05-03 Thread Andres Freund
On 2014-05-03 00:13:45 -0700, Jeff Janes wrote: > On Friday, May 2, 2014, Jeff Janes wrote: > > > I've been working with an app that uses a schema name whose spelling is > > hard to type, and the lack of tab completion for "SET search_path TO" was > > bugging me. So see attached. > > > > I filte

Re: [HACKERS] Sending out a request for more buildfarm animals?

2014-05-03 Thread Andres Freund
On 2014-05-02 21:07:55 -0400, Noah Misch wrote: > On Fri, May 02, 2014 at 05:04:01PM +0200, Andres Freund wrote: > > There's pretty little coverage of non mainstream platforms/compilers in > > the buildfarm atm. Maybe we should send an email on -announce asking for > > new ones? > > There's no cove

Re: [HACKERS] New and interesting replication issues with 9.2.8 sync rep

2014-05-03 Thread Andres Freund
On 2014-05-02 18:57:08 -0700, Josh Berkus wrote: > Just got a report of a replication issue with 9.2.8 from a community member: > > Here's the sequence: > > 1) A --> B (sync rep) > > 2) Shut down B > > 3) Shut down A > > 4) Start up B as a master > > 5) Start up A as sync replica of B > > 6)

Re: [HACKERS] tab completion for setting search_path

2014-05-03 Thread Jeff Janes
On Friday, May 2, 2014, Jeff Janes wrote: > I've been working with an app that uses a schema name whose spelling is > hard to type, and the lack of tab completion for "SET search_path TO" was > bugging me. So see attached. > > I filter out the system schemata, but not public. > > For commit fest