Re: default tablespace for roles - Mailing list pgsql-patches

From Tom Lane
Subject Re: default tablespace for roles
Date
Msg-id 23527.1123350356@sss.pgh.pa.us
Whole thread Raw
In response to default tablespace for roles  (Laszlo Hornyak <kocka@forgeahead.hu>)
List pgsql-patches
Laszlo Hornyak <kocka@forgeahead.hu> writes:
> It would be nice to have tablespaces for each users. This is a small
> pathc that does the job.

Isn't this entirely redundant with the existing default_tablespace GUC
variable, ie,

ALTER USER foo SET default_tablespace = whatever;

The patch's behavior of overriding session-local settings of
default_tablespace seems quite undesirable in any case.

            regards, tom lane

pgsql-patches by date:

Previous
From: Laszlo Hornyak
Date:
Subject: default tablespace for roles
Next
From: Mark Wong
Date:
Subject: Re: [HACKERS] O_DIRECT for WAL writes