Re: [HACKERS] TODO: You can alter it, but you can't view it

2011-02-26 Thread Bruce Momjian
bruce wrote: Josh Berkus wrote: Right now pg_options_to_table() is not documented. Should it be? Yes, I think so. Done, with the attached, applied patch. Oh, here is an example usage: test= select pg_options_to_table(reloptions) from pg_class;

Re: [HACKERS] TODO: You can alter it, but you can't view it

2011-02-25 Thread Bruce Momjian
Josh Berkus wrote: Right now pg_options_to_table() is not documented. Should it be? Yes, I think so. Done, with the attached, applied patch. -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + It's

Re: [HACKERS] TODO: You can alter it, but you can't view it

2011-02-22 Thread Josh Berkus
Right now pg_options_to_table() is not documented. Should it be? Yes, I think so. -- -- Josh Berkus PostgreSQL Experts Inc. http://www.pgexperts.com -- Sent via pgsql-hackers

Re: [HACKERS] TODO: You can alter it, but you can't view it

2011-02-21 Thread Bruce Momjian
Itagaki Takahiro wrote: On Mon, Sep 27, 2010 at 2:19 PM, Josh Berkus j...@agliodbs.com wrote: While working on some database maintenance, I was just tripped up by the fact that there is no good way to query reloptions for tables. ?By no good way I mean no way which does not involve UNNEST

Re: [HACKERS] TODO: You can alter it, but you can't view it

2010-09-27 Thread Josh Berkus
Can you use pg_options_to_table() for your purpose? Yes, thanks. What version did that get added in? Even for 9.0, that function doesn't seem to appear in the docs. -- -- Josh Berkus PostgreSQL Experts Inc.

Re: [HACKERS] TODO: You can alter it, but you can't view it

2010-09-27 Thread Itagaki Takahiro
On Mon, Sep 27, 2010 at 4:39 PM, Josh Berkus j...@agliodbs.com wrote: Can you use pg_options_to_table() for your purpose? Yes, thanks.  What version did that get added in?  Even for 9.0, that function doesn't seem to appear in the docs. I found it in 8.4 and newer versions. It might be an

Re: [HACKERS] TODO: You can alter it, but you can't view it

2010-09-27 Thread Bernd Helmle
--On 27. September 2010 16:54:32 +0900 Itagaki Takahiro itagaki.takah...@gmail.com wrote: I found it in 8.4 and newer versions. It might be an internal API (for pg_dump?), but it'd be better to add documentation for it. Additionally we could extend pg_tables with an additional column?

[HACKERS] TODO: You can alter it, but you can't view it

2010-09-26 Thread Josh Berkus
All, While working on some database maintenance, I was just tripped up by the fact that there is no good way to query reloptions for tables. By no good way I mean no way which does not involve UNNEST and regexps or procedural code. This puts us in the wierd place that while one can ALTER

Re: [HACKERS] TODO: You can alter it, but you can't view it

2010-09-26 Thread Itagaki Takahiro
On Mon, Sep 27, 2010 at 2:19 PM, Josh Berkus j...@agliodbs.com wrote: While working on some database maintenance, I was just tripped up by the fact that there is no good way to query reloptions for tables.  By no good way I mean no way which does not involve UNNEST and regexps or procedural