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