Re: BUG #16026: default_tablespace in postgresql.conf is used insteadof the database's default. - Mailing list pgsql-bugs

From Thomas Munro
Subject Re: BUG #16026: default_tablespace in postgresql.conf is used insteadof the database's default.
Date
Msg-id CA+hUKGJ+FesUiNhM-tLWhEMPmZs0S=S_yZm1=ire48Sf4h66Dw@mail.gmail.com
Whole thread Raw
In response to Re: BUG #16026: default_tablespace in postgresql.conf is used instead of the database's default.  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #16026: default_tablespace in postgresql.conf is used insteadof the database's default.
List pgsql-bugs
On Fri, Sep 27, 2019 at 3:01 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> PG Bug reporting form <noreply@postgresql.org> writes:
> > 1- create a tablespace data  (whereever you want it to be). Note that data
> > is lowercase without quotation marks.
> > 2- set default_tablespace='DATA' in postgresql.conf. Note this is un
> > UPPERCASE.
> > 3- reload conf.
> > 4- create a database with default tablespace data (lowercase).
> > 5- create a query that is using parallel (gather step) to seq scan.
>
> This is the same issue discussed in
>
> https://www.postgresql.org/message-id/flat/15726-6d67e4fa14f027b3%40postgresql.org
>
> I'm not sure why progress on that thread has come to a dead halt,
> but in any case, the general opinion seems to be that all we're
> going to do about it is improve the error reporting.  Wrong values
> in postgresql.conf aren't a well-supported or encouraged situation,
> even if it seems to mostly work for default_tablespace.

Erm, yeah.  I will fix that early next week.

-- 
Thomas Munro
https://enterprisedb.com



pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #16028: JDBC currentSchema connection parameter not working for text search configuration
Next
From: PG Bug reporting form
Date:
Subject: BUG #16029: pg_basebackup - At least one WAL file is missing