[HACKERS] proposal: ignore null fields in not relation type composite type based constructors

2014-05-24 Thread Pavel Stehule
Hello In Czech Postgres mailing list was user request for serialization to json without null values. He needs a similar behave like XMLFOREST has - it ignores NULLs In some situations and conversions, when your table is +/- sparse matrix, this request is valid postgres=# select hstore(omega) fr

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

2014-05-24 Thread Tomas Vondra
On 14.5.2014 15:17, Andres Freund wrote: > On 2014-05-14 15:08:08 +0200, Tomas Vondra wrote: >> On 14 Květen 2014, 13:51, Andres Freund wrote: >>> On 2014-05-13 20:42:16 +0200, Tomas Vondra wrote: Can someone please approve the animals I've requested a few days ago? I'm already running th

Re: [HACKERS] buildfarm / handling (undefined) locales

2014-05-24 Thread Tomas Vondra
On 13.5.2014 20:58, Tom Lane wrote: > Tomas Vondra writes: >> Yeah, not really what we were shooting for. I've fixed this by >> defining the missing locales, and indeed - magpie now fails in >> plpython tests. > > I saw that earlier today (tho right now the buildfarm server seems > to not be res

Re: [HACKERS] SQL access to database attributes

2014-05-24 Thread Tom Lane
Jim Nasby writes: > On 5/24/14, 8:14 AM, Tom Lane wrote: >> Perhaps it'd be wise to have a safety check to disallow turning off >> datallowconn for the last connectable database? Although it couldn't be >> bulletproof due to race conditions, so maybe that'd just be nannyism. > BTW, I think the r

Re: [HACKERS] Issue with GRANT/COMMENT ON FUNCTION with default

2014-05-24 Thread Tom Lane
Jim Nasby writes: > Let me ask a related question: is there any reason why we don't accept > argument names or the default specifier in the regprocedure cast? regprocedure_in does not contain a full SQL parser, which it would pretty much need in order to deal with default expressions. Argument

Re: [HACKERS] Issue with GRANT/COMMENT ON FUNCTION with default

2014-05-24 Thread Jim Nasby
On 5/6/14, 1:57 PM, Peter Eisentraut wrote: On 5/5/14, 4:09 PM, Jim Nasby wrote: They do not accept DEFAULT though: GRANT EXECUTE ON FUNCTION test(t text DEFAULT '') to public; ERROR: syntax error at or near "DEFAULT" LINE 1: GRANT EXECUTE ON FUNCTION test(t text DEFAULT '') to public; Presum

Re: [HACKERS] Priority table or Cache table

2014-05-24 Thread Jim Nasby
On 5/16/14, 8:15 AM, Hans-Jürgen Schönig wrote: On 20 Feb 2014, at 01:38, Tom Lane wrote: I am really dubious that letting DBAs manage buffers is going to be an improvement over automatic management. the reason for a feature like that is to define an area of the application which needs more

Re: [HACKERS] SQL access to database attributes

2014-05-24 Thread Jim Nasby
On 5/24/14, 8:14 AM, Tom Lane wrote: Vik Fearing writes: >On 05/24/2014 12:03 AM, Jaime Casanova wrote: >>Which lead us to the question: you need to connect to the database to >>modify it, don't you? then, how do you change ALLOW CONNECTIONS to >>true? >You can ALTER DATABASE from anywhere.

Re: [HACKERS] Allowing join removals for more join types

2014-05-24 Thread Tom Lane
David Rowley writes: > I agree that there are not many cases left to remove the join that remain > after is_simple_subquery() has decided not to pullup the subquery. Some of > the perhaps more common cases would be having windowing functions in the > subquery as this is what you need to do if you

[HACKERS] Re: buildfarm: strange OOM failures on markhor (running CLOBBER_CACHE_RECURSIVELY)

2014-05-24 Thread Noah Misch
On Mon, May 19, 2014 at 05:08:04PM +0200, Andres Freund wrote: > On 2014-05-18 14:49:10 -0400, Tom Lane wrote: > > While I'm at it: I could not help noticing RememberToFreeTupleDescAtEOX, > > which was not there last time I looked at this code. Isn't that broken > > by design? It's basically a de

Re: [HACKERS] SQL access to database attributes

2014-05-24 Thread Tom Lane
Vik Fearing writes: > On 05/24/2014 12:03 AM, Jaime Casanova wrote: >> Which lead us to the question: you need to connect to the database to >> modify it, don't you? then, how do you change ALLOW CONNECTIONS to >> true? > You can ALTER DATABASE from anywhere. Perhaps it'd be wise to have a safet