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