Re: BUG #1488: CREATE TABLESPACE does not work

Jesper Udby wrote:
>
> The following bug has been logged online:
>
> Bug reference:      1488
> Logged by:          Jesper Udby
> Email address:      jesper_pg@judby.dk
> PostgreSQL version: 8.0.1
> Operating system:   Win32 XP Pro SP2
> Description:        CREATE TABLESPACE does not work
> Details:
>
> Hello.
>
> Trying to create a tablespace fails with msg "ERROR:  could not set
> permissions on directory "...": Permission denied".
>
> E.g.
>
> CREATE TABLESPACE pgtest LOCATION 'c:\\pgtest';
>
> (Directory c:\\pgtest exists and is readable etc.)

My bet is that the owner of the directory is not the same as the owner
of the pg server.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073