From thom@linux.com Mon Jun 1 08:15:52 2026 Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id D32FFB5DBEE for ; Mon, 15 Aug 2011 13:58:44 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 82097-08 for ; Mon, 15 Aug 2011 16:58:34 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp1.linux-foundation.org (smtp1.linux-foundation.org [140.211.169.13]) by mail.postgresql.org (Postfix) with ESMTP id 2F3A1B5D803 for ; Mon, 15 Aug 2011 13:58:33 -0300 (ADT) Received: from mail-wy0-f174.google.com (mail-wy0-f174.google.com [74.125.82.174]) (authenticated bits=0) by smtp1.linux-foundation.org (8.14.2/8.13.5/Debian-3ubuntu1.1) with ESMTP id p7FGwUls005572 (version=TLSv1/SSLv3 cipher=RC4-SHA bits=128 verify=FAIL) for ; Mon, 15 Aug 2011 09:58:32 -0700 Received: by wyg24 with SMTP id 24so3626860wyg.19 for ; Mon, 15 Aug 2011 09:58:30 -0700 (PDT) Received: by 10.216.160.4 with SMTP id t4mr2218664wek.109.1313427510292; Mon, 15 Aug 2011 09:58:30 -0700 (PDT) MIME-Version: 1.0 Received: by 10.216.26.145 with HTTP; Mon, 15 Aug 2011 09:58:00 -0700 (PDT) From: Thom Brown Date: Mon, 15 Aug 2011 17:58:00 +0100 Message-ID: Subject: Foreign server version and type To: pgsql-docs Content-Type: multipart/alternative; boundary=0016e64c1a4e30729d04aa8e2c01 X-MIMEDefang-Filter: lf$Revision: 1.188 $ X-Scanned-By: MIMEDefang 2.63 on 140.211.169.13 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-5 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201108/9 X-Sequence-Number: 6899 --0016e64c1a4e30729d04aa8e2c01 Content-Type: text/plain; charset=ISO-8859-1 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 --0016e64c1a4e30729d04aa8e2c01 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hi,

I'm looking at the CREATE SERVER page on the doc= umentation (http://www.postgresql.org/docs/9.1/static/sql-createserver.htm= l) 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 wa= nt to use them. =A0Are these parameters used for anything, or are they pure= ly for future functionality? =A0Whatever the case, could some kind of elabo= ration be added to justify the existence of these options? =A0They have bee= n in the docs since the CREATE SERVER syntax was introduced in 8.4.

