[DOCS] why money datatype size returns with 2147483647 instead of 19,2

2017-08-24 Thread bramesh . ppl
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.1/static/datatype-money.html
Description:

As per the documentation, the size of the money datatype is 19,2 but always
returning with 2147483647.

can you clarify on this?

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


[DOCS] Useful documentation removed from 9.5 docs

2017-08-24 Thread rasmus
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.5/static/textsearch-indexes.html
Description:

I was looking for the section that provides advice on which type of index
(GIN vs GIST) to choose, and discovered that it has been removed from the
9.5/9.6 documentation.

Here's the 9.4 version:

https://www.postgresql.org/docs/9.4/static/textsearch-indexes.html

Compare with the 9.5 version:

https://www.postgresql.org/docs/9.5/static/textsearch-indexes.html

The whole section of bullet-points describing considerations for choosing
the index type were removed.

Instead, this manual page now talks mostly about implementation details,
internal details about how the GIST index internally operates, and on -
 these may be relevant to somebody, but they're likely not very useful to
the average user trying to select the appropriate index for a given
use-case.

I'm puzzled as to why this information was removed. One has to find the 9.4
version of the page via Google, or an article on StackOverflow, to get this
useful information.


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


[DOCS] pg_replication_slots page links

2017-08-24 Thread sahapasci
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.6/static/view-pg-replication-slots.html
Description:

Hi all, 
There isn't any link between 9.4 - replication slot page and other newer
ones. 

check pages;

https://www.postgresql.org/docs/9.4/static/catalog-pg-replication-slots.html


https://www.postgresql.org/docs/current/static/view-pg-replication-slots.html

cheers 




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


Re: [DOCS] Useful documentation removed from 9.5 docs

2017-08-24 Thread Tom Lane
[email protected] writes:
> I was looking for the section that provides advice on which type of index
> (GIN vs GIST) to choose, and discovered that it has been removed from the
> 9.5/9.6 documentation.

That was changed because the advice was obsolete.  See
https://www.postgresql.org/message-id/20150516123759.GB16100%40momjian.us

regards, tom lane


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


Re: [DOCS] Syntax for changing owner on sequence is not correct

2017-08-24 Thread David G. Johnston
On Thu, Aug 24, 2017 at 11:25 AM, Tarik Dolovac 
wrote:

> I am just telling you that in your officiall documentation i didn't find
> that command.
>

​What command?  Both OWNED BY and OWNER TO are parts of the ALTER SEQUENCE
command and written and described on the page you were reading when you
​filled out the form.

Note that our current release is 9.5 with 10.0 in beta.  Our search results
have a tendency to show old versions (you were reading 8.4) so ensuring
that you are on current stuff helps.

I founded oj stack owerflow and when i changed command I succesfully
> changed owner. Also one more hit: documentation will be much better with
> examples. I am DBA for a 7 years on ms sql and oracle and they have
> examples which can make life more easily if you are starting with some new
> tehnologies like postgres.
>

​Personally I tend to find well written prose and syntax specifications to
be sufficient but I don't doubt that examples are helpful.  For better and
worse this is a freely available open-source product.  We don't have a
mandate that every feature have 6 examples documented for its use.  The
volume of questions raised about ALTER SEQUENCE is so low that the
motivation to dream up and add new examples just isn't there.  If a patch
was submitted, though, it would likely be committed.

David J.