[DOCS] Foreign server version and type

2011-08-15 Thread Thom Brown
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


Re: [DOCS] Foreign server version and type

2011-08-15 Thread Heikki Linnakangas

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

--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs


Re: [DOCS] postgres-9.1beta3 typo: recommendable --> recommended

2011-08-15 Thread Robert Haas
On Tue, Aug 2, 2011 at 12:53 AM, Jaime Casanova  wrote:
> On Fri, Jul 29, 2011 at 1:42 AM, Gavin Flower
>  wrote:
>> /postgres-9.1/share/doc/html/manage-ag-overview.html
>> In the folowing partagrasoh 'recommendable' should be 'recommended'.
>>
>> [...]
>> Databases are physically separated and access
>> control is managed at the connection level. If one PostgreSQL server
>> instance is to house projects or users that should be separate and for the
>> most part unaware of each other, it is therefore recommendable to put them
>> into separate databases. If the projects or users are interrelated and
>> should be able to use each other's resources, they should be put in the same
>> database but possibly into separate schemas.
>> [...]
>>
>
> maybe it's because i'm not a natural english speaker but this sounds
> like we are recommended to put the users in another database. probably
> it is refering to the user's resources... maybe we can make it more
> explicit?

The only thing that seems weird about it to me is that recommendable
is a word that is almost never used by native English speakers.  Or at
least not the native English speakers I know.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

-- 
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs