public inbox for [email protected]  
help / color / mirror / Atom feed
Foreign server version and type
4+ messages / 3 participants
[nested] [flat]

* Foreign server version and type
@ 2011-08-15 16:58 Thom Brown <[email protected]>
  2011-08-15 17:36 ` Re: Foreign server version and type Heikki Linnakangas <[email protected]>
  0 siblings, 1 reply; 4+ messages in thread

From: Thom Brown @ 2011-08-15 16:58 UTC (permalink / raw)
  To: pgsql-docs

Hi,

I'm looking at the CREATE SERVER page on the documentation (
http://www.postgresql.org/docs/9.1/static/sql-createserver.html) and noticed
that there's a server_version parameter which can be provided with the
keyword VERSION and server_type specified after TYPE.

However, there's zero information about what these are used for, whether
they have any bearing on anything or why you'd want to use them.  Are these
parameters used for anything, or are they purely for future functionality?
 Whatever the case, could some kind of elaboration be added to justify the
existence of these options?  They have been in the docs since the CREATE
SERVER syntax was introduced in 8.4.

Thanks

-- 
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Foreign server version and type
  2011-08-15 16:58 Foreign server version and type Thom Brown <[email protected]>
@ 2011-08-15 17:36 ` Heikki Linnakangas <[email protected]>
  2012-08-15 15:47   ` Re: Foreign server version and type Bruce Momjian <[email protected]>
  0 siblings, 1 reply; 4+ messages in thread

From: Heikki Linnakangas @ 2011-08-15 17:36 UTC (permalink / raw)
  To: Thom Brown <[email protected]>; +Cc: pgsql-docs

On 15.08.2011 19:58, Thom Brown wrote:
> I'm looking at the CREATE SERVER page on the documentation (
> http://www.postgresql.org/docs/9.1/static/sql-createserver.html) and noticed
> that there's a server_version parameter which can be provided with the
> keyword VERSION and server_type specified after TYPE.
>
> However, there's zero information about what these are used for, whether
> they have any bearing on anything or why you'd want to use them.  Are these
> parameters used for anything, or are they purely for future functionality?
>   Whatever the case, could some kind of elaboration be added to justify the
> existence of these options?  They have been in the docs since the CREATE
> SERVER syntax was introduced in 8.4.

It's in the SQL spec. It isn't used anything by PostgreSQL itself, but a 
wrapper could look at it. It would probably be good to say that 
explicitly in the docs.

-- 
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Foreign server version and type
  2011-08-15 16:58 Foreign server version and type Thom Brown <[email protected]>
  2011-08-15 17:36 ` Re: Foreign server version and type Heikki Linnakangas <[email protected]>
@ 2012-08-15 15:47   ` Bruce Momjian <[email protected]>
  2012-08-15 15:50     ` Re: Foreign server version and type Thom Brown <[email protected]>
  0 siblings, 1 reply; 4+ messages in thread

From: Bruce Momjian @ 2012-08-15 15:47 UTC (permalink / raw)
  To: Heikki Linnakangas <[email protected]>; +Cc: Thom Brown <[email protected]>; pgsql-docs

On Mon, Aug 15, 2011 at 08:36:36PM +0300, Heikki Linnakangas wrote:
> On 15.08.2011 19:58, Thom Brown wrote:
> >I'm looking at the CREATE SERVER page on the documentation (
> >http://www.postgresql.org/docs/9.1/static/sql-createserver.html) and noticed
> >that there's a server_version parameter which can be provided with the
> >keyword VERSION and server_type specified after TYPE.
> >
> >However, there's zero information about what these are used for, whether
> >they have any bearing on anything or why you'd want to use them.  Are these
> >parameters used for anything, or are they purely for future functionality?
> >  Whatever the case, could some kind of elaboration be added to justify the
> >existence of these options?  They have been in the docs since the CREATE
> >SERVER syntax was introduced in 8.4.
> 
> It's in the SQL spec. It isn't used anything by PostgreSQL itself,
> but a wrapper could look at it. It would probably be good to say
> that explicitly in the docs.

