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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to