Re: [HACKERS] Documentation/help for materialized and recursive views

2013-07-01 Thread Alvaro Herrera
Robert Haas escribió: > On Mon, Jul 1, 2013 at 3:57 PM, Magnus Hagander wrote: > > I still think a better option to that would be to get psql to provide > > a link to the full documentation there. > > It seems like clutter to me, but I'll defer to whatever the consensus is. I second the idea of

Re: [HACKERS] Documentation/help for materialized and recursive views

2013-07-01 Thread Joshua D. Drake
On 07/01/2013 07:20 AM, David Fetter wrote: On Mon, Jul 01, 2013 at 10:05:24AM -0400, Peter Eisentraut wrote: On 6/28/13 2:27 PM, David Fetter wrote: You can run \! man from within psql, And if you're on Windows, you're Sadly Out of Luck with that. Is there an equivalent we could #ifdef in

Re: [HACKERS] Documentation/help for materialized and recursive views

2013-07-01 Thread Robert Haas
On Mon, Jul 1, 2013 at 3:57 PM, Magnus Hagander wrote: > How different are they really? Yes, they are very different from an > implementation standpoint, from an enduser perspective they really are > not. If they were, they'd probably be called something else. They're different because they consu

Re: [HACKERS] Documentation/help for materialized and recursive views

2013-07-01 Thread Magnus Hagander
On Mon, Jul 1, 2013 at 9:26 PM, Robert Haas wrote: > On Mon, Jul 1, 2013 at 10:20 AM, David Fetter wrote: >> With deepest respect, failing to provide documentation to users on our >> widest-deployed platform seems pretty hostile to me. > > Yes, that would be pretty hostile. However, we don't do

Re: [HACKERS] Documentation/help for materialized and recursive views

2013-07-01 Thread Andrew Dunstan
On 07/01/2013 03:26 PM, Robert Haas wrote: Regardless of whether you agree with or disagree with the above statement, building a high-quality documentation reader into psql so that users who are running Windows but not mingw, cygwin, or pgAdmin can access the documentation more easily doesn't se

Re: [HACKERS] Documentation/help for materialized and recursive views

2013-07-01 Thread Robert Haas
On Mon, Jul 1, 2013 at 10:20 AM, David Fetter wrote: > With deepest respect, failing to provide documentation to users on our > widest-deployed platform seems pretty hostile to me. Yes, that would be pretty hostile. However, we don't do anything that remotely resembles that statement, nor has an

Re: [HACKERS] Documentation/help for materialized and recursive views

2013-07-01 Thread David Fetter
On Mon, Jul 01, 2013 at 10:52:55AM -0400, Peter Eisentraut wrote: > On 7/1/13 10:20 AM, David Fetter wrote: > > On Mon, Jul 01, 2013 at 10:05:24AM -0400, Peter Eisentraut wrote: > >> On 6/28/13 2:27 PM, David Fetter wrote: > You can run \! man from within psql, > >>> And if you're on Windows,

Re: [HACKERS] Documentation/help for materialized and recursive views

2013-07-01 Thread Peter Eisentraut
On 7/1/13 10:20 AM, David Fetter wrote: > On Mon, Jul 01, 2013 at 10:05:24AM -0400, Peter Eisentraut wrote: >> On 6/28/13 2:27 PM, David Fetter wrote: You can run \! man from within psql, >>> And if you're on Windows, you're Sadly Out of Luck with that. Is >>> there an equivalent we could #if

Re: [HACKERS] Documentation/help for materialized and recursive views

2013-07-01 Thread David Fetter
On Mon, Jul 01, 2013 at 10:05:24AM -0400, Peter Eisentraut wrote: > On 6/28/13 2:27 PM, David Fetter wrote: > >> You can run \! man from within psql, > > And if you're on Windows, you're Sadly Out of Luck with that. Is > > there an equivalent we could #ifdef in for that platform? > > If you are u

Re: [HACKERS] Documentation/help for materialized and recursive views

2013-07-01 Thread Peter Eisentraut
On 6/28/13 2:27 PM, David Fetter wrote: >> You can run \! man from within psql, > And if you're on Windows, you're Sadly Out of Luck with that. Is > there an equivalent we could #ifdef in for that platform? If you are using psql on Windows extensively, you probably have one of mingw, cygwin, or p

Re: [HACKERS] Documentation/help for materialized and recursive views

