Thread: create foreign table
http://www.postgresql.org/docs/9.1/static/sql-createforeigntable.html It would be helpful if "SERVER" was defined if the parameters list on this page.
On Mon, Sep 12, 2011 at 8:42 AM, Ray Stell <stellr@cns.vt.edu> wrote: > http://www.postgresql.org/docs/9.1/static/sql-createforeigntable.html > It would be helpful if "SERVER" was defined if the parameters list > on this page. We don't usually document required keywords - they're just required. We do document the meaning of server_name, which I think is probably what you were after. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
On Thu, Sep 15, 2011 at 06:43:59AM -0500, Robert Haas wrote: >> On Mon, Sep 12, 2011 at 8:42 AM, Ray Stell <stellr@cns.vt.edu> wrote: >> > http://www.postgresql.org/docs/9.1/static/sql-createforeigntable.html >> > It would be helpful if "SERVER" was defined if the parameters list >> > on this page. >> >> We don't usually document required keywords - they're just required. >> We do document the meaning of server_name, which I think is probably >> what you were after. >> >> -- >> Robert Haas >> EnterpriseDB: http://www.enterprisedb.com >> The Enterprise PostgreSQL Company > > >Thanks, Robert. > >Maybe if you just added a pointer to the "CREATE SERVER" command in >your definition of server_name it would provide a bread crumb. > Oh, I see my mistake. Maybe the inclusion of a link to "CREATE SERVER" http://www.postgresql.org/docs/9.1/static/sql-createserver.html in the server_name definition would be helpful, just like in the data_type line. I was having trouble making the leap since the idea was a new one on me. different topic 1: When I put the word "foreign" in the search area on this page http://www.postgresql.org/docs/9.1/static/index.html it does not find create foreign table. different topic 2: Is there a way to know what chapter you are in when on any page of the docs? Maybe add to the navigation line at the top: Home -> Documentation -> Manuals -> PostgreSQL 9.1 -> PUT YOUR CHAPTER HERE? like this: Home -> Documentation -> Manuals -> PostgreSQL 9.1 -> I. SQL Commands
On Thu, Sep 15, 2011 at 12:51 PM, Ray Stell <stellr@cns.vt.edu> wrote: > Oh, I see my mistake. Maybe the inclusion of a link to "CREATE SERVER" > http://www.postgresql.org/docs/9.1/static/sql-createserver.html in the > server_name definition would be helpful, just like in the data_type line. > I was having trouble making the leap since the idea was a new one on me. > > different topic 1: > > When I put the word "foreign" in the search area on this page > http://www.postgresql.org/docs/9.1/static/index.html > it does not find create foreign table. Yes. AFAICT, somehow that search has become hopelessly broken. It doesn't seem to find anything. I am pretty sure that it did before. > different topic 2: > > Is there a way to know what chapter you are in when on any page of the docs? > Maybe add to the navigation line at the top: > > Home -> Documentation -> Manuals -> PostgreSQL 9.1 -> PUT YOUR CHAPTER HERE? > > like this: > > Home -> Documentation -> Manuals -> PostgreSQL 9.1 -> I. SQL Commands That's not a bad idea either. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
On Thu, Sep 15, 2011 at 12:51:57PM -0400, Ray Stell wrote: > On Thu, Sep 15, 2011 at 06:43:59AM -0500, Robert Haas wrote: > >> On Mon, Sep 12, 2011 at 8:42 AM, Ray Stell <stellr@cns.vt.edu> wrote: > >> > http://www.postgresql.org/docs/9.1/static/sql-createforeigntable.html > >> > It would be helpful if "SERVER" was defined if the parameters list > >> > on this page. > >> > >> We don't usually document required keywords - they're just required. > >> We do document the meaning of server_name, which I think is probably > >> what you were after. > >> > >> -- > >> Robert Haas > >> EnterpriseDB: http://www.enterprisedb.com > >> The Enterprise PostgreSQL Company > > > > > >Thanks, Robert. > > > >Maybe if you just added a pointer to the "CREATE SERVER" command in > >your definition of server_name it would provide a bread crumb. > > > > Oh, I see my mistake. Maybe the inclusion of a link to "CREATE SERVER" > http://www.postgresql.org/docs/9.1/static/sql-createserver.html in the > server_name definition would be helpful, just like in the data_type line. > I was having trouble making the leap since the idea was a new one on me. I have done as you suggested with the attached patch which will appear in Postgres 9.3. -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. +