Postgres Pro
Downloads
Home   >   mailing lists

Re: remove tablespace for primary key (*not* by drop/recreate constraint) - Mailing list pgsql-sql

From Igor Neyman
Subject Re: remove tablespace for primary key (*not* by drop/recreate constraint)
Date
Msg-id A76B25F2823E954C9E45E32FA49D70ECCD45F22C@mail.corp.perceptron.com
Whole thread Raw
In response to Re: remove tablespace for primary key (*not* by drop/recreate constraint)  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-sql
Tree view

 

 

From: David G. Johnston [mailto:david.g.johnston@gmail.com]
Sent: Friday, June 05, 2015 9:59 AM
To: Igor Neyman
Cc: emilu@encs.concordia.ca; pgsql-sql@postgresql.org
Subject: Re: [SQL] remove tablespace for primary key (*not* by drop/recreate constraint)

 



On Friday, June 5, 2015, Igor Neyman <ineyman@perceptron.com> wrote:

I think this is what I prefer to run. But it seems that schema owner does not have permission to run it. 


"permission denied for tablespace pg_default"

GRANT USAGE ON SCHEMA…

 

Tablespace != schema ...

 

David J. 

 

--

You are right, of course:

 

GRANT CREATE ON TABLESPACE…

 

Igor Neyman

 

pgsql-sql by date:

Previous
From: Emi Lu
Date:
Subject: Re: remove tablespace for primary key (*not* by drop/recreate constraint)
Next
From: Jon Forsyth
Date:
Subject: Renumber Primary Keys and Update the same as Foreign Keys