PostgreSQL Tablespace Creation Problem

[robintwos]

I am not able to create a tablespace in PostgreSQL. what should i mention for Location field. What ever i mention, it gives me error saying Table Space location must be an absolute path.

Thanks in Anticipation

[rski]

I am not able to create a tablespace in PostgreSQL. what should i mention for Location field. What ever i mention, it gives me error saying Table Space location must be an absolute path.

Thanks in Anticipation

Give a full path for the location of a tablespace

[robintwos]

Give a full path for the location of a tablespace

I tried giving full path also. like C:\tablespace. Still i am not successful

[rski]

I tried giving full path also. like C:\tablespace. Still i am not successful

show the full query you write

[robintwos]

I could create the TS in postgres user. But i was trying to create another TS outside postgres user. which is failing.

I believe i can't create TS in another user . But still was trying to confirm

This was the SQL i used to create TS in postgres

CREATE TABLESPACE "SampleTS"
OWNER postgres
LOCATION 'C:/Documents and Settings/postgres/SampleTS';

And to create TS in another user , which is failing with an error saying "Could not set permissions on directory"

CREATE TABLESPACE "SampleTS1"
LOCATION 'C:/Documents and Settings/Administrator/SampleTS';

[rski]

I could create the TS in postgres user. But i was trying to create another TS outside postgres user. which is failing.

I believe i can't create TS in another user . But still was trying to confirm

This was the SQL i used to create TS in postgres

CREATE TABLESPACE "SampleTS"
OWNER postgres
LOCATION 'C:/Documents and Settings/postgres/SampleTS';

And to create TS in another user , which is failing with an error saying "Could not set permissions on directory"

CREATE TABLESPACE "SampleTS1"
LOCATION 'C:/Documents and Settings/Administrator/SampleTS';

User must have 'write right' to this directory.