Re: error moving table to tablespace (8.0 beta win32 )

Rajesh Kumar Mallah wrote:

> are you able to create new tables in the default tablespace ?

Yes, permissions are ok.

looks
> like a permission issue did you initdb a fresh folder see if the
> owner of $PGDATA/data/base is the user that running postmaster
> (usually postgres) . It works fine for me though

initdb was run by windows installer

>
> Regds
> mallah
>
> test=# \d t_b
> Table "public.t_b"
> Column | Type | Modifiers
> --------+---------+-----------
> a | integer |
> Tablespace: "space"
>
> test=# ALTER TABLE t_b SET TABLESPACE pg_default;
> ALTER TABLE
> test=# SELECT version();
> version
> --------------------------------------------------------------------------------------------------------------
> PostgreSQL 8.0.0beta1 on i686-pc-linux-gnu, compiled by GCC gcc (GCC)
> 3.3.2 (Mandrake Linux 10.0 3.3.2-6mdk)
> (1 row)
>
> test=#
>

Maybe its only win32 version?

Here what i tried:

CREATE TABLE test (name varchar(100));
CREATE TABLE

CREATE TABLESPACE test LOCATION 'C:\\tmp\\ts_test';
CREATE TABLESPACE

\db
List of tablespaces
Name | Owner | Location
------------+----------+----------------
pg_default | postgres |
pg_global | postgres |
test | postgres | C:/tmp/ts_test
(3 rows)

ALTER TABLE test SET TABLESPACE test;
ALTER TABLE

\d+ test
Table "public.test"
Column | Type | Modifiers | Description
--------+------------------------+-----------+-------------
name | character varying(100) | |
Contains OIDs: yes
Tablespace: "test"

ALTER TABLE test SET TABLESPACE pg_default;
ERROR: could not create relation 1663/317186/1317654: Permission denied

select version();
version

----------------------------------------------------------------------------------------------------------
PostgreSQL 8.0.0beta1 on i686-pc-mingw32, compiled by GCC gcc.exe
(GCC) 3.2.3 (mingw special 20030504-1)
(1 row)

Thanks and regards
Christian