Re: DocBook 5.2

2022-09-04 Thread Alvaro Herrera 
On 2022-Sep-04, Jürgen Purtz wrote:

> DocBook 5.2 is around the corner [1], we use DocBook 4.5 which is 'feature
> frozen' since 2006, and there are even ideas for DocBook 6.x [2].

What changes?

I doubt we'll want to adopt a new version immediately after release,
since we want to stay compatible with older systems.  But recently I had
an issue with a tag that would have worked with 5.0 and didn't with 4.5,
so let's hear what the benefits are.

-- 
Álvaro Herrera PostgreSQL Developer  —  https://www.EnterpriseDB.com/
"I'm always right, but sometimes I'm more right than other times."
  (Linus Torvalds)

DocBook 5.2

2022-09-04 Thread Jürgen Purtz 
DocBook 5.2 is around the corner [1], we use DocBook 4.5 which is 
'feature frozen' since 2006, and there are even ideas for DocBook 6.x [2].


I want to inform you that I'm working on an upgrade of our documentation 
to DocBook 5.2. Major steps have been done, but I need some more time 
before I can publish a first working draft. Please keep me informed, if 
someone else is working on the same issue.


J. Purtz

[1]: https://github.com/docbook/docbook/releases/tag/5.2CR3
[2]: 
https://github.com/docbook/docbook/issues?q=is%3Aissue+is%3Aopen+label%3Av6

Re: TABLESPACE

2022-09-04 Thread Guillaume Lelarge 
Le dim. 4 sept. 2022, 10:19, PG Doc comments form 
a écrit :

> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/14/sql-createtablespace.html
> Description:
>
> When exporting a table create script pgAdmin includes a command "TABLESPACE
> pg_default;" such as below
>
> CREATE TABLE IF NOT EXISTS "DbTest"."Test"
> (
> "TestID" integer NOT NULL GENERATED ALWAYS AS IDENTITY ( INCREMENT 1
> START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ),
> "TestName" character varying(80) COLLATE pg_catalog."default" NOT
> NULL,
> "CreateTimestamp" timestamp without time zone NOT NULL DEFAULT
> LOCALTIMESTAMP,
> "UpdateTimestamp" timestamp without time zone NOT NULL DEFAULT
> LOCALTIMESTAMP,
> CONSTRAINT "Test_pk" PRIMARY KEY ("TestID"),
> )
>
> TABLESPACE pg_default;
>

As you can see, there's no ";" between ")" and "TABLESPACE", so it's not a
command on its own but another clause of the CREATE TABLE statement. It
indicates the tablespace for the new table.

TABLESPACE

2022-09-04 Thread PG Doc comments form 
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/14/sql-createtablespace.html
Description:

When exporting a table create script pgAdmin includes a command "TABLESPACE
pg_default;" such as below

CREATE TABLE IF NOT EXISTS "DbTest"."Test"
(
"TestID" integer NOT NULL GENERATED ALWAYS AS IDENTITY ( INCREMENT 1
START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ),
"TestName" character varying(80) COLLATE pg_catalog."default" NOT
NULL,
"CreateTimestamp" timestamp without time zone NOT NULL DEFAULT
LOCALTIMESTAMP,
"UpdateTimestamp" timestamp without time zone NOT NULL DEFAULT
LOCALTIMESTAMP,
CONSTRAINT "Test_pk" PRIMARY KEY ("TestID"),
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS "DbTest"."Test"
OWNER to postgres;

What the command TABLESPACE on it's own does or how it should be used is not
documented at all

Thanks