Re: In docs there is no "Installation from Binaries" section
On Sun, Aug 20, 2023 at 8:56 AM PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/15/install-binaries.html > Description: > > Installing software from ZIP archive is a common practice, pgsql provides > such archive, but doesn't provide instructions on what to do with it. Where are you seeing such a zip archive? I'm familiar with us producing tar gzip archives of the source code for compiling, but we don't produce binaries that I know of. https://www.postgresql.org/docs/current/install-getsource.html David J.
Re: ALTER TABLE "table" ALTER COLUMN "id" SET RESTART WITH nnn raises error
On Sun, Aug 20, 2023 at 8:56 AM PG Doc comments form wrote: > When the folloing SQL is executed: > ALTER TABLE "table" ALTER COLUMN "id" SET RESTART WITH nnn raises error > then an error is returned: > Yes, because if you take the RESTART branch in the syntax there is no word SET preceding RESTART. Please fix the documentation or the functionality. > The documentation is already correct. David J.
In docs there is no "Installation from Binaries" section
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/install-binaries.html Description: Installing software from ZIP archive is a common practice, pgsql provides such archive, but doesn't provide instructions on what to do with it. These pages don't have such instruction or links to such instruction even though it would be natural for them to belong there: https://www.postgresql.org/download/ https://www.postgresql.org/download/windows/ https://www.enterprisedb.com/download-postgresql-binaries https://www.postgresql.org/docs/current/install-binaries.html https://www.postgresqltutorial.com/postgresql-getting-started/install-postgresql/ https://www.postgresqltutorial.com/?s=zip+archive (nothing found) https://www.postgresqltutorial.com/?s=binaries (nothing found) In actual archive: .\pgsql\doc\installation-notes.html .\pgsql Please provide an instruction on this matter and add links to it to reasonable places across your web and documentation pages. Expected use case is: 1. download zip archive 2. Unzip it 3. ??? 4. Execute SQL, like: `select now();`
ALTER TABLE "table" ALTER COLUMN "id" SET RESTART WITH nnn raises error
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/sql-altertable.html Description: Hi, When the folloing SQL is executed: ALTER TABLE "table" ALTER COLUMN "id" SET RESTART WITH nnn raises error then an error is returned: > ERROR: sequence option "restart" not supported here According to the documention for Postgres 15 on ALTER TABLE, the provided command seems to be correct. Omitting 'WITH' did not help. A similar ALTER SEQUENCE table_id_seq RESTART WITH nnn works fine. The involved Postgres version is: PostgreSQL 15.3, compiled by Visual C++ build 1914, 64-bit I also found a very similar error in an old mail: https://www.postgresql.org/message-id/ed41b243-63b2-f287-e7b0-8b2ac7266d66%402ndquadrant.com Please fix the documentation or the functionality.