On 01/17/2014 05:28 AM, Stephen Frost wrote: > Greetings, > > Harking back to 10 years ago when tablespaces were added, it looks > like we originally figured that users didn't need permissions to > create tables in the database default, per 2467394e. That strikes > me as perfectly fair. Unfortunately, the later addition of ALTER > TABLE ... SET TABLESPACE (af4de814) didn't get the memo about the > default tablespace being special in this regard and refuses to let > a user move their tables into the default tablespace, even though > they can do so via 'CREATE TABLE ... AS SELECT * FROM ...'. > > Barring objections, I'll add the same conditional around the > AclCheck in ATPrepSetTableSpace() as exists in DefineRelation() to > allow users to ALTER TABLE ... SET TABLESPACE into the database's > default tablespace and backpatch accordingly.
Sounds sensible. I just stumbled across a report of this bug, too: http://stackoverflow.com/questions/21193127/avoid-users-to-create-tables-on-default-tablespace -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers