* Tom Lane (t...@sss.pgh.pa.us) wrote: > Simon Riggs <si...@2ndquadrant.com> writes: > > On 9 January 2013 21:42, Tom Lane <t...@sss.pgh.pa.us> wrote: > > I wasn't suggesting that we test for TEMP instead of CREATE; what I > > meant was we would test for CREATE *OR* TEMP to give more options for > > management. > > [ shrug... ] That's weird, ie unlike the behavior of other privileges, > and it *still* doesn't fix any of the problems Stephen complained of.
Not realizing that I needed to grant privileges on the tablespace was my oversight. Having to grant privileges on a tablespace before users can use it is reasonable, imv.. Displaying tablespaces that I don't have access to through 'show temp_tablespaces;' doesn't feel quite right. Having weird cases where we return permission denied errors or use the incorrect tablespace are definitely a problem. Thanks, Stephen
signature.asc
Description: Digital signature