Re: [HACKERS] SQL access to database attributes

2014-05-24 Thread Tom Lane
Vik Fearing vik.fear...@dalibo.com 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

[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

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

2014-05-24 Thread Tom Lane
David Rowley dgrowle...@gmail.com 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

Re: [HACKERS] SQL access to database attributes

2014-05-24 Thread Jim Nasby
On 5/24/14, 8:14 AM, Tom Lane wrote: Vik Fearingvik.fear...@dalibo.com 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

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 t...@sss.pgh.pa.us 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

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;

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

2014-05-24 Thread Tom Lane
Jim Nasby j...@nasby.net 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

Re: [HACKERS] SQL access to database attributes

2014-05-24 Thread Tom Lane
Jim Nasby j...@nasby.net 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

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

2014-05-24 Thread Tomas Vondra
On 13.5.2014 20:58, Tom Lane wrote: Tomas Vondra t...@fuzzy.cz 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

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 the clobber

[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)