Re: [GENERAL] Suggestion for new function on pg_catalog: get_config()

2007-09-04 Thread Alvaro Herrera
Luiz K. Matsumura wrote: > By the way, > > select setting AS default_tablespace from pg_show_all_settings() x(name > text, setting text, unit text, category text, short_desc text, extra_desc > text, context text, vartype text, source text, min_val text, max_val text) > where name = 'default_tab

Re: [GENERAL] Suggestion for new function on pg_catalog: get_config()

2007-09-03 Thread Luiz K. Matsumura
Alvaro Herrera wrote: Luiz K. Matsumura wrote: Hi all, I want to suggest a inclusion of an new function on the pg_catalog. Since we have set_config(text, text, boolean) can we have an get_config( text ) ? Hum, isn't this current_setting()? Oh oh, you are right, forget my suggest

Re: [GENERAL] Suggestion for new function on pg_catalog: get_config()

2007-09-03 Thread Alvaro Herrera
Luiz K. Matsumura wrote: > Hi all, > > I want to suggest a inclusion of an new function on the pg_catalog. > Since we have set_config(text, text, boolean) > can we have an get_config( text ) ? Hum, isn't this current_setting()? -- Alvaro Herrera Valdivia, Chile ICBM: S 39ยบ 49' 18.1", W 7

[GENERAL] Suggestion for new function on pg_catalog: get_config()

2007-09-03 Thread Luiz K. Matsumura
Hi all, I want to suggest a inclusion of an new function on the pg_catalog. Since we have set_config(text, text, boolean) can we have an get_config( text ) ? I research and find an internal function that do it, we only don't have an call for it. I think that can be like bellow (I don't know if