From: | jotpe <jotpe(at)posteo(dot)de> |
---|---|
To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | [PATCH] fix wrong create table statement in documentation |
Date: | 2017-11-08 20:49:15 |
Message-ID: | 78933bd0-45ce-690e-b832-a328dd1a5567@posteo.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
In the current documentation [1] this create table statement is listed:
CREATE TABLE measurement_y2008m01 PARTITION OF measurement
FOR VALUES FROM ('2008-01-01') TO ('2008-02-01')
TABLESPACE fasttablespace
WITH (parallel_workers = 4);
But that did not work:
2017-11-06 22:26:11.757 CET [4699] ERROR: syntax error at or near
"WITH" at character 130
2017-11-06 22:26:11.757 CET [4699] STATEMENT: create table
measurement_y2008m01 partition of measurement for values from
('2008-01-01') to ('2008-02-01') tablespace fastspace WITH (
parallel_workers = 4 );
^
The TABLESPACE part should be listed behind the WITH storage parameter.
I attachted the patch.
[1]
https://www.postgresql.org/docs/10/static/ddl-partitioning.html#ddl-partitioning-declarative
Attachment | Content-Type | Size |
---|---|---|
correct_ddl_query_in_doc.patch | text/x-patch | 708 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2017-11-08 20:59:43 | Re: Small improvement to compactify_tuples |
Previous Message | Юрий Соколов | 2017-11-08 20:44:50 | Re: Small improvement to compactify_tuples |