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