Postgres Pro
Downloads
Home   >   mailing lists

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

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


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. 

pgsql-sql by date:

Previous
From: Igor Neyman
Date:
Subject: Re: remove tablespace for primary key (*not* by drop/recreate constraint)
Next
From: Emi Lu
Date:
Subject: Re: remove tablespace for primary key (*not* by drop/recreate constraint)