2013-06-28 Thread David Fetter
On Fri, Jun 28, 2013 at 01:34:17PM -0400, Peter Eisentraut wrote: > On 6/28/13 10:49 AM, Alvaro Herrera wrote: > > Magnus Hagander escribió: > > > >> They are already crosslinked under "see also". But that doesn't > >> really help the guy doing "\h CREATE VIEW" in psql, which was the > >> case whe

Re: [HACKERS] Documentation/help for materialized and recursive views

2013-06-28 Thread Alvaro Herrera
Peter Eisentraut escribió: > On 6/28/13 10:49 AM, Alvaro Herrera wrote: > > Magnus Hagander escribió: > > > >> They are already crosslinked under "see also". But that doesn't really > >> help the guy doing "\h CREATE VIEW" in psql, which was the case where > >> it was brought to my attention. > >

Re: [HACKERS] Documentation/help for materialized and recursive views

2013-06-28 Thread Peter Eisentraut
On 6/28/13 10:49 AM, Alvaro Herrera wrote: > Magnus Hagander escribió: > >> They are already crosslinked under "see also". But that doesn't really >> help the guy doing "\h CREATE VIEW" in psql, which was the case where >> it was brought to my attention. > > Maybe \h should somehow display the "s

Re: [HACKERS] Documentation/help for materialized and recursive views

2013-06-28 Thread Magnus Hagander
On Fri, Jun 28, 2013 at 4:49 PM, Alvaro Herrera wrote: > Magnus Hagander escribió: > >> They are already crosslinked under "see also". But that doesn't really >> help the guy doing "\h CREATE VIEW" in psql, which was the case where >> it was brought to my attention. > > Maybe \h should somehow dis

Re: [HACKERS] Documentation/help for materialized and recursive views

2013-06-28 Thread Alvaro Herrera
Magnus Hagander escribió: > They are already crosslinked under "see also". But that doesn't really > help the guy doing "\h CREATE VIEW" in psql, which was the case where > it was brought to my attention. Maybe \h should somehow display the "see also" section? -- Álvaro Herrerah

Re: [HACKERS] Documentation/help for materialized and recursive views

2013-06-28 Thread Magnus Hagander
On Fri, Jun 28, 2013 at 5:54 AM, Kevin Grittner wrote: > Robert Haas wrote: >> Magnus Hagander wrote: > The functionality of materialized views will (over time) totally swamp that of normal views, so mixing all the corresponding documentation with the documentation for normal v

Re: [HACKERS] Documentation/help for materialized and recursive views

2013-06-27 Thread Kevin Grittner
Robert Haas wrote: > Magnus Hagander wrote: >>> The functionality of materialized views will (over time) totally swamp >>> that of normal views, so mixing all the corresponding documentation >>> with the documentation for normal views probably doesn’t make things >>> easier for people that a

Re: [HACKERS] Documentation/help for materialized and recursive views

2013-06-27 Thread Robert Haas
On Thu, Jun 27, 2013 at 5:29 AM, Magnus Hagander wrote: >> The functionality of materialized views will (over time) totally swamp >> that of normal views, so mixing all the corresponding documentation >> with the documentation for normal views probably doesn’t make things >> easier for people that

Re: [HACKERS] Documentation/help for materialized and recursive views

2013-06-27 Thread Magnus Hagander
On Thu, Jun 27, 2013 at 10:56 AM, Nicolas Barbier wrote: > 2013/6/27 Magnus Hagander : > >> Is there a particular reason why CREATE RECURSIVE VIEW is part of the >> help for CREATE VIEW, but CREATE MATERIALIZED VIEW doesn't show up >> there? >> >> I realize the technical reason (they're different

Re: [HACKERS] Documentation/help for materialized and recursive views

2013-06-27 Thread Nicolas Barbier
2013/6/27 Magnus Hagander : > Is there a particular reason why CREATE RECURSIVE VIEW is part of the > help for CREATE VIEW, but CREATE MATERIALIZED VIEW doesn't show up > there? > > I realize the technical reason (they're different man pages, and that > also controls what's in \h in psql which is

[HACKERS] Documentation/help for materialized and recursive views

2013-06-27 Thread Magnus Hagander
Is there a particular reason why CREATE RECURSIVE VIEW is part of the help for CREATE VIEW, but CREATE MATERIALIZED VIEW doesn't show up there? I realize the technical reason (they're different man pages, and that also controls what's in \h in psql which is where I ran into it), but was there any