Thanks

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

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--0016e64c1a4e30729d04aa8e2c01-- From heikki.linnakangas@enterprisedb.com Mon Jun 1 08:15:52 2026 Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id A9BFCB5DBCC for ; Mon, 15 Aug 2011 14:36:50 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 82982-03 for ; Mon, 15 Aug 2011 17:36:44 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from exprod7og108.obsmtp.com (exprod7og108.obsmtp.com [64.18.2.169]) by mail.postgresql.org (Postfix) with ESMTP id A520EB5DBC4 for ; Mon, 15 Aug 2011 14:36:43 -0300 (ADT) Received: from mail-fx0-f50.google.com ([209.85.161.50]) (using TLSv1) by exprod7ob108.postini.com ([64.18.6.12]) with SMTP ID DSNKTklZKjhsoRkW4/r+/qVc53XTmI/Kb52Y@postini.com; Mon, 15 Aug 2011 10:36:44 PDT Received: by fxh2 with SMTP id 2so4555590fxh.37 for ; Mon, 15 Aug 2011 10:36:41 -0700 (PDT) Received: by 10.223.93.201 with SMTP id w9mr4247880fam.52.1313429801177; Mon, 15 Aug 2011 10:36:41 -0700 (PDT) Received: from [192.168.1.183] (dsl-hkibrasgw2-ff7ac300-240.dhcp.inet.fi [88.195.122.240]) by mx.google.com with ESMTPS id d1sm5180103fai.28.2011.08.15.10.36.38 (version=TLSv1/SSLv3 cipher=OTHER); Mon, 15 Aug 2011 10:36:39 -0700 (PDT) Message-ID: <4E495924.3010405@enterprisedb.com> Date: Mon, 15 Aug 2011 20:36:36 +0300 From: Heikki Linnakangas User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; fi-FI; rv:1.9.2.18) Gecko/20110626 Icedove/3.1.11 MIME-Version: 1.0 To: Thom Brown CC: pgsql-docs Subject: Re: Foreign server version and type References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201108/10 X-Sequence-Number: 6900 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 From bruce@momjian.us Mon Jun 1 08:15:52 2026 Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1T1fot-00043X-Qh for pgsql-docs@postgresql.org; Wed, 15 Aug 2012 15:47:43 +0000 Received: from momjian.us ([72.94.173.45]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1T1fos-0006CE-Dh for pgsql-docs@postgresql.org; Wed, 15 Aug 2012 15:47:43 +0000 Received: from bruce by momjian.us with local (Exim 4.72) (envelope-from ) id 1T1for-0001V8-1M; Wed, 15 Aug 2012 11:47:41 -0400 Date: Wed, 15 Aug 2012 11:47:41 -0400 From: Bruce Momjian To: Heikki Linnakangas Cc: Thom Brown , pgsql-docs Subject: Re: Foreign server version and type Message-ID: <20120815154741.GH25473@momjian.us> References: <4E495924.3010405@enterprisedb.com> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="w7PDEPdKQumQfZlR" Content-Disposition: inline In-Reply-To: <4E495924.3010405@enterprisedb.com> User-Agent: Mutt/1.5.20 (2009-06-14) X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201208/22 X-Sequence-Number: 7415 --w7PDEPdKQumQfZlR Content-Type: text/plain; charset=us-ascii Content-Disposition: inline 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 http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + --w7PDEPdKQumQfZlR Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename="foreign.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 server_type ! Optional server type. --- 69,75 ---- server_type ! Optional server type, potentially useful to foreign-data wrappers. *************** CREATE SERVER server_version ! Optional server version. --- 78,84 ---- server_version ! Optional server version, potentially useful to foreign-data wrappers. --w7PDEPdKQumQfZlR-- From thom@linux.com Mon Jun 1 08:15:52 2026 Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1T1fsV-0006eY-UY for pgsql-docs@postgresql.org; Wed, 15 Aug 2012 15:51:28 +0000 Received: from mail-vc0-f174.google.com ([209.85.220.174]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1T1fsU-0006GO-AV for pgsql-docs@postgresql.org; Wed, 15 Aug 2012 15:51:27 +0000 Received: by vcbfk26 with SMTP id fk26so1585190vcb.19 for ; Wed, 15 Aug 2012 08:51:25 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:sender:in-reply-to:references:from:date :x-google-sender-auth:message-id:subject:to:cc:content-type; bh=G+5EJf/XnuZ5S+BQGF6dypmeMdwxHu/AXbUqgMn4WPE=; b=zxkJKtkc7+KIf6jpnphJ1mi6ANQUaF/aJig8fJjEGo1tMpJpBl3EjRTonrTMsmxImO sTvDwT96w6JOdzSF8JF/CNG4Cm01QnZrZ2/6jSPdQN4erv77k/TZTJFw3yDpir7xdMgC Z91oemmz7+LpywhButG/9t20LCV5upn/U9XI2Ggn8GGTHURoaSPmZ0IB7Pwf76j/fCGJ x4wE6/l2dF4DRbMsZVUIjrAETX0RTjjG9fM37OrrVi1Tn6hGEL8SEO7u+g/Wa09NVjqq Ejpnew4ci6UDyKHpm5wisSqodhSiB1nnX7RvZD/SQVWxRxYsNst8t7M2HCGSh4ut6qLc 9QYQ== Received: by 10.58.32.234 with SMTP id m10mr14417442vei.60.1345045885024; Wed, 15 Aug 2012 08:51:25 -0700 (PDT) MIME-Version: 1.0 Received: by 10.58.15.130 with HTTP; Wed, 15 Aug 2012 08:50:54 -0700 (PDT) In-Reply-To: <20120815154741.GH25473@momjian.us> References: <4E495924.3010405@enterprisedb.com> <20120815154741.GH25473@momjian.us> From: Thom Brown Date: Wed, 15 Aug 2012 16:50:54 +0100 X-Google-Sender-Auth: tw41LuQWyW8yLICUEu2C0PHQwFM Message-ID: Subject: Re: Foreign server version and type To: Bruce Momjian Cc: Heikki Linnakangas , pgsql-docs Content-Type: text/plain; charset=ISO-8859-1 X-Pg-Spam-Score: -2.6 (--) X-Archive-Number: 201208/23 X-Sequence-Number: 7416 On 15 August 2012 16:47, Bruce Momjian 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