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; p

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 http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for ever

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 mailin

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 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 regex

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 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? This would make the query mor

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 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 internal API (fo

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-26 Thread Itagaki Takahiro
On Mon, Sep 27, 2010 at 2:19 PM, Josh Berkus 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 > code". Can y

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