Re: 9.17. Sequence Manipulation Functions

2021-10-08 Thread Pantelis Theodosiou
On Fri, Oct 8, 2021 at 12:12 PM PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/14/functions-sequence.html > Description: > > Just a slip of the pen in the table "Function Description", in tha string: > "s

Re: small patch

2021-10-08 Thread Laurenz Albe
On Thu, 2021-10-07 at 16:06 -0400, rir wrote: > > > > - we should retain "empty or one of", otherwise the following syntax > > > > would be undocumented: > > For myself, >'FETCH [ [ FROM | IN ] ] ' > clearly indicates that 'direction' is optional. Yes, but since [ FROM | IN ] is inside the

9.17. Sequence Manipulation Functions

2021-10-08 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/functions-sequence.html Description: Just a slip of the pen in the table "Function Description", in tha string: "setval ( regclass, bigint [, boolean ] ) → bigint", i think that something

vacuumdb --analyze-in-stages

2021-10-08 Thread nikolai.berkoff
Running --analyze-in-stages on a database with statistics causes the statistics to become significantly worse before they are improved. This could be made clearer in the documentation.diff --git i/doc/src/sgml/ref/vacuumdb.sgml w/doc/src/sgml/ref/vacuumdb.sgml index 223b986..d76c18e 100644 --- i

ALTER TABLE ... SET DATA TYPE removes statistics

2021-10-08 Thread nikolai.berkoff
The current documentation does not mention that the column statistics are removed which I can see they are in src/backend/commands/tablecmds.c ATExecAlterColumnType /* * Drop any pg_statistic entry for the column, since it's now wrong type */ RemoveStatistics(Rel

Fwd: PostgreSQL 12 Authentication type questions

2021-10-08 Thread Anitha P
> Hello Postgresql Team, > > I have a question for you. > > If we would like to implement ldap authentication as well as password > authentication for some users at a same time (like authentication type as > password, global in oracle), Is there any option with postgresql 12? I did > tested passwor