Re: [HACKERS] WIP patch for Todo Item : Provide fallback_application_name in contrib/pgbench, oid2name, and dblink

2014-04-19 Thread Bruce Momjian
On Wed, Apr 16, 2014 at 11:01:56PM -0400, Bruce Momjian wrote: On Tue, Apr 1, 2014 at 10:32:01AM -0400, Tom Lane wrote: Adrian Vondendriesch adrian.vondendrie...@credativ.de writes: I patched the function conninfo_array_parse() which is used by PQconnectStartParams to behave like

[HACKERS] Re: [DOCS] Docs incorrectly claiming equivalence between show and pg_settings

2014-04-19 Thread Bruce Momjian
On Wed, Feb 12, 2014 at 03:54:31PM +0100, Stefan Seifert wrote: Hi! http://www.postgresql.org/docs/devel/static/sql-show.html claims: Also, the pg_settings system view produces the same information. This is not entirely correct. On IRC I was told, that the view only contains settings set

Re: [HACKERS] Re: [DOCS] Docs incorrectly claiming equivalence between show and pg_settings

2014-04-19 Thread Tom Lane
Bruce Momjian br...@momjian.us writes: However, in the case of custom variables, you are right that pg_settings doesn't show custom variables. That is entirely intentional: the reason we do not show placeholder variables in pg_settings is that we have no accurate information about them, and so

Re: [HACKERS] Clock sweep not caching enough B-Tree leaf pages?

2014-04-19 Thread Atri Sharma
On Sat, Apr 19, 2014 at 3:37 AM, Bruce Momjian br...@momjian.us wrote: One thing that I discussed with Merlin offline and am now concerned about is how will the actual eviction work. We cannot traverse the entire list and then find all the buffers with refcount 0 and then do another

Re: [HACKERS] Re: [DOCS] Docs incorrectly claiming equivalence between show and pg_settings

2014-04-19 Thread Bruce Momjian
On Sat, Apr 19, 2014 at 01:38:16PM -0400, Tom Lane wrote: Bruce Momjian br...@momjian.us writes: However, in the case of custom variables, you are right that pg_settings doesn't show custom variables. That is entirely intentional: the reason we do not show placeholder variables in

Re: [HACKERS] Avoiding deeply nested AND/OR trees in the parser

2014-04-19 Thread Bruce Momjian
On Wed, Feb 26, 2014 at 10:21:03PM -0500, Tom Lane wrote: Noah Misch n...@leadboat.com writes: On Tue, Feb 25, 2014 at 01:15:09PM -0500, Tom Lane wrote: Really if we wanted to fix this issue we'd need to hack up transformAExprAnd/transformAExprOr so that they recognized nested ANDs/ORs

Re: [HACKERS] Avoiding deeply nested AND/OR trees in the parser

2014-04-19 Thread Tom Lane
Bruce Momjian br...@momjian.us writes: On Wed, Feb 26, 2014 at 10:21:03PM -0500, Tom Lane wrote: Oh, I'd forgotten about that thread. I never particularly liked the patch as presented: like Robert, I thought it far too complicated. My inclination would just be to tweak the parser enough so

[HACKERS] PATCH: Allow empty targets in unaccent dictionary

2014-04-19 Thread Mohammad Alhashash
Hi, Currently, unaccent extension only allows replacing one source character with one or more target characters. In Arabic, Hebrew and possibly other languages, diacritics are standalone characters that are being added to normal letters. To use unaccent dictionary for these languages, we need

Re: [HACKERS] Avoiding deeply nested AND/OR trees in the parser

2014-04-19 Thread Bruce Momjian
On Sat, Apr 19, 2014 at 05:50:17PM -0400, Tom Lane wrote: Bruce Momjian br...@momjian.us writes: On Wed, Feb 26, 2014 at 10:21:03PM -0500, Tom Lane wrote: Oh, I'd forgotten about that thread. I never particularly liked the patch as presented: like Robert, I thought it far too complicated.

Re: [HACKERS] DISCARD ALL (Again)

2014-04-19 Thread Fabrízio de Royes Mello
On Fri, Apr 18, 2014 at 12:00 PM, Peter Eisentraut pete...@gmx.net wrote: On 4/17/14, 8:24 PM, Tom Lane wrote: We could in fact implement #2, I imagine, by destroying and recreating the entire language interpreter. So I could imagine implementing a DISCARD INTERPRETERS kind of command