Re: [HACKERS] default_tablespace

2011-02-17 Thread Alvaro Herrera
Excerpts from Florian Pflug's message of jue feb 17 16:55:55 -0300 2011: > You can, however, do ALTER USER SET default_tablespace=, > which will > cause default_tablespace to be set automatically upon login for that user. > > I don't know of the top of my head how we store that in the system ca

Re: [HACKERS] default_tablespace

2011-02-17 Thread David Kerr
On Thu, Feb 17, 2011 at 08:55:55PM +0100, Florian Pflug wrote: - On Feb17, 2011, at 18:32 , David Kerr wrote: - > On Wed, Feb 16, 2011 at 03:59:13PM -0800, carl clemens wrote: - > - After reviewing docs and searching web - > - cannot find out how to determine the default tablespace - > - of a user?

Re: [HACKERS] default_tablespace

2011-02-17 Thread Florian Pflug
On Feb17, 2011, at 18:32 , David Kerr wrote: > On Wed, Feb 16, 2011 at 03:59:13PM -0800, carl clemens wrote: > - After reviewing docs and searching web > - cannot find out how to determine the default tablespace > - of a user? > > It doesn't appear to me that default tablespaces are assigned to a

Re: [HACKERS] default_tablespace

2011-02-17 Thread David Kerr
On Wed, Feb 16, 2011 at 03:59:13PM -0800, carl clemens wrote: - Hi Hackers, - - After reviewing docs and searching web - cannot find out how to determine the default tablespace - of a user? - - Like: - - select spcname from blab where roloid = ; - - Is this possible? - - Thank you for your

[HACKERS] default_tablespace

2011-02-17 Thread carl clemens
Hi Hackers, After reviewing docs and searching web cannot find out how to determine the default tablespace of a user? Like: select spcname from blab where roloid = ; Is this possible? Thank you for your time. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org