Tablespace permissions issue

Поиск
Список
Период
Сортировка
Искать
От
Gavin Sherry
Тема
Tablespace permissions issue
Дата
Msg-id
Pine.LNX.4.58.0406281529570.16981@linuxworld.com.au
Список
Дерево обсуждения
Tablespace permissions issue Gavin Sherry <swm@linuxworld.com.au>
Re: Tablespace permissions issue Tom Lane <tgl@sss.pgh.pa.us>
Re: Tablespace permissions issue Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: Tablespace permissions issue Tom Lane <tgl@sss.pgh.pa.us>
Re: Tablespace permissions issue Tom Lane <tgl@sss.pgh.pa.us>
Re: Tablespace permissions issue Fabien COELHO <coelho@cri.ensmp.fr>
Re: Tablespace permissions issue Tom Lane <tgl@sss.pgh.pa.us>
Re: Tablespace permissions issue Fabien COELHO <coelho@cri.ensmp.fr>
Re: Tablespace permissions issue Gavin Sherry <swm@linuxworld.com.au>
Chris KL just raised an issue on IRC:

test=> create table test (a int4) tablespace pg_default;
ERROR:  permission denied for tablespace pg_default

This wasn't encountered in my original patch because
pg_tablespace_aclmask() had this test reasonably early on:

+   if(tbloid == DEFAULTTBLSPC)
+       return (mask);

I guess that might have been a bit presumptuous but a similar thing
happens if you don't specify a tablespace:
       tablespaceId = get_namespace_tablespace(namespaceId);       /* note no permission check on tablespace in this case */

What should the solution be?

Gavin

В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
Сообщение: Re: lock timeout patch
От: Satoshi Nagayasu
Дата:
Сообщение: Re: lock timeout patch
FAQ