I have applied the attached patch to document that these fields are only
potentially useful to foreign data wrappers.

-- 
  Bruce Momjian  <[email protected]>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +


Attachments:

  [text/x-diff] foreign.diff (1.2K, 2-foreign.diff)
  download | inline diff:
diff --git a/doc/src/sgml/ref/create_server.sgml b/doc/src/sgml/ref/create_server.sgml
new file mode 100644
index be9be50..60744b2
*** a/doc/src/sgml/ref/create_server.sgml
--- b/doc/src/sgml/ref/create_server.sgml
*************** CREATE SERVER <replaceable class="parame
*** 69,75 ****
      <term><replaceable class="parameter">server_type</replaceable></term>
      <listitem>
       <para>
!       Optional server type.
       </para>
      </listitem>
     </varlistentry>
--- 69,75 ----
      <term><replaceable class="parameter">server_type</replaceable></term>
      <listitem>
       <para>
!       Optional server type, potentially useful to foreign-data wrappers.
       </para>
      </listitem>
     </varlistentry>
*************** CREATE SERVER <replaceable class="parame
*** 78,84 ****
      <term><replaceable class="parameter">server_version</replaceable></term>
      <listitem>
       <para>
!       Optional server version.
       </para>
      </listitem>
     </varlistentry>
--- 78,84 ----
      <term><replaceable class="parameter">server_version</replaceable></term>
      <listitem>
       <para>
!       Optional server version, potentially useful to foreign-data wrappers.
       </para>
      </listitem>
     </varlistentry>


^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Foreign server version and type
  2011-08-15 16:58 Foreign server version and type Thom Brown <[email protected]>
  2011-08-15 17:36 ` Re: Foreign server version and type Heikki Linnakangas <[email protected]>
  2012-08-15 15:47   ` Re: Foreign server version and type Bruce Momjian <[email protected]>
@ 2012-08-15 15:50     ` Thom Brown <[email protected]>
  0 siblings, 0 replies; 4+ messages in thread

From: Thom Brown @ 2012-08-15 15:50 UTC (permalink / raw)
  To: Bruce Momjian <[email protected]>; +Cc: Heikki Linnakangas <[email protected]>; pgsql-docs

On 15 August 2012 16:47, Bruce Momjian <[email protected]> wrote:
> On Mon, Aug 15, 2011 at 08:36:36PM +0300, Heikki Linnakangas wrote:
>> On 15.08.2011 19:58, Thom Brown wrote:
>> >I'm looking at the CREATE SERVER page on the documentation (
>> >http://www.postgresql.org/docs/9.1/static/sql-createserver.html) and noticed
>> >that there's a server_version parameter which can be provided with the
>> >keyword VERSION and server_type specified after TYPE.
>> >
>> >However, there's zero information about what these are used for, whether
>> >they have any bearing on anything or why you'd want to use them.  Are these
>> >parameters used for anything, or are they purely for future functionality?
>> >  Whatever the case, could some kind of elaboration be added to justify the
>> >existence of these options?  They have been in the docs since the CREATE
>> >SERVER syntax was introduced in 8.4.
>>
>> It's in the SQL spec. It isn't used anything by PostgreSQL itself,
>> but a wrapper could look at it. It would probably be good to say
>> that explicitly in the docs.
>
> I have applied the attached patch to document that these fields are only
> potentially useful to foreign data wrappers.

Thanks Bruce, and a very belated thanks to Heikki for the explanation.

-- 
Thom





^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2012-08-15 15:50 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-08-15 16:58 Foreign server version and type Thom Brown <[email protected]>
2011-08-15 17:36 ` Heikki Linnakangas <[email protected]>
2012-08-15 15:47   ` Bruce Momjian <[email protected]>
2012-08-15 15:50     ` Thom Brown <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox