default_tablespace and parallel queries - Mailing list pgsql-docs

From PG Doc comments form
Subject default_tablespace and parallel queries
Date
Msg-id 156950150435.1208.13620233301096219314@wrigleys.postgresql.org
Whole thread Raw
List pgsql-docs
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/11/manage-ag-tablespaces.html
Description:

Hi,

"default_tablespace" parameter  in "postgresql.conf" does something to
GATHER (in parallel query).
Because when default_tablespace is set to whatever name, and the tablespace
doesn't exist, a query using parallel query is now giving the following
error :

2019-09-25 16:42:50.444 GMT [71530] ERROR:  invalid value for parameter
"default_tablespace": "DATA"
2019-09-25 16:42:50.444 GMT [71530] DETAIL:  Tablespace "DATA" does not
exist.

So i suggest to add in documentation that this parameter have an effect on
parallel_query.
I will fill in a bug report today for this "side effect".

regards

Virgile

pgsql-docs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Do not use C++ style comments (// comments). Strict ANSI Ccompilers do not accept them.
Next
From: Andreas Bergmaier
Date:
Subject: Re: BUG #16022: to_json on arrays with unusual lower bound is notintuitive